How to implement Microsoft SQL Server commands in C# windows forms?

Question

C++ / C#

The problem is this: I need to have only 5th grade students in the DataGridView. How can be done?

Answer 1

For the DataAdapter, put the SelectCommand inselect * from Classes where Класс=5

Answer 2

How can be done?

select-om, from-om and where-swarm