Click here to Skip to main content
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 23: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 OriginalGriff 325
1 DamithSL 265
2 CPallini 235
3 Maciej Los 190
4 Sergey Alexandrovich Kryukov 189
0 OriginalGriff 5,455
1 DamithSL 4,422
2 Maciej Los 3,860
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,010


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2014
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