ASP.Net Error: There was an error executing the query. Please check the syntax of the command and if present, types and values of the parameters and ensure they are correct

Jermaine

SOLVED CLOSED ACTIVE ANSWERED
User: Jermaine
Posted: on Dec 20, 2017 10:55 PM
Forum: ASP.Net Web Forms
Replies: 3
Views: 3253

When im testing my query during the gridview, i was prompted a SQL syntax error. However what confuses me is that my database has already inserted, why is there still syntax error occur?

dharmend...

0 1

Reply
User: dharmendr
Replied: on Dec 20, 2017 10:55 PM
Report

Hi Jermaine,

Please provide the error in details.

Jermaine

0 2

Reply
User: Jermaine
Replied: on Dec 21, 2017 08:24 AM
Modified: on Dec 21, 2017 08:25 AM
Report

It stated that

"There was an error executing the query. Please check the syntax of the command and if present, types and values of the parameters and ensure they are correct.

You have an error in your SQL syntax; check the manual tthat corresponds to your MySQL server version for the right syntac to be use at line 1"

I am just testing my query during the process of creating the gridview where this happened. And i dont know what i should do now

dharmend...

0 3

Reply
User: dharmendr
Replied: on Dec 21, 2017 11:26 PM
Report

Please share the screenshot of your error.

ASP.Net Error: There was an error executing the query. Please check the syntax of the command and if present, types and values of the parameters and ensure they are correct

Company

Explore

Follow us

Contact Us