Hello!
I would like to update my data. Its works well. Its do it for all the column. Before that I sorting the datas... Then I change what I want on my textbox. Suddlendly after to click its do it for all the column "name". It's very starnge!!!
Have a look:
for search:string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\test\\app_data\office.mdb;Persist Security Info=False";
OleDbConnection sqlCon = new OleDbConnection(connectionString);
sqlCon.Open();
string commandString = "select * from full_registardemissao where name='" + cbxFuncionarioRegistardemissao.Text + "'";
OleDbCommand sqlCmd = new OleDbCommand(commandString, sqlCon);
OleDbDataReader read = sqlCmd.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
mskTxtDatademissao.Text = read["datademissao"].ToString(); // it will show the code
txtMotivoRegistardemissao.Text = read["motivo"].ToString(); // it will show the code
}
}
else
{
MessageBox.Show("A record with a code of " + mskTxtDatademissao.Text + " was not found");
}
read.Close();
sqlCon.Close();
for update:
Conn.Open();
oleDbCmd.Connection = Conn;
oleDbCmd.CommandText = "UPDATE full_registardemissao SET name= '" + cbxFuncionarioRegistardemissao.Text + "'";
oleDbCmd.ExecuteNonQuery();
{
{
MessageBox.Show("Datas saved!");
}
Conn.Close();
}