finding a record in a table

Hello

I want to be able to get one record from the teacher's table and still the record in the Database. The user will enter the ID number and then press a find button. The contents of this record can be
displayed in some text boxes.

Code:

---

cnnTeacher.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\IBS Library System\LibrarySystem.mdb;Persist Security Info=False";
                                OleDbDataAdapter daTeacher = new OleDbDataAdapter("SELECT * FROM Teacher WHERE teacherID = '" + txtIDNumber.Text + "' ",cnnTeacher);
                                OleDbCommandBuilder cbTeacher = new OleDbCommandBuilder(daTeacher);
                               
                                daTeacher.Fill(dtTeacher);
                               
                                txtName.text = //code to go here for display the name of the teacher from finding ID number

---

Many thanks in advance

try...just try: :lol:

VB Code:

daTeacher.Fill(dtTeacher);
txtName.Text=dtTeacher.Rows[0][1].ToString();

hope it helps.