作者dichia (ptt处处有温情)
看板Visual_Basic
标题Re: [.NET] 请问有关VB2005连MySQL的问题
时间Thu May 14 01:05:35 2009
※ 引述《iversonjimmy ()》之铭言：
: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
: System.EventArgs) Handles Button2.Click
: '资料库资料的新增
: dbcmd = New MySqlCommand("insert into user_info(name, year, stdID)
: values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text &
: "', dbconn")
: dbadapter = New MySqlDataAdapter(dbcmd)
: User_infoDataSet1.Clear()
: dbadapter.Fill(User_infoDataSet1, "user_info")
: End Sub
试看看
dim dbcmd as string
dbcmd = "insert into user_info(name, year, stdID)
values ('" & TextBox1.Text & "','" & TextBox2.Text & "',
'" & TextBox3.Text &"')"
dbconn.open()
Dim dbcmd As New SqlDbCommand(dbcmd, dbconn)
dim i as integer = dbcmd.ExecuteNonQuery()
If i = 1 Then
MessageBox.Show("资料新增成功！")
Else
MessageBox.Show("资料新增失败！")
End If
dbconn.Close()
--
如果是这样，
我还是会不顾一切的爱下去，
因为我也是明知故犯。
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 123.204.174.12
※ 编辑: dichia 来自: 123.204.174.12 (05/14 01:06)
1F：→ dichia:修改跟删除亦同 05/14 01:07