How to use Where clause with DataSet in C# Win form

Question

I use adgv (advanced filter) to my dataGridView with DataBindingSource

computerDataSet is my Dataset

computerBindingSource is my BindingSourse

and computerTableAdapter is my TableAdapter

In my Load form it creats this one to load data from my table "Computer"

this.computerTableAdapter.Fill(this.computerDataSet.Computer);

But I have departmentId in my Computer table "deptId" and I want to use "Where Clause..." I want to put condition but I don't know how to do it. In linq I would do like this

var computers = db.Computer.Where(x =>x.deptId == departmentId).Tolist(); // I have value of departmentId

But How can I put like Where condition in this code

this.computerTableAdapter.Fill(this.computerDataSet.Computer);

Thank you guys in advance!

@Charlieface , thank you for your response. Please I am new for this kind of staff and I dont know what you mean to change SelectCommand. Cna you please write me some code what and how do you mean? — Anna, Feb 22 '21 at 20:52
No I can't because I have no idea where that adapter comes from, you have provided no code for it — Charlieface, Feb 22 '21 at 20:57
@Charlieface . it creats it' self when I create connection with BindingSourse — Anna, Feb 22 '21 at 21:08

score 0 · Answer 1 · answered Feb 23 '21 at 20:22

0

Advanced DatagridView Tasks I clicked "Add Query" and Created a new query

answered Feb 23 '21 at 20:22

Anna

69
1
10

score 0 · Answer 2 · answered Mar 13 '21 at 18:17

0

You open the DataSet file where the tableadapter lives, right click on it and choose Add Query. You can add any number of queries to a tableadapter

answered Mar 13 '21 at 18:17

Caius Jard

72,509
5
49
80

How to use Where clause with DataSet in C# Win form

2 Answers2