how to databind datagridview with datatable (C#)

Question

Hi,

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

Answer 1

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

Answer 2

Once you have the datatable just do the following:

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

That should be all you need to do.