Israel

Israel

  • 699
  • 1.3k
  • 217.3k

When button its clicked for the segond time. Its sturk...

Jul 2 2016 11:03 AM
Hi!
 
I need to understand why this code doesnt work properly when I need to edit the segund time (after to click on my button). See what error message I receive:
Additional information: Format of the initialization string does not conform to specification starting at index 0.
 
conn = new OleDbConnection(connstr); // Its sturk here only when I click to edit for the segond time with others datas
comm = new OleDbCommand();
conn.Open();
OleDbParameter s = new OleDbParameter("@s", SqlDbType.VarChar);
OleDbParameter id = new OleDbParameter("@id", SqlDbType.VarChar);
comm.Parameters.Add(s);
comm.Parameters.Add(id);
s.Value = '-';
id.Value = lblId.Text;
comm.Connection = conn;
comm.CommandText = "UPDATE fluxocaixa SET s = ? WHERE (id = ?)";
comm.ExecuteNonQuery();
{
conn.Close();
}
 
 

Answers (4)