Need help in inserting value to mysql table

Question

0.00/5 (No votes)

See more:

Hi all

I have the below tables

Table1: username, password
Table2: username, password, status

Now i want to insert value to this to tables at a time and want to check if data inserted to table2 successfully then status should become 1 else 0

please tell me how to do that

Thank you

Posted 10-Jan-13 18:15pm

Code-Hunt

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)

Wendelius · Answer 1 · 2013-01-10T18:31:00

Solution 1

You can use MySqlConnection and MySqlCommand to execute the insert statements to the database. For an example, have a look at MySqlCommand[^]

Addition:

VB

...
Dim i As Integer = cmd1.ExecuteNonQuery()
cmd1.CommandText = "UPDATE Table SET Status = @NewStatus"

Dim statusparam AS MySqlParameter = new MySqlParameter("@NewStatus", MySqlDbType.Long); 
cmd1.Parameters.Add(statusparam )

If (i > 0) Then
   statusparam.Value = 1
Else
   statusparam.Value = 0
End If
i = cmd1.ExecuteNonQuery()

con.Close()

Posted 10-Jan-13 18:31pm

Wendelius

Updated 10-Jan-13 18:50pm

v2

Comments

[no name] 11-Jan-13 0:41am

Dim cmd1 As MySqlCommand = New MySqlCommand("insert into table1 values username='" + txtusername.Text + "',password='" + txtpassword.Text + "'", con)

Dim i As Integer = cmd1.ExecuteNonQuery()
If (i > 0) Then

Else

End If
con.Close()

This is a part of my code..in this i want that if (i>0) then status(table2 column) should update as 1 else 0

Wendelius 11-Jan-13 0:50am

So can you simply execute an UPDATE statement inside the if? Something like UPDATE Table2 SET Status = @NewStatus.

Note that I have used a parameter in the statement. You should never concatenate values to a Sql statement. This would leave you open to Sql injections, data type conversion problems and so on.

Have a look at the modified answer.

[no name] 11-Jan-13 1:13am

Ok thanks..

Wendelius 11-Jan-13 1:20am

You're welcome :)

One more thing, since you're using multiple statements which logically require a single unit of work, don't forget to use transactions. See MySqlTransaction[^]