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

sunspotzzz · Answer

Hi that works! thanks a lot for the help.

Mahesh Chand · Answer

if dynamic data is string use this: string dynamicData = something; SELECT * FROM Lineitem WHERE LineNumber = ' + dynamicData + '; for int long etc use this: int dymanicData = 20; SELECT * FROM Lineitem WHERE LineNumber =  + dynamicData.ToString() ;

miker · Answer

Did you try it? Did you get any error message?