rerive id of a textvalue from sql server in asp.net

how can i retrive of id of a textbox value.i am enter a  data from into a textbox ,now i want the id of that  value from sql server,..
and pass the id to the nest page by session value..
thanks in advance,,
my database structure is following::
id int(10);
name varchar(50);
desg varchar(20);
how can i get the id of a specific name.in my application the name is entered into a textbox..
plz help..
thanks in advance,,