Hoe to Store Value From Dataset To SQL Database

See more:

C#

.NET

C#4.0

.NET4

Hello All

I have A Dataset and i also created some rows, but i want to add this table in my database

how is that possible..??

plz help...

DataSet ds1 = new DataSet();

           DataTable dt = new DataTable("Emp");

           dt.Columns.Add("Name",typeof(string));
           dt.Columns.Add("Address",typeof(string));
           dt.Columns.Add("Phone", typeof(string));

           DataRow dr = dt.NewRow();
           dr["Name"] = "Sandeep Aparajit";
           dr["Address"] = "Redmond USA";
           dr["Phone"] = "425-000-0000";
           dt.Rows.Add(dr);

           ds1.Tables.Add(dt);

           dataGridView2.DataSource = ds1.Tables[0];