DaniWeb Forum Index > Software Development > C#

Deleting rows in datagrid

Please support our C# advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: May 2008

Posts: 31

Reputation: harcaype is an unknown quantity at this point

Solved Threads: 0

harcaype

Offline

Light Poster

Deleting rows in datagrid

Jul 11th, 2008

Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.
This is the error I get when I'm deleting a row in my datagrid. I referred my code to a running program but when I embedded it on my own it occured that way. Here's the code:

Help with Code Tags

(Toggle Plain Text)

            myConn.Open();
            dTable = new DataTable("Records");
            dTable = this.ds.Tables[0];
            int i = this.iRowIndex;
            dTable.Rows[i].Delete();
            this.da.Update(dTable);

Any suggestions?

•

Join Date: Jan 2006

Posts: 22

Reputation: ema005 is an unknown quantity at this point

Solved Threads: 4

ema005

Offline

Newbie Poster

Re: Deleting rows in datagrid

Jul 14th, 2008

Before calling the update() method of the data Adapter call the acceptchanges of the datatable
type dTable.AcceptChanges(); i.e

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
myConn.Open();
        dTable = new             DataTable("Records");
            dTable = this.ds.Tables[0];
            int i = this.iRowIndex;
            dTable.Rows[i].Delete();
dTable.AcceptChanges();
this.da.Update(dTable);
myConn.Open();
        dTable = new             DataTable("Records");
            dTable = this.ds.Tables[0];
            int i = this.iRowIndex;
            dTable.Rows[i].Delete();
dTable.AcceptChanges();
this.da.Update(dTable);

hope this help.