Click here to Skip to main content
15,879,535 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: Regarding Resume Parser Tool Pin
Pete O'Hanlon29-Apr-13 2:54
mvePete O'Hanlon29-Apr-13 2:54 
GeneralRe: Regarding Resume Parser Tool Pin
ganesh96199129-Apr-13 3:09
ganesh96199129-Apr-13 3:09 
GeneralRe: Regarding Resume Parser Tool Pin
Pete O'Hanlon29-Apr-13 3:13
mvePete O'Hanlon29-Apr-13 3:13 
GeneralRe: Regarding Resume Parser Tool Pin
Sarthakaggarwal10-May-13 5:38
Sarthakaggarwal10-May-13 5:38 
GeneralRe: Regarding Resume Parser Tool Pin
Pete O'Hanlon10-May-13 7:20
mvePete O'Hanlon10-May-13 7:20 
GeneralRe: Regarding Resume Parser Tool Pin
Bram van Kampen10-May-13 14:42
Bram van Kampen10-May-13 14:42 
GeneralRe: Regarding Resume Parser Tool Pin
Richard MacCutchan29-Apr-13 5:07
mveRichard MacCutchan29-Apr-13 5:07 
QuestionSyntax error in update statement. Pin
Shaandg28-Apr-13 19:24
professionalShaandg28-Apr-13 19:24 
I am trying to update data in MS-Access database but my Update query is giving a syntax error.
Here is the code :
Sub UPDATEDATA()
Try
CON = New OleDbConnection(CONSTR)
QRY = "update pass1 set username=@username,password=@password where address=@address"
COM = New OleDbCommand(QRY, CON)
COM.Parameters.AddWithValue("@address", GroupBox1.Text)
COM.Parameters.AddWithValue("@username", TextBox1.Text)
COM.Parameters.AddWithValue("@password", TextBox2.Text)
CON.Open()
COM.ExecuteNonQuery()
CON.Close()
Catch ex As Exception
MsgBox(ex.Message)
If ex.Message <> "" Then
s = 1
End If
End Try
Problem is I cannot find any syntax error in this. Any help is appreciated.
Thanks in advance.

-- modified 29-Apr-13 1:51am.
AnswerRe: Syntax error in update statement. Pin
MaulikDusara28-Apr-13 21:10
MaulikDusara28-Apr-13 21:10 
GeneralRe: Syntax error in update statement. Pin
Shaandg28-Apr-13 22:11
professionalShaandg28-Apr-13 22:11 
GeneralRe: Syntax error in update statement. Pin
MaulikDusara29-Apr-13 0:56
MaulikDusara29-Apr-13 0:56 
GeneralRe: Syntax error in update statement. Pin
Shaandg29-Apr-13 19:27
professionalShaandg29-Apr-13 19:27 
AnswerRe: Syntax error in update statement. Pin
Bernhard Hiller28-Apr-13 23:22
Bernhard Hiller28-Apr-13 23:22 
GeneralRe: Syntax error in update statement. Pin
Shaandg29-Apr-13 19:27
professionalShaandg29-Apr-13 19:27 
Questiontextbox style chamge at runtime Pin
praveen iThesisArt27-Apr-13 21:19
praveen iThesisArt27-Apr-13 21:19 
AnswerRe: textbox style chamge at runtime Pin
Richard MacCutchan27-Apr-13 21:28
mveRichard MacCutchan27-Apr-13 21:28 
AnswerRe: textbox style chamge at runtime Pin
Joezer BH27-Apr-13 22:58
professionalJoezer BH27-Apr-13 22:58 
QuestionRegarding MVC Pin
Disha gupta26-Apr-13 0:40
Disha gupta26-Apr-13 0:40 
AnswerRe: Regarding MVC Pin
Pete O'Hanlon26-Apr-13 0:45
mvePete O'Hanlon26-Apr-13 0:45 
QuestionCrystal Reports for the .NET Framework Pin
MWRivera25-Apr-13 8:27
MWRivera25-Apr-13 8:27 
QuestionMessage Removed Pin
24-Apr-13 6:23
professionalN_tro_P24-Apr-13 6:23 
AnswerRe: Adding serialized objects to the Settings.Settings Pin
Eddy Vluggen25-Apr-13 0:28
professionalEddy Vluggen25-Apr-13 0:28 
GeneralMessage Removed Pin
29-Apr-13 3:02
professionalN_tro_P29-Apr-13 3:02 
QuestionRe: Adding serialized objects to the Settings.Settings Pin
Eddy Vluggen29-Apr-13 3:25
professionalEddy Vluggen29-Apr-13 3:25 
AnswerMessage Removed Pin
29-Apr-13 3:34
professionalN_tro_P29-Apr-13 3:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.