Quote:but i want multiple table data to retrieve on single datagridview
You have created one
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
Now create one more
- third one.
Add data from first & second to it.
First add columns
and then, add data
from each tables to this one.
Once you've done with it, use the
] as a datasource
For a similar schema datatable, use DataTable.Merge Method