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