0

Hi ,
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)

-Thanks

Edited by stoymigo: n/a

2
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by stoymigo
0

What i've done so far is to add a data source (i.e a dataset including only one table).
I am getting the intellisense , and am about to test inserting a record (I have not set non null fields).

0

It sounds like you're on the right track. You know what you need to do so I don't understand what you're asking. If you have a specific question about creating a dataset or its' behavior then please update the thread with your question.

0

Problem is solved ,
I did the above , in runtime I had to change the connection string , and whichever fields of a row I did not set , then a default null was inserted.If the field was not nullable then I would get a compile-time error which is better than runtime.

Further suggestions are still welcome...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.