Sunday 23 September 2012

Error Occured:Syntax error in UPDATE statement

"Error Occured: Syntax error in UPDATE statement" This Is My Error In My Project When I Click On Update Button. I Had Tried A Lot But No Use At That Time...

I Had Searched My Code A Lot. I Didnot Recognise My Mistake..I Changed The Code By Using OleDbDataAdapter But No Use..
 Finally I Recognize My Mistake i.e., I Had Taken Field Name as "E-Mail" In My DataBase....So That It Is Showing Syntax Error In Update Statement. We Should Not Take Any Special Symbols In Field Names In DataBase. i.e., We Have To Take "EMail" Instead Of Taking "E-Mail". And Also We Have Also Not To Take Some Reserved Words As Field Names Such As "Date"  etc..If Not The Same Error Will Occur i.e.,"Error Occured:Syntax error in UPDATE statement"

I Had Changed The Mistake In My Coding Also As "E-Mail" To "Email".Now The Code Is Gets Ready To Work.


After Modifing Update Statement...I Got The Result Successfully




No comments:

Post a Comment

Note: only a member of this blog may post a comment.