谁能告诉我如何将vb.net 2010中输入到文本框(多行)中的数据保存到我的数据库(mysql)中?
发布于 2014-10-05 16:05:30
发布于 2014-10-06 12:52:05
下面是在mysql数据库中插入记录的代码:
假设您有一个名为(myDB)的mysql数据库和一个名为(myTable)的表。myTable中有两个字段:ID(整型)和TextBoxData(文本)
Imports MySql.Data.MySqlClient
Imports System.Data.OleDb
Public Class Form1
Dim conn As New MySqlConnection
Sub connect()
Dim DatabaseName As String = "myDB"
Dim server As String = "ip address here"
Dim userName As String = "username here"
Dim password As String = "password here"
If Not conn Is Nothing Then conn.Close()
conn.ConnectionString = String.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false", server, userName, password, DatabaseName)
Try
conn.Open()
MsgBox("Connected")
Catch ex As Exception
MsgBox(ex.Message)
End Try
conn.Close()
End Sub
End Class‘以下代码用于写入MySQL数据库:尝试使用conn.Open() Catch ex As Exception
End Try
Dim cmd As New MySqlCommand(String.Format("INSERT INTO `myTable` (`ID` , `TextBoxData`) VALUES ('{0}' , '{1}')", "", TextBox1.Text))
cmd.ExecuteNonQuery()
conn.Close()https://stackoverflow.com/questions/26200717
复制相似问题