Upadate query in acces database

Question

0.00/5 (No votes)

See more:

.NET2.0

hey Guys,

I write code for update database but it can't be update the database how to solve this problem tell me please...!!!
I use the Microsoft Access database.
My code is

C#

cmd = new OleDbCommand("Update [hoddo] set [hoddo]=[@lk] where [ID]=[@id]", con);
      cmd.Parameters.AddWithValue("@id", dgrow);
      cmd.Parameters.AddWithValue("@lk", textBox1.Text);
      cmd.ExecuteNonQuery();

Posted 2-Mar-13 7:57am

Priyank.Patel00762

Updated 2-Mar-13 8:04am

v4

Add a Solution

Comments

Maciej Los 2-Mar-13 14:24pm

Where do you place your database?
What is dgrow?

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)

Dave Kreskowiak · Answer 1 · 2013-03-02T08:31:00

Solution 1

Access doesn't use named parameters. Your parameters could be specified with "@?" instead of names like "@lk". When you create your parameter objects, they must be specified in the order they appear in the SQL statement. Currently, your parameters are specified in the wrong order.

Posted 2-Mar-13 8:31am

Dave Kreskowiak

Comments

Maciej Los 2-Mar-13 14:52pm

In MS Access query we can define parameters ;)
See my solution.

Dave Kreskowiak 2-Mar-13 15:20pm

I said you couldn't define NAMED parameters. I didn't say you couldn't define parameters at all.

I see they changed things in 2007 and above. Now you can use name parameters, but that's a funky implementation they've got.

I don't use Access for anything because of it's limitations and screwed up implementation. It's a DESKTOP database, not something I would use in a multiuser system.

Maciej Los 2-Mar-13 15:29pm

I'm almost sure that you said we couldn't define named parameters, because you wrote: Your parameters could be specified with "@?" instead of names like "@lk".. ;)
If i'm not wrong, this functionality is accesible starting from Access'97 ;)

Maciej Los · Answer 2 · 2013-03-02T08:49:00

Solution 2

You need to define parameters, like this:

SQL

PARAMETERS [pID] INT, [pHoddo] INT;
SELECT ...
FROM ...
WHERE [hoddo]=[pHoddo] AND [ID]=[pID]

More at: http://msdn.microsoft.com/en-us/library/office/bb208916%28v=office.12%29.aspx[^]

Posted 2-Mar-13 8:49am

Maciej Los

Updated 2-Mar-13 8:50am

v2