Click here to Skip to main content
13,045,248 members (48,744 online)
Rate this:
Please Sign up or sign in to vote.
See more:
I have a SaveButton through which I am trying to add a new row, edit the row and save the changes. I am able to edit the existing row in the GridView. The problem is when I try to add a new row the existing row is getting modified. If I use `dt.Rows.Add(dr)` then new row is getting added after editing the existing row and saving.

Below is my code:
    private void btnSave_Click_1(object sender, EventArgs e)
            int MyId;
            bool i = int.TryParse(txtID.Text, out MyId);
            da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand("select * from Measurement where ID = @ID",con);
            SqlCommandBuilder cb = new SqlCommandBuilder(da);
            da.Fill(ds, "Measurement");
            if (String.IsNullOrEmpty(txtCellNo.Text.Trim()))
                MessageBox.Show("Please enter Cell Number");
                    if (ds.Tables["Measurement"].Rows.Count < 1 )
                        dr = ds.Tables["Measurement"].Rows[0];
                        dr["CellNumber"] = txtCellNo.Text.Trim();
                        dr["FirstName"] = txtFirstName.Text;
                        dr["LastName"] = txtLastName.Text;
                        dr["Shirt"] = txtShirt.Text;
                        dr["Pant"] = txtPant.Text;
                        dr["DueDate"] = txtDueDate.Text;
                        dr["Date"] = txtDate.Text;
                        da.Update(ds, "Measurement");
                catch (Exception ex)

Note: I got the values from Gridview to Text Boxes using Gridview Selection changed event.
Posted 6-Feb-13 22:05pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

dr = ds.Tables["Measurement"].Rows[0];

You are always going to the first row.

Try using

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100