I am busy converting a VB6 project to c#.
Now in vb6 , the columns have intellisense like so...
rsIBBSData!DrOrCr = 1 'rs is the recordset
But in c# , i would either have to create an sql query , or use datarow with a column index or column name as index.
Having to use column index is error prone , and having to type column name is burdensome(many columns in tables) .
I know it is something along the lines of creating dataset(via datasources wizard) and/or table adapter .
Pls give me instructions if you know how.(no commercial products or complex procedures please)