How to populate a Datagridview in Windows Forms

Chris Johnson

3y804C#

Hi all.

I have a very simple Windows form.
This contains one textbox and a Datagridview. This will be using ODBC to an AS400 table which is already set up.
I want to add an SQL where statement where it brings only the record based on the textbox.
I can do this very easily in .Net just not sure how to go about this in Windows forms?

The SQL statement this is what I am trying to create.

SELECT AMFLIB.MOMASTLB.ORDRMY as Order, AMFLIB.MOMASTLB.FITMMY as Item, AMFLIB.ITEMASA.ITDSC as Description
FROM AMFLIB.MOMASTLB INNER JOIN AMFLIB.ITEMASA ON AMFLIB.MOMASTLB.FITMMY = AMFLIB.ITEMASA.ITNBR
WHERE (((AMFLIB.MOMASTLB.ORDRMY)=?))

1 Reply

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

Naimish Makwana3y ago
Hello Chris,

Populate datagridview in window form you need to do below:

As you know in .net C# how to get data from query in Datatable. Once you have data into your data table. just need to bind that with gridview.
```
dataGridView1.DataSource = dataTable;
```
Thanks

Naimish Makwana