retrieving data

[joyce85]

hai


in form1 i have 3 textboxes...

when i enter value in first box
i should get other two boxes to have values from the database...
i used select and update commands for that
but i am not able to do...
help me

[kenobewan]

You will need to activate a function in your source code based on a user initiated event from their using first text box...

Hope that this helps.

[joyce85]

private void UpdateButton_Click(object sender, System.EventArgs e)
{
try
{
con=new OleDbConnection(conString);
string str="Select First_Name,ID From Employee where SI_No=("+textBox1.Text+")";
con.Open();
cmd=new OleDbCommand(str,con);
rdr=cmd.ExecuteReader();
rdr.Read();
textBox2.Text=rdr[0].ToString();
textBox3.Text=rdr[1].ToString();
rdr.Close();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}

try
{
con=new OleDbConnection( constring);
string str1="Update Employee Set First_Name=('"+textBox2.Text+"'),ID=("+textBox3.Te xt+") where SI_No=("+textBox1.Text+")";
con.Open();

cmd1=new OleDbCommand(str1,con);
cmd1.ExecuteNonQuery();
//MessageBox.Show("Record updated");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}

}


is it correct?


because i want to retrive data frm database and need to update it at the same time...

how could i do that?

[kenobewan]

This looks close... If you get an error on the first you will want to exit the function as the second won't work. Good use of try catch and opening and closing connection. I would only expect a syntax error - have you tested?

[joyce85]

This looks close... If you get an error on the first you will want to exit the function as the second won't work. Good use of try catch and opening and closing connection. I would only expect a syntax error - have you tested?

thanks for your reply....
i finished thay...

[joyce85]

thanks for your reply....
i finished thay...

how can i get values at a selected index of a dataGrid...but i am able get the index not the values