How to insert a new row into datagridview(bound to database)

Question

There is a link for inserting new record on datagridview. http://www.mindstick.com/Articles/4c22202b-c1e7-47f2-a1f8-5ac72662ee91/?Insert,%20Update,%20Delete%20in%20DataGridView

So we can fill in the text into textboxs and click the button. But my question is that if the gridview is populated like http://pedromj.dyndns.org/publico/DataGridViewWindows01.png. Can we pass the parameters from the last blank row cells to datasource? Thus we can make the the interface nice and neat.

Need code(C#) assistance.

Thank you very much.

Answer 1

Hi：）

Yes I think so——If you bind the DataTable generated from a SqlDataAdapter to the DataGridView，and once you've added rows to the GridView，it will be also mapped to the real DataTable。But you should drag and drop a button and click to write the modified things into real table by using：

SqlDataAdapter.Update(DataTable instance);

---

   QQ我：
下载MSDN桌面工具(Vista,Win7)
我的博客园
慈善点击，点击此处

Answer 2

How to get the last row's cells?

Row[x][y]....

x=DataGridView1.Rows.Count-1?

Answer 3

How to get the last row's cells?

Row[x][y]....

x=DataGridView1.Rows.Count-1?

Yes, I think you can do this：

dataGridView1.Rows[DataGridView1.Rows.Count-1].Cells[Column Index].Value;

Maybe the value is null (Nothing in Basic), and the row isn't mapped to the real DataTable as its DataSource of DataGridView.

In my  mind，I suggest you set AllowUserToAdd=false，this means you cannot directly add data record through the DataGridView directly，and then you can use this.

---

   QQ我：
下载MSDN桌面工具(Vista,Win7)
我的博客园
慈善点击，点击此处

Answer 4

The last row is:

this.dataGridView1.Rows[this.dataGridView1.Rows.Count-2].Cells[0].Value

And the new row is:

this.dataGridView1.Rows[this.dataGridView1.Rows.Count-1].Cells[0].Value

---

Mike Zhang[MSFT]
MSDN Community Support | Feedback to us

Answer 5

It looks great. Can we use a loop to go through al cells?

Right now I use

DataRow dr = new DataRow();
dr["column1"] = this.dataGridView1.Rows[this.dataGridView1.Rows.Count-2].Cells[0].Value;
\\ can I use dr[0] something so we can use foreach..

Answer 6

ure:

//define datatable (with all columns you want to have)...
//then:
DataRow dr;
for(int i=0;i<dataGridView1.Rows.Count; i++)
{
    dr = table.NewRow();
    dr[i] = dataGridView1[0, i].Value;
    dataTable.Rows.Add(dr);
}

---

Mitja

Answer 7

Enen. But I found it might be

for(int i=0;i<dataGridView1.Columns.Count; i++)

Answer 8

Depends. If you wanna loop Rows or Columns? Decide it by your self. I actually dont know, I cant read your mind.

---

Mitja