Display data from ms access database.....

[raj231362]

hello everyone, i have a prop in displaying data from access database. i didn't under stand where i done mistake. i want to edit save data from database.when user enter emp_code and click edit button, then he displa all specific records related to that emp_id. help me...!!

[Matjaz xyz]

u could put some more info on wheres the problem with a sample code and more description...

Força Barça!

[raj231362]

here is my code..... for delete:- private void button3_Click(object sender, EventArgs e) { conn.Open(); string command1 = "delete from employee where (emp_id = ? AND emp_code = ? AND emp_name = ? AND emp_address = ? AND emp_dob = ? AND emp_doj = ? AND emp_dor = ?)"; OleDbDataAdapter da = new OleDbDataAdapter(command1, conn); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; conn.Close(); } for edit:-- private void button2_Click(object sender, EventArgs e) { conn.Open(); string sqlcom = "select emp_id,emp_code,emp_name,emp_address,emp_dob,emp_doj,emp_dor from employee where (emp_code=?)"; OleDbDataAdapter da = new OleDbDataAdapter(sqlcom , conn); DataSet ds = new DataSet(); //ds.Clear(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { int a = Convert.ToInt32(ds.Tables[0].Rows[0]["emp_id"]); textemp_id.Text = a.ToString(); } else { MessageBox.Show("This E-Code does not exist"); } conn.Close(); } i am new in c#..this code is not working..if any change plz modify it. Thanks