Created table to fetch static from SQL server. I am able to connect to DB. But in Query text field (I followed this link : http://www.capturedocs.com/thread/4283-using-text-captured-in-another-field-in-the-search-text-from-database-query-text/ ). Using SQL server, Table name is : Test_static. Column names are Name and Pan
SQL Query : SELECT Name FROM Test_static WHERE Name=vName.Value.
After clicking apply. It shows error like this : Warning: DB provider can not parse query string. Proceed anyway?
Please help..
コメント
1件のコメント
Hello,
As described in the referenced case, you should first prepare query as string, in your case:
string e="SELECT Name FROM Test_static WHERE Name=" + Name.Value + ";'";
then pass this query string as a parameter to SearchTextFromDB() method.
サインインしてコメントを残してください。