insert record in mysql table

Question

0.00/5 (No votes)

See more:

how to insert record in two table that are related.when i insert record then record saved in 1st table but not save in 2nd table

C#

 MySqlConnection exclecon = new MySqlConnection("Server=Localhost;DataBase=password1;user=root;password=nectar");
                    string insquery = "INSERT INTO slayear (YEAR) VALUES(@YEAR)";
                    string insquery1 = "INSERT INTO slamonth (MONTH,contenttype) VALUES(@MONTH,@contenttype)";
 MySqlCommand mycom = new MySqlCommand(insquery, exclecon);
                    mycom.Parameters.AddWithValue("@YEAR", YEAR);
                    MySqlCommand mycom1 = new MySqlCommand(insquery1, exclecon);
                    mycom.Parameters.AddWithValue("@MONTH", MONTH);
                    mycom.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;
                   exclecon.Open();
                    mycom.ExecuteNonQuery();
                    mycom1.ExecuteNonQuery();
 con.Close();
}
}

Posted 10-May-13 22:44pm

Member 9937209

Updated 10-May-13 23:20pm

Maciej Los

v2

Add a Solution

2 solutions

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)

**Zoltán Zörgő** · Answer 1 · 2013-05-10T23:22:00

The object name is wrong:

C#

...
MySqlCommand mycom1 = new MySqlCommand(insquery1, exclecon);
mycom1.Parameters.AddWithValue("@MONTH", MONTH);
mycom1.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;
...

This is why it is a really bad practice to use such variable names with a running index at the end. Use a descriptive variable name, don't be lazy: IntelliSense is doing the most of the work. And do't mix statements that belong to each other, and don't use variables you don't really need - you make your code unreadable. I wound organize this code snippet like this:

C#

MySqlConnection exclecon = new MySqlConnection("Server=Localhost;DataBase=password1;user=root;password=nectar");
exclecon.Open();

MySqlCommand cmdYear = new MySqlCommand("INSERT INTO slayear (YEAR) VALUES(@YEAR)", exclecon);
cmdYear.Parameters.AddWithValue("@YEAR", YEAR);
cmdYear.ExecuteNonQuery();

MySqlCommand cmdMonth = new MySqlCommand("INSERT INTO slamonth (MONTH,contenttype) VALUES(@MONTH,@contenttype)", exclecon);
cmdMonth.Parameters.AddWithValue("@MONTH", MONTH);
cmdMonth.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;
cmdMonth.ExecuteNonQuery();

exclecon.Close();

Bikash Prakash Dash · Answer 2 · 2013-05-11T04:09:00

Solution 2

object name is wrong in these two lines

C#

mycom.Parameters.AddWithValue("@MONTH", MONTH);
 mycom.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;

rectify it to

C#

mycom1.Parameters.AddWithValue("@MONTH", MONTH);
               mycom1.Parameters.Add("@contenttype", MySqlDbType.VarChar).Value = contenttype;

Posted 11-May-13 4:09am

Bikash Prakash Dash

Updated 11-May-13 4:10am

v2

Comments

Zoltán Zörgő 11-May-13 15:32pm

Have you read my answer? It's first part is just the same. Don't repeat an answer already given.

Bikash Prakash Dash 12-May-13 2:44am

IS DER ANY PROBLEM, I'M GIVING SOLUTION IN SHORT .

Zoltán Zörgő 12-May-13 6:35am

Don't shout! No, you are not giving a new solution, You have repeated min - without understanding it. And you yell at me, that's rude.

Bikash Prakash Dash 12-May-13 7:12am

I'M NOT SHOUTING , I'M JUST TYPING , HOW CAN I SHOUT IN CODEPROJECT , ANY WAYS SOMEHOW IF I'VE REPEATED, I DON'T THINK ITS AN OFFENCE. SO WHY ARE YOU GETTING ANGRY, COOL MAN , ITS A TECHNICAL WEBSITE , WHERE WE ARE SHARING OUR TECHNICAL SKILLS AND HELP EACH OTHER.

Zoltán Zörgő 12-May-13 15:25pm

Angry, me? No way. Yes, you are shouting - since you use all capital letters. Read this one: http://www.codeproject.com/Articles/64628/Code-Project-Quick-Answers-FAQ#rules paragraph 4.8. But "all caps" is shouting since the internet exists, so please behave your virtual self.
Ah, and by the way, you should "reply" to a comment, if you want the other party to be notified.