使用ASP.NET和VB在mysql中插入？ [英] Insert in mysql using ASP.NET and VB?

问题描述

您好

我正在使用VB在ASP.Net上建立一个网站

我是asp.net的新用户

我' d想知道如何在mysql数据库中插入

谢谢

新年快乐微笑| :)



{编辑 - 来自评论的OP代码]

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

推荐答案

试试

使用MySQL数据库的ASP.NET应用程序 [ ^ ]

http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-roles.html [<一个href =http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-roles.html\"target =_ blanktitle =新窗口> ^ ]

http://asp.net-tutorials.com/mysql/getting-已开始/ [ ^ ]

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/[^]

对于插入记录，请在按钮点击事件中尝试以下代码示例。

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

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

问题是在您检查用户是否存在于数据库中之后，而不是实际存在执行SQL以将用户插入数据库，您只是将Sql字符串写入控制台。你需要改为执行sql。

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.

这篇关于使用ASP.NET和VB在mysql中插入？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！