Stored Procedure

Hi guys,

Can someone knows how to access my stored procedure.

Example:

My stored procedure name was: selectsample

I want to use that but incorporated with where.

Example: SqlCommand comforroom = new SqlCommand("selectsample", conn);

My problem was I was sorting base on the textbox1...

I tried this: "Selectsample where name = '" + textbox1.text + "' - is this code right???

thanks.

annir..