I'm still in the same problem. I have an error when I edit a user in the database.An error in this line:
" cmd1.ExecuteNonQuery();"
the exception is long:
System.Data.Odbc.OdbcException (0x80131937): ERROR [07002] [Microsoft][Pilote ODBC Microsoft Access]Champ COUNT incorrect.
here is my code:
private void bt_valider_Click(object sender, System.EventArgs e)
{
OdbcConnection cn = new OdbcConnection("DSN=cp3");
try
{
cn.Open();
}
catch
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
OdbcCommand comm;
comm = new OdbcCommand("select * from utilisateur where login=?", cn);
objParameter = comm.Parameters.AddWithValue("login", old_login.Text);
// comm = new OdbcCommand("select * from utilisateur where login='@L'I", cn);
// comm.Parameters.Add("@LI", old_login.Text);
OdbcDataReader rs;
try
{
rs = comm.ExecuteReader();
if (rs.Read())
{
if (rs.GetString(1) == old_pass.Text)
{
rs.Close();
OdbcParameter objParameter2 = new OdbcParameter();
OdbcCommand cmd1 = new OdbcCommand("update utilisateur set login=?,mot_de_passe=?,niveau=?, where login=?", cn);
objParameter2= cmd1.Parameters.AddWithValue("login", new_login.Text);
objParameter2 = cmd1.Parameters.AddWithValue("mot_de_passe", new_pass.Text);
if (new_type.SelectedItem.ToString() == "")
objParameter2 = cmd1.Parameters.AddWithValue("type", "u");
if (new_type.SelectedItem.ToString() == "Administrateur")
objParameter2 = cmd1.Parameters.AddWithValue("type", "a");
if (new_type.SelectedItem.ToString() == "utilisateur")
objParameter2 = cmd1.Parameters.AddWithValue("type", "u");
objParameter2 = cmd1.Parameters.AddWithValue("", old_login.Text);
cmd1.ExecuteNonQuery();
MessageBox.Show(this, "Invalid login or password ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
old_login.Text = "";
old_pass.Text = "";
new_login.Text = "";
new_pass.Text = "";
}
else
MessageBox.Show(this, "Invalid login or password ", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
MessageBox.Show(this, "User does not exist ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception eo)
{
MessageBox.Show(this, "Error System", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
old_login.Text = eo.ToString();
}
}
cn.Close();
}
I planted.Thanks in advance for your help.
sawass sawassPosted Jun 9, 2011, 7:57 AM
Sam HobbsPosted Jun 9, 2011, 7:27 AM
Also please tell us what line of code that that happens at.
sawass sawassPosted Jun 9, 2011, 6:02 AM
Dorababu MekaPosted Jun 9, 2011, 12:13 AM