How Do I Insert In Mysql Table Using Parameterized Query In C#.Net Windows Application Project?

Question

0.00/5 (No votes)

See more:

how do i insert in Mysql table using parameterized query in c#.net windows application project?
i have used these given below codes but in table NULL value rows inserted every time.please help!!!

C#

//C# Code for windows Application
string sql = "insert into nationality(NAME)values(@NAME)";
OdbcCommand cmd = new OdbcCommand(sql,con);
cmd.Parameters.AddWithValue("@NAME", "ABC");
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//C# Code for windows Application

SQL

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `nationality`
-- ----------------------------
DROP TABLE IF EXISTS `nationality`;
CREATE TABLE `nationality` (
  `NAME` varchar(255) DEFAULT NULL,
  `CODE` int(11) DEFAULT NULL,
  PRIMARY KEY (`CODE`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of nationality
-- ----------------------------

Posted 11-May-15 0:52am

BIBASWAN

Updated 11-May-15 2:55am

v5

Add a Solution

Comments

_Asif_ 11-May-15 7:24am

Why are you passing code parameter? You already have set the column in the table as AUTO INCREMENT!

BIBASWAN 11-May-15 8:34am

see i have update my question..auto increment is working but in the name field its showing NULL

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)

Sascha Lefèvre · Answer 1 · 2015-05-11T02:17:00

Solution 1

I'm not sure if this will fix the null-row-issue but it's definitely one issue of your code:

In your CREATE TABLE-statement you've declared CODE as an integer column but you assign a String-value ("123") to the according parameter. It would probably work if you removed the quotes (123) but not work like you intended since you defined CODE also as AUTO_INCREMENT[^]. You probably don't want to specify CODE in your INSERT-statement at all so it will be assigned a value by MySQL automatically. (Or, if you do want to specify the values yourself, remove the AUTO_INCREMENT-keyword from the column-definition.)

edit: this answer refers to an earlier version of the question

Posted 11-May-15 2:17am

Sascha Lefèvre

Updated 11-May-15 3:10am

v2

Comments

BIBASWAN 11-May-15 8:34am

see i have update my question..auto increment is working but in the name field its showing NULL

Sascha Lefèvre 11-May-15 8:48am

If you haven't already, please change your sql-statement like so:
"insert into nationality (NAME) values (@NAME)"

Also, please enclose your code in a try-catch-block:
try {
// your posted code here
} catch (Exception ex) {
System.Diagnostics.Debugger.Break();
}

Run your program in debug mode and see if it stops in the catch-block. If so, please tell me the message of the exception.

BIBASWAN 11-May-15 9:00am

sir no error given...i am using odbc driver 5.1 is this driver is ok???

Sascha Lefèvre 11-May-15 9:10am

I guess so. You would probably get an exception if the driver wasn't ok.

Please try this (the '@' removed):
cmd.Parameters.AddWithValue("NAME", "ABC");