delete row in database

[ganders]

hi

the following code opens an oracle-connection, reads some tables to a dataset, adds or deletes somes rows...

adding rows works fine. but trying to delete rows, i allways get DataSet.HasChanges=false.

what am i missing?

best regards

george

Dim pOracleConnection As OracleConnection
Dim pCmdBuilder As OracleCommandBuilder
Dim pDS as New DataSet
Dim Table1 As OracleDataAdapter

pOracleConnection.Open()

Table1= New OracleDataAdapter("select * from table1", pOracleConnection)
Table1.Fill(pDS,"table1")
pCmdBuilder = New OracleCommandBuilder(table1)    

Dim pRows() As DataRow
Dim pRow As DataRow
pRows = table1.Select()
pRow=pRows(0)
table1.Rows.Remove(pRow)

Dim pUpdateDS As New DataSet
pUpdateDS = pDS.GetChanges  //pUpdateDS remains NOTHING!!!
table1.Update(pUpdateDS,"table1")
table1.AcceptChanges

 

[PlausiblyDamp]

http://msdn.microsoft.com/library/d...stemdatadatarowcollectionclassremovetopic.asp
and
http://msdn.microsoft.com/library/d...ml/frlrfsystemdatadatarowclassdeletetopic.asp
are the two links worth reading.

Brief summary to delete a Row call the .Delete method as this marks it for deletion, .Remove is the same as calling .Delete followed by .AcceptChanges and will result in it no longer being seen as a modified row.

 

[ganders]

tx a lot!!