Quote:
but i want multiple table data to retrieve on single datagridview
You have created one
databale
for the query which you mentioned in your code to retrieve from database.
Now, create one more SQL query and
datatable
to fetch records from another table which you want and add it to newly created
datatable
.
Now create one more
datatable
-
third one. Add data from first & second to it.
First add columns of
datatable 1
& then
datatable 2.
and then,
add data from each tables to this one.
Once you've done with it, use the
new datatable
[
third one] as a
datasource for
grid.
For a similar schema datatable, use
DataTable.Merge Method[
^]