convert data table to dataset in c#.net

Question

hi can any one help me how to convert data table to data set or gridview to dataset Thanks & Regards Kumar

Santhosh Kumar Jayaraman · Answer

You cannot convert datatable to dataset. Dataset is a container which can hold many datatables. You can create new dataset and add your datatable to it. DataSet ds=new DataSet(); ds.Tables.Add(dt); here dt is my datatable.

venkata kumar · Answer

hi this is the way to convert datagridview to dataset DataSet ds2 = ((DataView)dataGridView1.DataSource).Table.DataSet;

Nilesh Sawardekar · Answer

DataSet is nothing but a collection of DataTables. So to "load" the dataTable into dataSet simple Add it: DataTableemployees=newDataTable(); DataSetds=newDataSet(); ds.Tables.Add(employees);

Biswa Pujarini Mohapatra · Answer

You can try this DataTable dt = new DataTable(); for (int i = 0; i { dt.Columns.Add("column"+i.ToString()); } foreach (GridViewRow row in GridView1.Rows) { DataRow dr = dt.NewRow(); for(int j = 0;j { dr["column" + j.ToString()] = row.Cells[j].Text; } dt.Rows.Add(dr); }

jak npie · Answer

if dataset can be a container of some datatable so a datatable can has one of datatable by index as follow: DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlDataAdapter adaptor = new SqlDataAdapter(new sqlcom); adaptor.Fill(ds); dt = ds.Tables[0];// or avery index of it //and then..... GridView1.DataSource = dt; GridView1.DataBind(); have luck

jak npie · Answer

if dataset can be a container of some datatable so a datatable can has one of datatable by index as follow: DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlDataAdapter adaptor = new SqlDataAdapter(new sqlcom); adaptor.Fill(ds); dt = ds.Tables[0];// or avery index of it //and then..... GridView1.DataSource = dt; GridView1.DataBind(); have luck

venkata kumar · Answer

this is wrong

venkata kumar · Answer

hi santhosh can u help me how to assign datagridview data to data set or data table Thanks & Regards KUmar

Vishnujeet Kumar · Answer

data bind in gridview SqlConnection con; SqlCommand com; SqlDataAdapter DA; con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["AppConnect"].ConnectionString; con.Open(); com = new SqlCommand(); com.CommandText = "SELECT T* FROM PRODUCTS"; com.CommandType = CommandType.Text; com.Connection = con; DA = new SqlDataAdapter(); DA.SelectCommand = com; DataSet ds = new DataSet(); DA.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); DA.Dispose(); con.Dispose(); con.Dispose();

convert data table to dataset in c#.net

Answers (9)