How to Delete a record using a DataAdapter

J

JInsane

New member
Joined
Aug 29, 2003
Messages
3
Location
Cape Town
Lo guys/girls

I got a problem which has to be sorted by 5/09 ..Hope anyone can help.

Im using a DataAdapter to connnect to my DataSet like this..

SqlDataAdapter1.Fill(DsVModel1, "VMake")

Bind DataSet to DataGrid
DataGrid1.DataSource = DsVModel1.Tables ("VMake").DefaultView

ok..

now i need to browse the record via Button and TextBoxes but it just sticks with the 1st record...like this

For i = 0 To iRow
clearing bindings
txtCode.DataBindings.Clear()
txtCode.Text = iRow
txtCode.Text = DsVModel1.Tables(0).Rows(iRow).Item(0)

clearing bindings
txtDescription.DataBindings.Clear()
txtDescription.Text = iRow
txtDescription.Text = DsVModel1.Tables(0).Rows(iRow).Item(1)

iRow = DsVModel1.Tables("VMake").Rows.Count + 1
Next

ok..

and last but not LEAST...Deleting a freekin record

! ! H E L P ! !

JInsane
 
Back
Top