Loading

SELECT statement using Dynamic Data

sunspotzzz

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

sunspotzzz22y ago
Hi, that works! thanks a lot for the help.
Mahesh Chand22y ago
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() ;
miker22y ago
Did you try it? Did you get any error message?