Retrieve Data from Database to Textbox using ADODB in C#

Question

I am using ADODB Connection in C#.

Following is from VB code I want it like in C#.

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

Like above code, I want to retrieve data to a textbox in C#.

Thanks & Regards.

Mark PM · Accepted Answer · 2016-11-27 20:00:54Z

1

You should really include more context to your question, but here goes:

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

answered Nov 26, 2016 at 9:40

Mark PM

2,90416 silver badges21 bronze badges

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

5 Comments

Hello, Thanks for your reply. I had tried above code but it is giving error as "Cannot apply indexing with [] to an expression type 'Recordsrt'".

And mRS is Recordset.

Updated the answer. Please update your question with your full code.

txtdef.Text = mRS.Fields["Ask1"].Value == DBNull.Value ? string.Empty : mRS.Fields["Ask1"].Value.ToString();

That's exactly what my answer said (on a different field as per your question)