Loading the Database from Website

Every time I try to use the code bellow to take the information in the given text boxes or drop down list etc... I get a null error reference {'Object reference not set to an instance of an object.'} and it says I should use the NEW Keyword? Any thoughts on why this is? I'm connected to my database, And this has worked for me in the past.


Protected Sub EQBT_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles EQBT.Click

SqlDataSourceEQ.InsertParameters('EquipmentID').DefaultValue = EquipmentNumBox.Text
SqlDataSourceEQ.InsertParameters('Year').DefaultValue = YearBox.Text
SqlDataSourceEQ.InsertParameters('Make').DefaultValue = MakeBox.Text
SqlDataSourceEQ.InsertParameters('Model').DefaultValue = ModelBox.Text
SqlDataSourceEQ.InsertParameters('Vin#').DefaultValue = SerialVinBox.Text
SqlDataSourceEQ.InsertParameters('Type').DefaultValue = TypeBox.Text
SqlDataSourceEQ.InsertParameters('FuelType').DefaultValue = FuelBox.Text
SqlDataSourceEQ.InsertParameters('License#').DefaultValue = LicenseBox.Text
SqlDataSourceEQ.InsertParameters('DriverID#').DefaultValue = DriverBox.Text
SqlDataSourceEQ.InsertParameters('APartOf').DefaultValue = PartofBox.Text
SqlDataSourceEQ.InsertParameters('GreasePoints').DefaultValue = GreaseBox.Text
SqlDataSourceEQ.InsertParameters('OilFilter#').DefaultValue = OilBox.Text
SqlDataSourceEQ.InsertParameters('FuelFilter#').DefaultValue = FuelFilterBox.Text
SqlDataSourceEQ.InsertParameters('HydraulicFilter#').DefaultValue = HydraulicBox.Text
SqlDataSourceEQ.InsertParameters('AirFilter#').DefaultValue = AirBox.Text
SqlDataSourceEQ.InsertParameters('Description').DefaultValue = EQDescriptionBox.Text


Try
SqlDataSourceEQ.Insert()
EquipmentNumBox.Text = ''
YearBox.Text = ''
MakeBox.Text = ''
ModelBox.Text = ''
SerialVinBox.Text = ''
TypeBox.Text = ''
FuelBox.Text = ''
LicenseBox.Text = ''
DriverBox.Text = ''
PartofBox.Text = ''
GreaseBox.Text = ''
OilBox.Text = ''
FuelFilterBox.Text = ''
HydraulicBox.Text = ''
AirBox.Text = ''
EQDescriptionBox.Text = ''


Message.Text = 'New Equipment added'

Catch ex As Exception
Message.Text = 'Their was an ERROR, Please Enter All Data Fields With Correct Data'

End Try
End Sub

 

Hi,
You can get a lot more help with this in the ASP.NET forums but I'll try and give a little input.


Without seeing the rest of your code...


The mention of New makes sense with Sub calls, since that Sub should break out.
New subs/functions would build values. Typical for things like data aware combos.


Instead of doing the Insert like that you might want to try the InsertParameters method, then the Insert.
Salute,
Mark

 

c# and mysql database page

.class



using System;


using System.Data;


using System.Configuration;


using System.Web;


using System.Web.Security;


using System.Web.UI;


using System.Web.UI.WebControls;


using System.Web.UI.WebControls.WebParts;


using System.Web.UI.HtmlControls;


using System.Data.SqlClient;


using System.IO;





public static SqlConnection sqlBaglanti = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["Baglanti"]);


Baglanti = web config


public static DataView Toplam_kayitlar(string sql)


{


SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlBaglanti);


DataSet ds = new DataSet();


sqlAdapter.Fill(ds);


sqlBaglanti.Close();


return ds.Tables[0].DefaultView;


}





desinger code


DataView BayiTalep = personel_kontrol.Toplam_kayitlar("Select * from teknikDestek ");





txtname.text = BayiTalep [0]["Haber_Baslik"].ToString();





web config


<add key="Baglanti" value="data source=ip;UID=test; pwd=111;initial Catalog=dbname"/>

thx
http://www.evdenevenakliyatbul.com/
http://www.akdeniznakliyat.com.tr/
http://www.isikevdenevenakliyat.com/