Click here to Skip to main content
11,706,979 members (53,871 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# WinForm
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);
        da.SelectCommand.Parameters.AddWithValue("@ID",MyId);
        SqlCommandBuilder cb = new SqlCommandBuilder(da);
        da.Fill(ds, "Measurement");
 
        if (String.IsNullOrEmpty(txtCellNo.Text.Trim()))
        {
            MessageBox.Show("Please enter Cell Number");
        }
        else
        {
            try
            {
                if (ds.Tables["Measurement"].Rows.Count < 1 )
                {
                    dt.Rows.Add();
                }
                else
                {
                    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;
 
                    cb.GetUpdateCommand();
                    da.Update(ds, "Measurement");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }

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
good
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
ds.Tables["Measurement"].Rows[ds.Tables["Measurement"].Rows.Count-1]
instead
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 140
1 OriginalGriff 125
2 chainerlt 110
3 ppolymorphe 99
4 Mika Wendelius 70
0 OriginalGriff 9,178
1 Sergey Alexandrovich Kryukov 8,487
2 CPallini 5,189
3 Maciej Los 4,766
4 Mika Wendelius 3,696


Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2015
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