Need help about ERp system

Question

I work on ERP system  and want to know
How I can find(search) a record in C# using sql server
like when I select the user ID then show all the record that used or related to this ID it in c# form.