How to write statement when calling tableadapter of a dataset

weifan99

As the title, I built a data set and built a tableadapter in it. The statement assumes: select a, b, c, d, e from table1.
In the form, I pulled a datagridview and bound the tableadapter as follows
dsBillTableAdapters.ICStockBillTableAdapter da = new dsBillTableAdapters.ICStockBillTableAdapter ();
            this.iCStockBillTableAdapter.Fill (this.dsBill.ICStockBill);

You can get the results found by selecting a, b, c, d, e from table1. But now I want to add where a = 1 to the end of the statement when I call it. What should I do?

ak41sl

Handle when selecting. The condition of WHERE a = 1 is added to the SQL statement.

SELECT a, b, c, d, e FROM table1 WHERE a = 1

weifan99

I do n’t want to deal with it when I select it, because I have a bunch of filter conditions on the form, written as a string, and I want to add it after the select

lisongfox

Front SQL

string sWhere = "not exists (select 1 from table1 tb where table1. primary key = tb. primary key and tb.a = 1)"

Add this to the condition

weifan99

How to add?
Now I am forced to write the statement as a stored procedure, as exec (@a), and then pass the parameters to the stored procedure, such as and a = 1, then @ a = 'select a, b, c, d, e from table where 1 = 1 '+ parameter