insert database into datatable

Question

I want to create datatable From database at runtime and add values into column according to sql result i created datatable at design time using add new items>dataset i only need to fetch value from database and insert into datatable Can any one help

Sandesh Patil · Answer

DataTable table = new DataTable (); bool ready = false ; try { string sql = select * from table ; con = ConnectionManager .GetDatabaseConnection(); SqlCommand cmd = new SqlCommand (sql con); cmd.CommandType = System.Data. CommandType .Text; SqlDataAdapter da = new SqlDataAdapter (cmd); da.Fill(table); if (table.Rows.Count > 0) { ready = true ; } } I think this will help u....

Sam Hobbs · Answer

What do you need to do with the DataTable? If you need to put the data into a DataGridView you might be able to do that very easily and quickly using a bound data source. Otherwise you can use a TableAdapter that does most of the programming for you.

Hirendra Sisodiya · Answer

Hello mayur dataset is the collection of datatable if you have created dataset form database on design time you can use dataset1.Tables[0] term as datatable.....and perform your task.. thanks Please mark as answere if it helps