MS Access Query

Question

0.00/5 (No votes)

See more:

public OleDbDataReader SqlFindColomnName(string s2)
{
    con.Close();
    con.Open();           
    cmd = new OleDbCommand("select classname, CASE WHEN 
    subject1 = '" + s2 + "' THEN 'subject1' WHEN 
    subject2 = '"       +       s2 + "' THEN 'subject2' WHEN 
    subject3 = '" + s2 + "' THEN 'subject3' END AS Subject
    from studentregistration", con);
    OleDbDataReader rd = cmd.ExecuteReader();
    return rd; 
}

it gives an error like this...
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).

Posted 7-Jun-10 21:48pm

suzeets

Updated 7-Jun-10 22:01pm

Sandeep Mewara

v2

Add a Solution

2 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)

Arindam Tewary · Answer 1 · 2010-06-07T22:16:00

Hi,

This seems to happen when you use a access reserved word in your query statement.

I suspect the word "classname" which might be creating trouble. Try putting braket around it.

Example:

select [classname], CASE .....

Please refer here for more ..[http://bytes.com/topic/visual-basic-net/answers/353905-ierrorinfo-getdescription-failed-e_fail-0x80004005-why-im-i-getting]

Hope it helps you,

alij_juma · Answer 2 · 2010-06-08T03:03:00

Hello there,

Couple of issues with your query

syntax for case could be something like - please review.
- CASE WHEN X=True THEN Y End
- CASE WHEN X=True Then Y ELSE Z End
- CASE WHEN X=True Then Case WHEN Y=True Then Z End End

Also I am not sure how well CASE is implemented in Access you might consider using the IIF statement; using above example, it would be something like

- IIF(X=True, Y)
- IIF(X=True,Y, Z)
- IIF(X=True,IIF(Y=True,Z))

Hope this helps you out.

MS Access Query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0