SELECT statement using Dynamic Data

Question

hi, I am using visual studio.net and sql server 2000, I use a dataset to store some dynamic data and I need to use these dynamic data to select the rows from a table in sql server 2000. how to create a DYNAMIC SELECT statement to access the sql server 2000? eg. SELECT * FROM Lineitem WHERE LineNumber = "Dynamic Data" This "Dynamic Data" is queried from some function in my c# program and the values are stored in a data set and it is a condition in the SELECT statement. thanks