remove row from datagrid

[darthy]

Can anyone help me with code for removing the selected row from a datagrid. I cant seem to find the the right method.

If the datagrid is connected to a datasource, will it also remove it from the recordset? Ideally I would like it to be removed from the recordset but not from the database

All help welcome

[James Stanich]

If you are not looking for in grid editing... why not use a flexgrid control? This way you do not have to do the binding, and you could remove item from the grid, but not necessary from the database itself...

[darthy]

I liked the DAtagrid because of the datasource (ie it will self populate)

How hard is it to populate a flexigrid from an ADO.Recordset?

[James Stanich]

Originally posted by darthy
I liked the DAtagrid because of the datasource (ie it will self populate)

How hard is it to populate a flexigrid from an ADO.Recordset?

Not real hard. How many records are we taliking about?

[darthy]

Depends. It will be used to display a type of shopping basket where the client will have theoption to remove an item from it.

Anything from 1 to say 30 rows.

[James Stanich]

Assumptions : Connection and recordset established

Dim INTNEXT As Integer, INTMAX As Integer, MYDATA As String
 
INTMAX = rst.RecordCount
 
If INTMAX > 0 Then
 
For INTNEXT = 1 to INTMAX
 
MYDATA  = _
rst!FIELD1 & VBTAB & _
rst!FIELD2 & VBTAB & _
rst!FIELD3
 
MsFlexGrid1.AddItem MYDATA
 
' Move to next record
 
rst.MoveNext
 
Next
 
End If

That's a basic way of loading a handful of items into an grid...

[darthy]

When trying to connect to the adocontrol on my form it displays error- No compatible data source was found for this control. PLease add intrinsic Data Control or Remote Data Control.

Is the flexigrid not compatible with the ADODC?

PLease forgive my ignorance if this is a dumb question but I am a beginner (Sorry)

[James Stanich]

The method I was mentioning does not utilize data-binding controls. You wuld have to make the connection and recordset in code, rather than utilizing those damsn data-bound controls (can you telll I do not like those controls much )