Questa routine mi provoca il seguente errore:
Object reference not set to an instance of an object.
L'errore me lo segnala dopo la stringa sql, esattamente quando c'è:
cmd.Parameters.Add("UserCode", SqlDbType.VarChar).Value = UserCode.ToString();
Qualcuno potrebbe essere così gentile da dirmi dove cavolo sbaglio?????? Ho bisogno di aiuto!!!!!!
public void update_record(object sender, EventArgs e)
{
string id = Request.Params["id"];
SqlConnection myConn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
myConn.Open();
string strSQL = "UPDATE tab_User SET UserCode=?, Name=?, Possible=?, Address=?, Zip=?, City=?, CountryCode=?, ISOCode=?, State=?, FiscalNumber=?, VATNumber=?, Phone=?, Mobile=?, EMail=?, Expanse=?, BankCode=?, CurrentAccount=?, CreditCardCode=?, ZoneCode=?, LanguageCode=?, ExpireDate=?, Note=? WHERE ID=" + id;
SqlCommand cmd = new SqlCommand(strSQL, myConn);
cmd.Parameters.Add("UserCode", SqlDbType.VarChar).Value = UserCode.ToString();
cmd.Parameters.Add("Name", SqlDbType.VarChar).Value = Name.ToString();
cmd.Parameters.Add("Possible", SqlDbType.VarChar).Value = Possible.ToString();
cmd.Parameters.Add("Address", SqlDbType.VarChar).Value = Address.ToString();
cmd.Parameters.Add("Zip", SqlDbType.VarChar).Value = Zip.ToString();
cmd.Parameters.Add("City", SqlDbType.VarChar).Value = City.ToString();
cmd.Parameters.Add("CountryCode", SqlDbType.VarChar).Value = CountryCode.ToString();
cmd.Parameters.Add("ISOCode", SqlDbType.VarChar).Value = ISOCode.ToString();
cmd.Parameters.Add("State", SqlDbType.VarChar).Value = State.ToString();
cmd.Parameters.Add("FiscalNumber", SqlDbType.VarChar).Value = FiscalNumber.ToString();
cmd.Parameters.Add("VATNumber", SqlDbType.VarChar).Value = VATNumber.ToString();
cmd.Parameters.Add("Phone", SqlDbType.VarChar).Value = Phone.ToString();
cmd.Parameters.Add("Mobile", SqlDbType.VarChar).Value = Mobile.ToString();
cmd.Parameters.Add("EMail", SqlDbType.VarChar).Value = EMail.ToString();
cmd.Parameters.Add("Expanse", SqlDbType.VarChar).Value = Expanse.ToString();
cmd.Parameters.Add("BankCode", SqlDbType.VarChar).Value = BankCode.ToString();
cmd.Parameters.Add("CurrentAccount", SqlDbType.VarChar).Value = CurrentAccount.ToString();
cmd.Parameters.Add("CreditCardCode", SqlDbType.VarChar).Value = CreditCardCode.ToString();
cmd.Parameters.Add("ZoneCode", SqlDbType.VarChar).Value = ZoneCode.ToString();
cmd.Parameters.Add("LanguageCode", SqlDbType.VarChar).Value = LanguageCode.ToString();
//cmd.Parameters.Add("ExpireDate", SqlDbType.DateTime).Value = ExpireDate.ToString();
cmd.Parameters.Add("Note", SqlDbType.Text).Value = Note.ToString();
cmd.ExecuteNonQuery();
myConn.Close();
detailPanel.Visible = true;
editPanel.Visible = false;
}
Rispondi quotando
