MS access query not returning rows in c#.net

Question

0.00/5 (No votes)

See more:

Hi All,

This must be a very simple problem but I am unable to solve it.
I have written an ms access query within C#.net project to retrieve rows.
Even though there are no errors, rows are not getting retrieved.
Here is my code:

C#

OleDbConnection xsconn = new OleDbConnection();
xsconn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data source=D:\\mail.accdb";
 xsconn.Open();

string qto = "SELECT [NAMES] FROM " + var_name + " WHERE [STATUS]='to'";

                OleDbDataAdapter da = new OleDbDataAdapter(qto, xsconn);
                DataSet ds = new DataSet();
                da.Fill(ds);

I have done the same exercise in VB.net many a times fluently & successfully..so this is kind of disappointment to me..!!

What I have tried:

I have copied my code in question.
Since there are no errors, I am clueless how to solve it.

Posted 30-Mar-16 23:16pm

planetz

Updated 31-Mar-16 0:49am

Add a Solution

Comments

F-ES Sitecore 31-Mar-16 5:26am

Use the debugger to see what the "qto" variable contains and copy its contents to the clipboard. Open the database via Access, create a new query and paste the sql into it and run it. Does the sql look right? Does Access accept it as valid? Does it return results when you execute it?

Also if var_name has come from user input you'll need to think about the possibilities of SQL injection attacks.

Karthik_Mahalingam 31-Mar-16 5:29am

remove the filter WHERE [STATUS]='to' and try.
might be filter has no records.

planetz 31-Mar-16 5:48am

hi Karthik...I took up your suggestion of running query removing filter... surprisingly the data is wrapped in <div> tags..!! Like this

<div>abc@xyz.com</div>

Karthik_Mahalingam 31-Mar-16 5:50am

all the rows?

planetz 31-Mar-16 5:51am

all the rows and all the columns

Karthik_Mahalingam 31-Mar-16 6:08am

strange

Karthik_Mahalingam 31-Mar-16 6:17am

your table must be having the values with <div> tag

planetz 31-Mar-16 6:25am

nope...they are demo data and I typed them in manually....

Karthik_Mahalingam 31-Mar-16 6:35am

oh. try copying the data from one cell and paste it in notepad. see if div appears

planetz 31-Mar-16 5:44am

thank you Sitecore for answering..yes, I tried running the query in query design in pass through. While running it asks for DNS connection and after creating and trying to use same gives this error - "you cannot use odbc to import from export to or link an external microsoft access or isam database table to your database"..got another problem there..i chose MS Access driver for DNS setup....

planetz 31-Mar-16 5:50am

I tried selecting * from table and found that whatever data it is retrieving is wrapped in <div> tag..is there anything different in access with C#.net?

planetz 31-Mar-16 5:55am

i modified the query like this:

SELECT [NAMES] FROM CRC WHERE [STATUS]='<div>to</div>'

now, data is getting retrieved but wrapped in <div> tag..!!

Now I am replacing the tags with replace method. Though it is working, it is a very poor way to do so. Help needed.

Karthik_Mahalingam 31-Mar-16 6:08am

ya, need to figure out the problem.

planetz 31-Mar-16 6:45am

Thank you Karthik...!!

Karthik_Mahalingam 31-Mar-16 6:50am

welcome

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

planetz · Accepted Answer · 2016-03-31T00:45:00

Problem solved.

Why does my text box have <div> ...... <div> tags?[^]

This is the link that helped me. I am using MS Access 2013. Initially I chose long text for data format. When I change it to short text, there was no more div tags around data.

Feeling relieved..!!
Thank you..!!