Insert in mysql using ASP.NET and VB?

Question

1.00/5 (1 vote)

See more:

Hello
I am making a web site in ASP.Net using VB
And i am new in asp.net
I'd like to know how to insert in mysql database
Thanks
Happy New Year Smile | :)

{Edit - OP code from comment]

Imports MySql.Data.MySqlClient
Imports System.Data

Partial Class _Default
    Inherits System.Web.UI.Page
    Dim sqladapter As MySqlDataAdapter
    Dim sqlcommand As MySqlCommand
    Dim constr As String = "Database=teste;" & _
   "Data Source=localhost;" & _
   "User Id=root;"
    Dim con As New MySqlConnection(constr)
    Dim sqlQuery As String
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim cmd1 As New MySqlCommand("SELECT username FROM dados WHERE username='" & username.Text & "'", con)
        con.Close()
        con.Open()
        Dim reader As MySqlDataReader = cmd1.ExecuteReader
        If reader.HasRows = False Then
            Console.WriteLine("INSERT INTO dados (username, password) VALUES ('" & username.Text & "', '" & password.Text & "'")
            username.Text = ""
            password.Text = ""

        End If
        con.Close()
    End Sub

I have tried this code but when i click to regist nothing happens

Posted 1-Jan-14 5:23am

Member 10494891

Updated 1-Jan-14 7:57am

CHill60

v2

Add a Solution

Comments

ZurdoDev 1-Jan-14 11:26am

I already answered this. Why are you reposting?

Member 10494891 1-Jan-14 11:29am

I have deleted the other one by mistake
Sorry :/
Can you help me?

ZurdoDev 1-Jan-14 11:34am

Sure. The problem is there are many ways to do this. I would suggest creating yourself a helper class (perhaps even search google for one) and use the SqlConnection and SqlCommand classes. There's more to it than that but that should get you started.

Member 10494891 1-Jan-14 11:44am

Imports MySql.Data.MySqlClient
Imports System.Data

Partial Class _Default
Inherits System.Web.UI.Page
Dim sqladapter As MySqlDataAdapter
Dim sqlcommand As MySqlCommand
Dim constr As String = "Database=teste;" & _
"Data Source=localhost;" & _
"User Id=root;"
Dim con As New MySqlConnection(constr)
Dim sqlQuery As String
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim cmd1 As New MySqlCommand("SELECT username FROM dados WHERE username='" & username.Text & "'", con)
con.Close()
con.Open()
Dim reader As MySqlDataReader = cmd1.ExecuteReader
If reader.HasRows = False Then
Console.WriteLine("INSERT INTO dados (username, password) VALUES ('" & username.Text & "', '" & password.Text & "'")
username.Text = ""
password.Text = ""

End If
con.Close()
End Sub
I have tried this code but when i click to regist nothing happens

JoCodes 1-Jan-14 13:20pm

Getting any error?

Member 10494891 1-Jan-14 14:18pm

there is no error

ZurdoDev 1-Jan-14 14:16pm

Debug it and tell us where it goes wrong.

Member 10494891 1-Jan-14 14:18pm

there is no error

ZurdoDev 1-Jan-14 14:19pm

Debug it and tell us where it goes wrong.

Member 10494891 1-Jan-14 14:31pm

do i have to do something in the html code?

ZurdoDev 1-Jan-14 14:47pm

Do you know how to debug? Do you know how to use breakpoints? That's what you have to do.

Member 10494891 1-Jan-14 14:56pm

i have debug it what do you want me to do next?

ZurdoDev 1-Jan-14 14:59pm

Debug means to put a breakpoint in your code and then step through it and see what is happening. If you do that you'll see what the problem is. I can't run your code, you have to.

Member 10494891 1-Jan-14 15:05pm

sorry i dont understand to much about breakpoints
i put and then i see what?

ZurdoDev 1-Jan-14 15:05pm

A breakpoint stops the code execution so that you can then step through the code one line at a time to see what is happening.

Member 10494891 1-Jan-14 15:13pm

i have put the breakpoints to see if it would work and still the same problem

ZurdoDev 1-Jan-14 15:14pm

That doesn't tell me anything. What are you expecting it to do?

Member 10494891 1-Jan-14 15:16pm

the problem is when i click the button to register nothing happen

ZurdoDev 1-Jan-14 15:17pm

Yes, you have said that many times. What are you wanting to have happen?

Member 10494891 1-Jan-14 15:19pm

i want to register the username and the password in the database

ZurdoDev 1-Jan-14 15:22pm

That's because you don't have any code to do that. See my solution below. You aren't executing the sql code to insert the record.

Member 10494891 1-Jan-14 15:27pm

can you edit my code with that please?

ZurdoDev 1-Jan-14 15:31pm

Just change cmd1.CommandText to the new Sqlstatement and then execute again, after you close the reader. You really need to study up on this because there is too much to teach you in this way.

Member 10494891 1-Jan-14 15:37pm

cmd1.commandtext ??

Member 10494891 1-Jan-14 15:40pm

i have already done a project with vb to insert in the database
but with asp.net its the first time

ZurdoDev 1-Jan-14 16:00pm

It can be the same code when it comes to database access.

Member 10494891 1-Jan-14 16:06pm

i am going to try the same code

Member 10494891 1-Jan-14 16:07pm

do i have to do anything in the html code of the button or in the webconfig file ?

ZurdoDev 1-Jan-14 16:15pm

No. You are already running code that goes against the database so if that is working then you just need to make the change of actually calling the sql.

Member 10494891 1-Jan-14 16:18pm

can you edit my code with that please?

Member 10494891 1-Jan-14 17:24pm

It's Urgent

ZurdoDev 1-Jan-14 19:47pm

You need to learn. Follow some of the links in the solutions listed. I can't do your job for you.

Member 10494891 1-Jan-14 20:53pm

those links are correct?

ZurdoDev 1-Jan-14 21:08pm

The point is you need to learn. There is too much to try and teach you all in this little comment section.

Member 10494891 1-Jan-14 21:26pm

Alright
Where should i put :new Sqlstatement ?

ZurdoDev 1-Jan-14 21:29pm

After you check to see if the record exists. Did you write the original code?

Member 10494891 1-Jan-14 21:34pm

i copy the code from the other project in VB

3 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)

Abhinav S · Answer 1 · 2014-01-01T06:23:00

Solution 1

Try
An ASP.NET Application Using a MySQL Database[^]
http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-roles.html[^]
http://asp.net-tutorials.com/mysql/getting-started/[^]

Posted 1-Jan-14 6:23am

Abhinav S

Comments

Member 10494891 1-Jan-14 12:43pm

None of those links helped me :/

JoCodes · Answer 2 · 2014-01-01T07:44:00

For insert record try something as below code sample inside the button click event.

VB

Dim retVal As Integer
Dim sConnectionString As String = "server=(local);database=dbName;user=ASPNET" //replace your connection string here
Dim conn As New SqlConnection(sConnectionString)
        Dim sSQL As String
        sSQL = "INSERT INTO TableName(ColumnName1, ColumnName2)" & _
           " VALUES (@parameter1, @parameter2)"
        Dim cmd As New SqlCommand(sSQL, conn)   
        
        cmd.Parameters.Add(New SqlParameter("@firstname", "SomeValue"))
        cmd.Parameters.Add(New SqlParameter("@lastname", "SomeValue"))
        conn.Open()
        Try
            retVal = cmd.ExecuteNonQuery()
            
        Catch ex As System.Exception
           //Error Code 
        Finally
            conn.Close()
        End Try
    End Sub

ZurdoDev · Answer 3 · 2014-01-01T09:22:00

Solution 3

The issue is after you check to see if the user exists in your database, instead of actually executing the SQL to insert the user into your database you are just writing the Sql string to the console. You need to execute the sql instead.

Posted 1-Jan-14 9:22am

ZurdoDev