finding a record in a table

[steve_rm]

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.

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

[fret]

try...just try:

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

hope it helps.