Below there is code for update button the error for this code is mentioned in subject line.
private void update_Click(object sender, EventArgs e)
{
try
{
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (securityname.SelectedItem.ToString() == dr[0].ToString())
{
break;
}
}
cmd.Parameters.AddWithValue("@User_Id", OleDbType.VarChar);
cmd.Parameters.AddWithValue("@Security_Name", OleDbType.VarChar);
cmd.Parameters.AddWithValue("@qty_bought", OleDbType.Integer);
cmd.Parameters.AddWithValue("@qty_sold", OleDbType.Integer);
cmd.Parameters.AddWithValue("@Rate_Security", OleDbType.Double);
cmd.Parameters.AddWithValue("@Total_security", OleDbType.Double);
cmd.Parameters.AddWithValue("@Brokerage", OleDbType.Double);
cmd.Parameters.AddWithValue("@Net_Rate", OleDbType.Double);
cmd.Parameters.AddWithValue("@Service_Tax", OleDbType.Double);
cmd.Parameters.AddWithValue("@Stt_Amt", OleDbType.Double);
cmd.Parameters.AddWithValue("@Total_Amt", OleDbType.Double);
cmd.Parameters.AddWithValue("@Net_Delivery", OleDbType.Double);
cmd.Parameters.AddWithValue("@Tran_Charges", OleDbType.Double);
cmd.Parameters.AddWithValue("@Sec_Tran_Charges", OleDbType.Double);
cmd.Parameters.AddWithValue("@Stamp_Duty", OleDbType.Double);
cmd.Parameters.AddWithValue("@Total_due", OleDbType.Double);
cmd.Parameters.AddWithValue("@NSE", OleDbType.Boolean);
cmd.CommandText = "Update Security SET qty_bought=@qty_bought,qty_sold=@qty_sold,Rate_Security=@Rate_Security,Total_Security=@Total_Security,Brokerage=@Brokerage,Net_Rate=@Net_Rate,Service_Tax=@Service_Tax,Stt_Amt=@Stt_Amt,Total_Amt=@Total_Amt,Net_Delivery=@Net_Delivery,Tran_Charges=@Tran_Charges,Sec_Tran_Charges=@Sec_Tran_Charges,Stamp_Duty=@Stamp_Duty,Total_due=@Total_due,NSE=@NSE Where Security_Name=@Security_Name AND User_Id=@User_Id";
securityTableAdapter.Update(strUserId, Convert.ToInt32(Qty_biught.Text), Convert.ToInt32(qty_sold.Text), Convert.ToDouble(gross_rate.Text), Convert.ToDouble(tot.Text), Convert.ToDouble(broker.Text), Convert.ToDouble(Net_rate.Text), Convert.ToDouble(Serv_Tax.Text), Convert.ToDouble(stt_amt.Text), dTot, Convert.ToDouble (Net_Del.Text), Convert.ToDouble(Tran_chr.Text), Convert.ToDouble(Sec_tran_tax.Text), Convert.ToDouble(stamp_duty.Text), Convert.ToDouble(bal_amt.Text), NSE.Checked, dr[0].ToString(), dr[1].ToString(), Convert.ToInt32(dr[2].ToString()), Convert.ToInt32(dr[3].ToString()), Convert.ToDouble(dr[4].ToString()), Convert.ToDouble(dr[5].ToString()), Convert.ToDouble(dr[6].ToString()), Convert.ToDouble(dr[7].ToString()), Convert.ToDouble(dr[8].ToString()), Convert.ToDouble(dr[9].ToString()), Convert.ToDouble(dr[10].ToString()), Convert.ToDouble(dr[11].ToString()), Convert.ToDouble(dr[12].ToString()), Convert.ToDouble(dr[13].ToString()), Convert.ToDouble(dr[14].ToString()), Convert.ToDouble(dr[15].ToString()), Convert.ToBoolean(dr[16].ToString()));
dr.Close();
cmd.ExecuteNonQuery();
Security_name.Text = securityname.Text;
securityname.Visible = false;
Security_name.Visible = true;
con.Close(); }
catch (Exception ex)
{
con.Close();
MessageBox.Show(ex.ToString());
}
}
Bold code is having a exception and I made all initialization regarding Connection and Command in Load_Form().
modified on Thursday, June 9, 2011 12:31 AM
|