can't update value in the data base

Question

0.00/5 (No votes)

See more:

hi, i have an access database containing Tables ADDRESS_BOOK & USER_MASTER, i write and update statement to update address_book records which is running fine, but the same code i write for updating user_master then it is not giving the desired result like i'm updating USER_NAME and PASSWORD then it updates 0 instead of given text, the code is like this

VB

Public Function Edit(ByVal EmployeeID As String, ByVal EmployeeName As String, ByVal UserName As String, ByVal Password As String) As Boolean
       Try
           Dim StrSql As String = ""
           'StrSql = "UPDATE USER_MASTER SET EMPLOYEE_NAME = '" + EmployeeName.ToLower.ToString + "', USER_NAME = '" + UserName.ToLower.ToString + "' AND PASSWORD = '" + Password.ToLower.ToString + "' WHERE EMPLOYEE_ID = " + EmployeeID.ToString + " "
           StrSql = "UPDATE USER_MASTER SET EMPLOYEE_ID = " & EmployeeID & ", EMPLOYEE_NAME = '" & EmployeeName.ToLower.ToString & "', USER_NAME = '" & UserName.ToLower.ToString & "' AND PASSWORD = '" & Password.ToLower.ToString & "' WHERE EMPLOYEE_ID = " & EmployeeID.ToLower.ToString & ""
           objConnection.Conn = New OleDb.OleDbConnection(objConnection.ConnStr)
           objConnection.Conn.Open()
           objConnection.Cmd = New OleDb.OleDbCommand(StrSql, objConnection.Conn)
           objConnection.Cmd.ExecuteNonQuery()
           Return True
       Catch ex As Exception
           Return False
       End Try
   End Functi

on

Posted 20-Oct-10 0:35am

sujit kodiyatar

Add a Solution

Comments

Ankur^\m/ 20-Oct-10 6:59am

The commented query is correct already.

Rajesh Anuhya 20-Oct-10 7:08am

no .., that is not correct, there sholud be a "," before "password =" instead of AND

Ankur^\m/ 20-Oct-10 7:42am

Oh yes, you are right. I didn't check the syntax. I meant, the logic behind the commented query is correct.

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)

Mohd Wasif · Answer 1 · 2010-10-20T00:49:00

Solution 1

no need to update Employee Id coz on behalf of employee id u would be able to update ur table as that would be ur primary key.

use like it

UPDATE USER_MASTER SET EMPLOYEE_NAME = '"& EmployeeName.ToLower.ToString & "',USER_NAME = '" & UserName.ToLower.ToString & "',PASSWORD = '" & Password.ToLower.ToString & "'WHERE EMPLOYEE_ID = " & EmployeeID.ToLower.ToString & ""

Posted 20-Oct-10 0:49am

Mohd Wasif

Updated 20-Oct-10 1:04am

v3

Comments

Ankur^\m/ 20-Oct-10 7:43am

[moved from answer]
sujit kodiyatar wrote:
thank rajesh

i tried as you said there should be , before password but if i do so then it throws Exception Syntax error in UPDATE statement, pls help me out

Ankur^\m/ · Answer 2 · 2010-10-20T01:53:00

Solution 3

Try this:

VB

Dim StrSql As String = ""
StrSql = "UPDATE USER_MASTER SET EMPLOYEE_NAME = '" + EmployeeName.ToLower.ToString + "', USER_NAME = '" + UserName.ToLower.ToString + "', PASSWORD = '" + Password.ToLower.ToString + "' WHERE EMPLOYEE_ID = " + EmployeeID

Posted 20-Oct-10 1:53am

Ankur^\m/