Retrieve Data From Database Using ADODB in C#

Question

I am developing a project in C#.I am retrieving data from database to textbox.

In vb following code is used for retrieve data.

empcode.Text = IIf(IsDBNull(mRS("Accode").Value), "", mRS("Accode").Value)

And In C# I am using following code to retrieve data.

empcode.Text = mRS["Accode"] == System.DBNull.Value ? string.Empty : mRS["Accode"].ToString();

But in C# code it is giving following error in "mRS["Accode"]".

"Cannot apply indexing with [] to an expression type 'Recordset'".

Where mRS is Recordset.

Thanks & Regards

Your C# version is probably very old, before 4.0. It did not yet support default properties that are not indexers. So you have to write mRs.Fields["name"].Value. Try not to get stuck on 8+ year old versions of free software. — Hans Passant
– Hans Passant, Commented Nov 27, 2016 at 8:07

LucasBols · Accepted Answer · 2016-11-27 07:59:01Z

1

In VB the expression mRS("Accode") is expanded to mRS.Fieldset("Accode") automatically. So you should write mRS.Fieldset["Accode"] in C#.

answered Nov 27, 2016 at 7:59

LucasBols

262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeremy Caney · Accepted Answer · 2022-08-19 00:27:55Z

0

mRs.Fields["name"].Value

worked for me.

edited Aug 19, 2022 at 0:27

Jeremy Caney

7,808115 gold badges58 silver badges86 bronze badges

answered Aug 15, 2022 at 20:29

DLS

1

1 Comment

Jeremy Caney Over a year ago

Remember that Stack Overflow isn't just intended to solve the immediate problem, but also to help future readers find solutions to similar problems, which requires understanding the underlying code. This is especially important for members of our community who are beginners, and not familiar with the syntax. Given that, can you edit your answer to include an explanation of what you're doing and why you believe it is the best approach?

Collectives™ on Stack Overflow

Retrieve Data From Database Using ADODB in C#

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related