Deleting row nightmare 
Author Message
 Deleting row nightmare

Having a regular Form, with a regular DataGrid and with a
regular settled DataSet that points to a regular database
thru a OleDbAdapter

it encounters to a problem of deleting a row simple by
pressing a delete cause it is possible on a editable
DataGrid.

but behind the datagrid it doesn't really deletes a row
cause DataAdapter ( I suppose this is in My case
OleDbAdapter1) doesn't call DeleteCommand.

I simple stock  when I try to use DeleteComand.


DsRW1.Table_Dokumenta.Rows
(DataGrid1.CurrentRowIndex).Delete()
DsRW1.Table_Dokumenta.AcceptChanges()
' DsRW1.Dokumenta.Rows.Remove(R)
OleDbDataAdapter1.Update(DsDokumentaRW1)
OleDbDataAdapter1.Fill(DsDokumentaRW1)

still nothing.

Also when Adapter properties DeleteCommand,
UpdateCommand  may influence here but I don't see how.

How to solve problem of deleting a row?

Thanks



Sun, 04 Sep 2005 08:01:53 GMT  
 Deleting row nightmare

Quote:
> Having a regular Form, with a regular DataGrid and with a
> regular settled DataSet that points to a regular database
> thru a OleDbAdapter

> it encounters to a problem of deleting a row simple by
> pressing a delete cause it is possible on a editable
> DataGrid.

> but behind the datagrid it doesn't really deletes a row
> cause DataAdapter ( I suppose this is in My case
> OleDbAdapter1) doesn't call DeleteCommand.

> I simple stock  when I try to use DeleteComand.


> DsRW1.Table_Dokumenta.Rows
> (DataGrid1.CurrentRowIndex).Delete()

  'DsRW1.Table_Dokumenta.AcceptChanges()

Quote:
> OleDbDataAdapter1.Update(DsDokumentaRW1)
> OleDbDataAdapter1.Fill(DsDokumentaRW1)

And now? ;-)

Armin



Sun, 04 Sep 2005 08:12:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Rows.RemoveAt v. Rows.Delete

2. Row Handle referred to a deleted row ... - Error

3. Row handle referred to a deleted row or a row marked for deletion.

4. Row handle referred to a deleted row or a row marked for deletion.

5. ADO Error: "Row handle referred to a deleted row or a row marked for deletion "

6. Delete a row creates a new one

7. Cannot delete rows in SQL attached table

8. Help: Selectively deleting rows in Excel

9. Deleting Rows Across Multiple Excel Worksheets

10. Deleting Rows in Excel

11. deleting / inserting rows

12. event by row-deleting?

 

 
Powered by phpBB® Forum Software