How to bind Dataset to DataGridView in windows application

by

following will show one table of dataset 

DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = ds; // dataset
DataGridView1.DataMember = "TableName"; // table name you need to show

if you want to show multiple tables, you need to create one datatable or custom object collection out of all tables.

if two tables with same table schema 

dtAll = dtOne.Copy(); // dtOne = ds.Tables[0]
dtAll.Merge(dtTwo); // dtTwo = dtOne = ds.Tables[1]

DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = dtAll ; // datatable

sample code to mode all tables 

DataTable dtAll = ds.Tables[0].Copy();
for (var i = 1; i < ds.Tables.Count; i++)
{
     dtAll.Merge(ds.Tables[i]);
}
DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = dtAll ;

More Related Contents:

  1. How can I do an average reverse in c#? [closed]
  2. How to execute a stored procedure within C# program
  3. How do I match an entire string with a regex?
  4. How to load image to WPF in runtime?
  5. Using parameters inserting data into access database
  6. RichTextBox syntax highlighting in real time–Disabling the repaint
  7. Binding List to DataGridView in WinForm
  8. Is it considered acceptable to not call Dispose() on a TPL Task object?
  9. Difference between forward slash (/) and backslash (\) in file path
  10. UnityWebRequest Embedding User + Password data for HTTP Basic Authentication not working on Android
  11. How to convert DateTime to/from specific string format (both ways, e.g. given Format is “yyyyMMdd”)?
  12. How to compare arrays in C#? [duplicate]
  13. How to get number of rows using SqlDataReader in C#
  14. C# – Making all derived classes call the base class constructor
  15. internal vs public in C#
  16. Mocking Static methods using Rhino.Mocks
  17. Deserializing XML File with multiple element attributes – attributes are not deserializing
  18. “A referral was returned from the server” exception when accessing AD from C#
  19. NHibernate – Many to Many Query using Junction/Joiner Table
  20. Optimal way to Read an Excel file (.xls/.xlsx)
  21. Fixed size queue which automatically dequeues old values upon new enqueues
  22. TPL Dataflow exception in transform block with bounded capacity
  23. Placing Images and Strings with a C# Combobox
  24. Developing C# on Linux [closed]
  25. Is BitArray faster in C# for getting a bit value than a simple conjuction with bitwise shift?
  26. C# Compiler should give warning but doesn’t?
  27. UI Automation “Selected text”
  28. Regular expression for version numbers
  29. Rotation Matrix given angle and point in X,Y,Z
  30. Class Mapping Error: ‘T’ must be a non-abstract type with a public parameterless constructor

Leave a Comment