ArgumentException unhandled by user

Question

0.00/5 (No votes)

See more:

Hi,

I want to display data from MSaccess 2007 into gridview control.
My code is giving Unhandled exception "Keyword not supported: 'provider'".
My source code is given below.

C#

string connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Documents and Settings\\Administrator\\My Documents\\my.accdb";
 string query= "Select * from fee where status=Pending ";
 SqlDataSource sds = new SqlDataSource(connection,query);
GridView1.DataSource = sds;
           GridView1.DataSourceID = String.Empty;
           GridView1.DataBind();

Please help me out for the same.

Thank&Regards
Abhishek

Posted 26-Mar-11 19:58pm

abhiamity86

Updated 26-Mar-11 20:14pm

Sandeep Mewara

v2

Add a Solution

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)

Sandeep Mewara · Accepted Answer · 2011-03-26T20:15:00

Solution 1

Well, it's quite clear that the connection string formed has issues.

I would suggest you to have a loot here at Connection String[^]!

The link above provides all info about connection string. Further info regarding the data communication can be read here: Accessing data with ADO.NET[^]

Out here, you are working with SQL, you don't need to give the provider. Just remove the Provider and things should be fine.

Posted 26-Mar-11 20:15pm

Sandeep Mewara

Updated 26-Mar-11 20:19pm

v2

Comments

abhiamity86 27-Mar-11 2:50am

Thanks For helping me.

But somehow my sql is not working so i did some modification in source code.
It is again giving Exception 'Data Source=C:\Documents and Settings\Administrator\My Documents\my.accdb' is not a valid virtual path.
My New source code is-

string connection = "Data Source=C:\\Documents and Settings\\Administrator\\My Documents\\my.accdb";
string query= "Select * from fee where status=Pending ";
AccessDataSource ads = new AccessDataSource(connection,query);
GridView1.DataSource = sds;
GridView1.DataSourceID = String.Empty;
GridView1.DataBind();
Pls help me.

Thanks&Regards
Abhishek

Sandeep Mewara 27-Mar-11 3:01am

Your connection string is wrong. Try the websote and get it correct for yourself.

Further, the error again says it's expecting a virtual path based on the root.

abhiamity86 27-Mar-11 3:24am

Thanks For Reply,

I am Beginner to Programming.
So I am not getting ,how can i resolve this issue.
Would you pls help me.

Abhishek

Sandeep Mewara 27-Mar-11 3:25am

Go through the connectionstring link I gave.

abhiamity86 27-Mar-11 5:41am

I have go through enough but unable to get solution.
pls help me.

Abhishek

abhiamity86 28-Mar-11 2:59am

Hi,
I resolved that issue and now it is working fine but when i use where cluase with select query then it is giving exception "No value given for one or more required parameters".
So could you pls suggest me how to use where clause.
Thanks In advance.

Sandeep Mewara 28-Mar-11 3:00am

Create a new question with the query and how you are passing the parameters and using where clause.

Pooja Somasundar 20-Jul-12 2:15am

Iam trying to develop a chat application using WCF services.No buid errors .Earlier i was facing with end point not found exception but i resolved it.Now facing argument exception issue.Plz give me the solution of how to resolve dis issue?