why (Object reference not set to an instance of an object)?!

[Jassim Rahma]

I am getting the above error when I upload my website to host but it's working perfectly on my local PC although both are connected to the same database! here is the error followed by the code:

Object reference not set to an instance of an object

[NullReferenceException: Object reference not set to an instance of an object.]
rmconline.salary_slip.btnGenerate_Click(Object sender, EventArgs e) in C:\Users\Jassim\documents\visual studio 2010\Projects\rmconline\rmconline\salary_slip.ascx.cs:70
DevExpress.Web.ASPxEditors.ASPxButton.OnClick(EventArgs e) +96
DevExpress.Web.ASPxEditors.ASPxButton.RaisePostBackEvent(String eventArgument) +540
DevExpress.Web.ASPxClasses.ASPxWebControl.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

and here is my code:

protected void btnGenerate_Click(object sender, EventArgs e)
{
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_get_salary_slip", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.Parameters.Add("param_employee_number", MySqlDbType.Int32).Value = Convert.ToInt32(Session["employee_number"]);
sql_command.Parameters.Add("param_salary_slip_month", MySqlDbType.Int32).Value = Convert.ToInt32(cboMonth.Value);
sql_command.Parameters.Add("param_salary_slip_year", MySqlDbType.Int32).Value = Convert.ToInt32(txtYear.Value);
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;
sql_reader = sql_command.ExecuteReader();
sql_reader.Read();

if (sql\_reader.HasRows)
{
    lblMonth.Text = String.Format("{0} {1:0000}", cboMonth.Text, txtYear.Value);
    lblSalary.Text = "BD " + Convert.ToDouble(sql\_reader\["salary\_slip\_salary"\]).ToString("#,###,##0.000");

    panelNoSalarySlip.Visible = false;
    panelSalarySlip.Visible = true;

    sql\_connection.Close();

    populate\_salary\_slip\_details();
}
else
{
    panelSalarySlip.Visible = false;
    panelNoSalarySlip.Visible = true;

[Simon_Whale]

jrahma wrote:

sql_adapter = new MySqlDataAdapter(sql_command);

the above you should change to include you connection object i.e.

sql_adapter = new MySqlDataAdapter(sql_command, sql_connection);

further reading MySQL DataAdapter[^]

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

[Luc Pattyn]

jrahma wrote:

[NullReferenceException: Object reference not set to an instance of an object.] rmconline.salary_slip.btnGenerate_Click(Object sender, EventArgs e) in C:\Users\Jassim\documents\visual studio 2010\Projects\rmconline\rmconline\salary_slip.ascx.cs:70 DevExpress.Web.ASPxEditors.ASPxButton.OnClick(EventArgs e) +96 DevExpress.Web.ASPxEditors.ASPxButton.RaisePostBackEvent(String eventArgument) +540

Running a debug build rather than a release build would yield actual file name, class name AND line numbers for where the exception exactly gets thrown; from there it is a matter of seconds to pinpoint the problem. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum