Inserting multiple records using DataGridView using C#

[sreenu123]

How to insert multiple records into a database table that are entered into a datagridview. With a single shot of Save all the records in the datagridview should be updated using C# . Can any one help me in this regard.

Please tell me the solution as i have wasted near about whole day on this. I did not find help in google search.

Any help appreciated

[senm]

insert the following code in saveAll button click event

            int rows = dataGridView1.Rows.Count;
            for (int i = 0; i < rows; i++)
            {
                    value1 = dataGridView1.Rows[i].Cells[0].Value.ToString();
                    value2 = dataGridView1.Rows[i].Cells[1].Value.ToString();
                    value3 = dataGridView1.Rows[i].Cells[2].Value.ToString();
            }

use values1,valu2,value3 in insert query