求VB.net大侠帮助,万分感谢
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中执行
==========================================================
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中执行
...全文
相关推荐
VB.NET 代码帮助文档.rar
史上最全的VB.NET帮助文档,控件、数据处理、数据库、系统管理、网络、等详细明了的说明!
VB代码矩阵求逆
可以实现矩阵的求逆运算 。在测量平差中经常使用
VB帮助文档合辑
vbscrip5chs.chm VB部分技巧收集(CHM).chm VB学习系统帮助文档.chm VB.NET学习教程.pdf
VB.NET 求两数之和.rar
我的第一个.NET应用程序,VB.NET 求两数之和,就是实现加法运算,代码如下: Private Sub BtnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnAdd.Click Dim FirstNum As Integer '定义第一个整型变量用于存放第一个数 Dim SecondNum As Integer '定义第二个整型变量用于存放第二个数 FirstNum = TxtNum1.Text '把第一个文本框输入的值赋给第一个变量 SecondNum = TxtNum2.Text '把第二个文本框输入的值赋给第二个变量 LblResult.Text = FirstNum SecondNum '把两个变量的值相加后的结果给到结果标签LblResult End Sub
ASP.NET源码——[论坛社区]DXBBS大侠论坛 v8.1 英文SQL版.zip
ASP.NET源码——[论坛社区]DXBBS大侠论坛 v8.1 英文SQL版.zip


