16,555
社区成员
发帖
与我相关
我的任务
分享
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
objconn.person_insert(pname.Text, pbirth.Value)
MsgBox(vbOKOnly)
End Sub
Imports System.Data
Imports System.Data.OleDb
Imports System.IO
Public Class ALL_SQL
Dim dr As String = Application.StartupPath()
Dim filename As String = dr & "\人员信息.mdb"
Dim strconn As String = "provider =microsoft.jet.oledb.4.0;data source = " & filename
Dim objconn As New OleDbConnection(strconn)
Sub person_insert(ByVal sname, ByVal sbirth)
objconn.Open() '添加人员基本信息
Dim sqlcmd As OleDb.OleDbCommand = New OleDb.OleDbCommand()
sqlcmd.Connection = objconn
sqlcmd.CommandType = CommandType.Text
sqlcmd.CommandText = "insert into 日期测试 (姓名,出生时间) values ('" & sname & "',#" & sbirth & "#)"
sqlcmd.ExecuteNonQuery()
sqlcmd = Nothing
objconn.Close()
End Sub
End Class