Okay. I was just reading your original post which indicated that you intended to (perhaps originally) code the Text_Changed event. Looks like you've got it under control.

Good luck.

Try this. Just paste the code into a button's click event. You'll need to change the items shown bold to match your database settings.

string oConnString = "Data Source=localhost;Initial Catalog=ALocalDataBase;Integrated...

Hmmm…does this work for you? Have you tried entering an ID with more than 1 character? What I’m getting at, is simply this: the TextChanged event will fire each time...