求VB.net大侠帮助,万分感谢

qqqwwwin qqqwwwin 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
VB.NET2008,数据库access2007,无报错,执行插入数据后数据库无反应,数据库类代码,执行代码如下
==========================================================
Private oldebConnection As OleDbConnection
Private oldebDataAdapter As OleDbDataAdapter
Private oldebCommand As OleDbCommand
Private dataSet As New DataSet
Private myDataSet As DataSet

Private mingcheng As TextBox
Private zhuanghao As TextBox
Private maishen As TextBox
Private fangshi As TextBox

'创建一个数据连接
Private strCon As String = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\wesley\Documents\Visual Studio 2008\Projects\WindowsApplication1\WindowsApplication1\Database.accdb;Jet OLEDB:Database Password=13579; "
Private myConn As OleDbConnection = New OleDbConnection()


Public Sub GetConnected()


Dim myConn As OleDbConnection = New OleDbConnection()
myConn.ConnectionString = strCon
Dim strCom As String = " SELECT * FROM xiangmu "
'创建一个 DataSet
myDataSet = New DataSet()
myConn.Open()
'通过OleDbDataAdapter对象得到一个数据集
Dim myCommand As OleDbDataAdapter = New OleDbDataAdapter(strCom, myConn)
'把Dataset绑定数据表
myCommand.Fill(myDataSet, "xiangmu")

End Sub
Public Sub closed()
myConn.Close()
'关闭此数据连接
End Sub
Public Sub insert()
Dim strInsert As String

Dim mingcheng As New TextBox
Dim zhuanghao As New TextBox
Dim maishen As New TextBox
Dim fangshi As New TextBox

Dim db As New ClassDB
db.GetConnected()
strInsert = " INSERT INTO xiangmu (mingcheng,zhuanghao,maishen,fangfa )" _
& " VALUES ( '" & mingcheng.Text + "','" & zhuanghao.Text + "','" & maishen.Text + "','" & fangshi.Text + "')"

End Sub
--------------------------------------------------执行-------------------
db.GetConnected()
db.insert()
在FORM2中执行
...全文

相关推荐

评论 6
收藏 已收藏
分享
返回顶部
qqqwwwin
VB 16,718 成员 110,520 内容