C# Winform, Problems after migrating from oledb to mysql codes

Question

0.00/5 (No votes)

See more:

Hi here's my scenario right now:

Recently i change my codes from oleB to my sql

Here's my previous code

string sql = "SELECT COUNT(*) FROM account WHERE [Access_Control] = @code";
OleDbCommand com = new OleDbCommand(sql, con);
com.Connection = con;
com.CommandText = sql;
com.Parameters.Clear();
com.Parameters.AddWithValue("@code", metroaccesscontroltxtBox.Text);
int numRecords = (int)com.ExecuteScalar();

if (numRecords == 1 )
{
groupBox1.Enabled = true;
metroaccesscontroltxtBox.ReadOnly = true;
}

All my codes work, After changing all my codes like
OleDbCmd to MySqlCmd , oledbdataadapter to mysqldataadapter

i got error

error in your Sql Syntax, check the manual that corresponds to your MySql Server version for the right syntax to use near "" at line blabla

Posted 18-Nov-15 20:03pm

Rencyrence

Updated 18-Nov-15 20:31pm

v3

Add a Solution

1 solution

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)

George Jonsson · Accepted Answer · 2015-11-18T20:19:00

Solution 1

You need to remove the brackets in the SQL statement

C#

string sql = "SELECT COUNT(*) FROM account WHERE Access_Control = @code"

;

If you need use a keyword in MySQL you wrap it in two ` `
like

`Table`

(Don't know what this character is called, though)

[UPDATE]
Just for the fun of it, test this

C#

com.Parameters.Add("@code", SqlDbType.VarChar);
com.Parameters["@code"].Value = metroaccesscontroltxtBox.Text;

instead of

C#

com.Parameters.AddWithValue("@code", metroaccesscontroltxtBox.Text);

Posted 18-Nov-15 20:19pm

George Jonsson

Updated 18-Nov-15 20:53pm

v3

Comments

Rencyrence 19-Nov-15 2:32am

I still got error, after trying this. it shows "Specified cast not valid" btw my tables are all varchar, i dont know if i have a problem with counting values

Rencyrence 19-Nov-15 2:33am

Please check again my codes I added more for you to understand, thanks

George Jonsson 19-Nov-15 2:53am

I just added an alternative approach to the solution.

Rencyrence 19-Nov-15 2:51am

I tried to google the new error and http://stackoverflow.com/questions/28263029/specified-cast-is-not-valid-error-in-c-sharp helps me also, thanks for the help

George Jonsson 19-Nov-15 2:54am

OK. Good I could help you on the way.