Editing a recordset

[jockey]

I am trying to edit data in a ADODB recordset which i'm sure I could do in VB6 but can't work out how to do this in .NET/ Can anyone tell me how to this or if it is not possible suggest an alternative to the recorset??

Cheers

Jamie

 

[bueller]

Jamie,

Is this a bound recordset or a disconnected recordset that is being displayed. The way i do it is i move the data into a dataset then work with it.
HTH,
Bueller

 

[tEkHEd]

bueller is right.. You need to create either a DataReader or DataAdapter.

You then configure the adapter/reader to pull data from your source, and display the content of the DataAdapter in a DataGrid.

Sorry I can't give you an example at the mo, but if you are still looking for some code tomorrow, I will post some up

 

[jockey]

The recordset is not bound. I have no problem using the dataset/reader/adapter.The problem is I have only just started using .net + have no idea how they work. I assume the work in a similar fashion to the recordset so an example would be most helpfull if possible

 

[atruhoo]

Here is a link which has numerous articles relating to ado recordsets and their use within visual studio.net

http://support.microsoft.com/search...L&maxResults=25&Titles=false&numDays=&InCC=on