How to save multiple gridview row data to database in asp.net c#

Question

I have a gridview control in my project in which i wanted to save multiple gridview rows back to the database. How do i get save all rows through looping. Please help me to overcome this problem.

enter image description here

//Save TestDetails

   foreach (GridViewRow rw in GridView1.Rows)
    {
            var n = new TestDetail
            {
                ServiceId = Convert.ToInt32(GridView1.DataKeys[rw.RowIndex].Value),
                Service = rw.Cells[1].Text.ToString(),  //getting input error
                Price = Convert.ToInt32(rw.Cells[2].Text.ToString())  //getting input error
            };

            using (var context = new DiagEntities())
            {
                context.TestDetail.Add(n);
                context.SaveChanges();
            }
     }

please show the gridview markup

codeandcloud
– codeandcloud

2015-02-11 09:05:59 +00:00
Commented Feb 11, 2015 at 9:05 — codeandcloud
– codeandcloud, Commented Feb 11, 2015 at 9:05

scartag · Accepted Answer · 2015-02-10 16:52:46Z

1

If you are in edit mode, you could check the control collection of the particular cell... it should context the textbox containing the value.

Service = ((TextBox)(rw.Cells[1].Controls[0]).Text.ToString(),
Price = Convert.ToInt32(((TextBox)(rw.Cells[1].Controls[0]).Text.ToString())

answered Feb 10, 2015 at 16:52

scartag

17.7k3 gold badges52 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Apurba Over a year ago

Thanks "Scartag" for your reply... there is no textbox control associated inside the gridview control.

scartag Over a year ago

@Apurba Yeah they won't be till you have an edit mode .. do you get into edit mode before the saving occurs? how do the values change that requires saving?

Collectives™ on Stack Overflow

How to save multiple gridview row data to database in asp.net c#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related