I m getting error when filling dataset from dataadapter

Question

0.00/5 (No votes)

See more:

Hello everybody....

I am getting the following error when i am filling dataset from dataadapter after retrieving data from the MS-Access database.

"IErrorInfo.GetDescription failed with E_FAIL(0x80004005)"

following is the code i used to fill dataset and bind to gridview.

C#

OleDbCommand cmd1 = new OleDbCommand("Select ID, PrjctName from Current", con);
OleDbDataAdapter da1 = new OleDbDataAdapter(cmd1);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
Grid_Current.DataSource = ds1;
Grid_Current.DataBind();

Posted 11-Nov-11 20:34pm

abhishekagrwl25

Updated 11-Nov-11 20:39pm

koolprasad2003

v2

Add a Solution

4 solutions

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)

deepakdynamite · Answer 1 · 2011-11-11T20:41:00

Solution 1

Hello

http://www.codeguru.com/forum/archive/index.php/t-419787.html[^]

Check this out

Posted 11-Nov-11 20:41pm

deepakdynamite

koolprasad2003 · Answer 2 · 2011-11-11T20:44:00

Solution 2

It is the occoured due to MSAccess database.

use following Query

SQL

Select [ID], PrjctName from Current

Posted 11-Nov-11 20:44pm

koolprasad2003

Prince Antony G · Answer 3 · 2011-11-11T20:48:00

Solution 3

Insert Bracket and try once more .......

OleDbCommand cmd1 = new OleDbCommand("Select [ID], [PrjctName] from Current", con);
OleDbDataAdapter da1 = new OleDbDataAdapter(cmd1);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
Grid_Current.DataSource = ds1;
Grid_Current.DataBind();

inform whether error Comes or not?

Posted 11-Nov-11 20:48pm

Prince Antony G

Comments

abhishekagrwl25 12-Nov-11 3:15am

Yes still m getting the same error....:(

thatraja · Answer 4 · 2011-11-12T09:06:00

Actually this error occurred because of the reserved word of MS Access. And also its always a best practice to use Square brackets[] around the field names & table names. Like below

SQL

Select [ID], [PrjctName] from [Current]

Now try this.

FYI List of reserved words in Microsoft Access 97, 2002, 2002 and Access 2003[^]