how can fill dataset by gridview in c# .net

how can fill datatable by gridview with c# i m applying that code but that error occur Input array is longer than the number of columns in this table. my code is that

private void button4_Click(object sender, EventArgs e)

{

DataSet d = new DataSet();

DataTable dt = new DataTable();

// add the columns to the datatable

//if (dataGridView4.Rows.Count!=null)

//{

for (int i = 0; i < dataGridView4.Rows.Count-1; i++)

{

//for (int j = 0; j < dataGridView4.Columns.Count; i++)

//{

//for (int i = 0; i < dataGridView4.HeaderRow.Cells.Count; i++)

//{

dt.Rows.Add(dataGridView4.Rows[i].Cells[0].Selected.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[1].Selected.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[2].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[3].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[13].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[18].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[19].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[21].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[22].Value.ToString());

dt.Rows.Add(dataGridView4.Rows[i].Cells[23].Value.ToString());

da = new OleDbDataAdapter();

da.Fill(d, "dt");

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

poonam tyagi12y ago
sir i do not wants that fill dataset from grid view , in my gridview data has comes but i want to take that data in dataset that i was created for containing the data of thats comes in the gridview
0
Dipankar Biswas12y ago
string sql = "select * from lide";
SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
ds.Tables.Add("lide");
adapter.Fill(ds, "lide");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "lide";
0