how to databind datagridview with datatable (C#)

Question

I want to bind datagridview in windows application with dynamically changed datatable.

I have windows form with two textboxes, one for connection string with sql server and the other for sql query string. I just want to display data in datagridview in order to see data. I don't need anything fancy, just to read result of sql query.

Thanks in advance!

DP

score 2 · Accepted Answer · answered Aug 23 '10 at 09:41

2

Just assign the DataTable to the Datasource property of the DataGridView.

answered Aug 23 '10 at 09:41

leppie

115,091
17
196
297

I did that, but I got an empty datagridview even if dataTable has 1 row. :( – Draško Aug 23 '10 at 09:54
3

Did you disable `AutoGenerateColumns` maybe? – leppie Aug 23 '10 at 09:55
Thanks leppie. I have the same issue but after done autogeneratedcolumn = true resolved my problem. Thanks – Dinesh Kumar Dec 23 '13 at 11:30

score 0 · Answer 2 · answered Aug 23 '10 at 09:45

0

Once you have the datatable just do the following:

myDataGrid.DataSource = myDataTable;
myDataGrid.DataBind();

That should be all you need to do.

answered Aug 23 '10 at 09:45

Giles Smith

1,952
15
17

how to databind datagridview with datatable (C#)

2 Answers2