How we can find(search) a record in C# using sql server 2000

Question

How we can find(search) a record in C# using sql server 2000

How we can find(search) a record in C# using sql server 2000.
like when we select the user id then show all the record in c# form.
if anybody have a solution plz forward it.
plese give the code in C#
plz give the code immedietly

Muhammad Shahid Farooq · Answer

I replied you second time use the following query for serching the record from database: Select * from tableName where columnName like 'a%' Above query is used for finding all the records that are started with a.

Ryan Alford · Answer

as I posted in your other topic....do you know how to write a SQL query? what exactly are you asking for?