add button coding in vb.net for my sql

Question

1.00/5 (1 vote)

See more:

VB

i want to add data in mysql table by pressing the button of vb.net pls tell me the coding of that button

Posted 4-Apr-12 7:55am

anand4886

Updated 8-Oct-17 1:07am

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)

OriginalGriff · Answer 1 · 2012-04-04T08:03:00

Try:

Using con As New MySqlConnection(strConnect)
	con.Open()
	Using com As New MySqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con)
		com.Parameters.AddWithValue("@C1", myValueForColumn1)
		com.Parameters.AddWithValue("@C2", myValueForColumn2)
		com.ExecuteNonQuery()
	End Using
End Using

Manoj Kumar Choubey · Answer 2 · 2012-04-04T08:16:00

Solution 2

http://www.vbdotnetforums.com/database-general-discussion/28818-mysql-insert-command.html[^]
http://forums.mysql.com/read.php?38,10757,14565[^]

http://www.sourcecodester.com/visual-basic-net/how-add-update-delete-record-using-mysql.html[^]
http://www.dreamincode.net/forums/topic/224893-update-mysql-using-vbnet/[^]
(This line for ms access but concept is same as mylsql server )

http://www.sourcecodester.com/visual-basic-net/how-addupdatedelete-record-using-ms-access-database.html[^]

Posted 4-Apr-12 8:16am

Manoj Kumar Choubey

Comments

anand4886 4-Apr-12 14:37pm

Dim cmd As New MySqlCommand

cmd .CommandText = "Insert Into try (Name) values ("Simon")"
cmd.CommandType = CommandType.Text
cmd.Connection = cn

cn.Open()

cmd.ExecuteNonQuery()

cn.Close()
but in cmd.commondtext line .net is showing an error that "end of statement expected",pls correct my code

Bert Mitton 5-Apr-12 11:06am

try cmd.CommandText = "Insert Into try (Name) values ('Simon')"

You want to use single quotes (apostrophes), not double quotes when entering your data.

Manoj Kumar Choubey 5-Apr-12 0:27am

try is keyword (try ---- catch )
check with following query
cmd.CommandText = "Insert Into [try](Name) values("Simon")"