I am using VB.NET 2005, I have a datagridview that I want the user to be able to update with an ADO recordset .I could do this in Vb6 with datagrids, by setting the datasource, but not able to in VB NET. I see on the forums that it is recommended to use ADO.NET. But I really don't want to do anyting fancy here, is there not a way to do this? simply without learning something new each time..


CN = New ADODB.Connection
RS_Stations = New ADODB.Recordset
CN = Globals.Connect_Database

RS_Stations.Open("SELECT * FROM Stations", CN, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
DG_Stations.DataSource = RS_Stations