Retrieve From Table into DataGrid

Question

Hello I know this is easy but I cannot find a simple way of loading a table into a dataSet to be used in a Datagrid. The part I cannot figure out is how to load a table in a DataSet from a database table. Any Help would be greatly appreciated. Thanks!

crend_king · Answer

First create and open a Connection. You can do this. Second establish a Command (cmd) add SELECT statement to it. Third use the following codes (You may change OleDb to something else): //dg is your DataGrid DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); dg.DataSource = ds.Tables[0]; dg.DataBind(); da.Dispose();

Mahesh Chand · Answer

There are many samples in ADO.NET section of c-sharpcorner.com