一个窗体的数据库维护:
Private add As ClsData
Private Sub Command1_Click()
Call add.addnew
End SubPrivate Sub Form_Load()
Dim rs As ADODB.Recordset
Dim strsql As String
Set rs = New ADODB.Recordset
strsql = "select * from Student "
rs.Open strsql, datasj.gConn, adOpenStatic
Set DataGrid1.DataSource = rs
Set txtXm.DataSource = rs
txtXm.DataField = rs("姓名").Name
Set txtXb.DataSource = rs
txtXb.DataField = rs("性别").Name
Set txtXbb.DataSource = rs
txtXbb.DataField = rs("系别").Name
Set txtBj.DataSource = rs
txtBj.DataField = rs("班级").Name
End SubOption Explicit
Dim gconnectionstring As String
Dim cn As ADODB.ConnectionSub main()
gconnectionstring = "DBQ=" & App.Path & "\test.mdb ;driver={microsoft Access driver (*.mdb)};"
datasj.gConn.Open
frmMain.Show
End SubOption Explicit
Public Function addnew(strsql As String, str As String)
Dim rs As ADODB.Recordset
strsql = "select * from student where 姓名=" & str & ""
rs.Open strsql, datasj.gConn, adOpenKeyset, adLockOptimistic
rs!姓名 = txtXm.Text
rs!性别 = txtXb.Text
rs!系别 = txtXbb.Text
rs!班级 = txtBj.Text
End FunctionPublic Function del(strsql As String)End FunctionPublic Function update(strsql As String)End Function
怎么添加数据不进去呢
Private add As ClsData
Private Sub Command1_Click()
Call add.addnew
End SubPrivate Sub Form_Load()
Dim rs As ADODB.Recordset
Dim strsql As String
Set rs = New ADODB.Recordset
strsql = "select * from Student "
rs.Open strsql, datasj.gConn, adOpenStatic
Set DataGrid1.DataSource = rs
Set txtXm.DataSource = rs
txtXm.DataField = rs("姓名").Name
Set txtXb.DataSource = rs
txtXb.DataField = rs("性别").Name
Set txtXbb.DataSource = rs
txtXbb.DataField = rs("系别").Name
Set txtBj.DataSource = rs
txtBj.DataField = rs("班级").Name
End SubOption Explicit
Dim gconnectionstring As String
Dim cn As ADODB.ConnectionSub main()
gconnectionstring = "DBQ=" & App.Path & "\test.mdb ;driver={microsoft Access driver (*.mdb)};"
datasj.gConn.Open
frmMain.Show
End SubOption Explicit
Public Function addnew(strsql As String, str As String)
Dim rs As ADODB.Recordset
strsql = "select * from student where 姓名=" & str & ""
rs.Open strsql, datasj.gConn, adOpenKeyset, adLockOptimistic
rs!姓名 = txtXm.Text
rs!性别 = txtXb.Text
rs!系别 = txtXbb.Text
rs!班级 = txtBj.Text
End FunctionPublic Function del(strsql As String)End FunctionPublic Function update(strsql As String)End Function
怎么添加数据不进去呢
解决方案 »
- 寻求老鸟,经验支持!!
- 求助!用MsChart画的图表,图例怎样才能显示在下面?
- 关于webbrowser出现错误91:对象变量或 With 块变量未设置的问题
- 求救!!!!access连接
- 求助!VB6应用程序向导不能用了
- 请问在Excel中,能否关闭Excel的屏幕刷新,等到程序执行后再开放。
- 请问怎么屏蔽VB文本框中的右键菜单
- 寻找VB中在Windosw98,Windows2000系统中都能用的netmeeting控件。
- 初学API,Sunday的一个QQ尾巴病毒
- 用Controls.Add新创建的控件对象,如何截获它的事件!!!!!!!!!
- 一个datagrid的问题????急!!!!!!
- 文本文件中一列数字1-9,我要把它乱序重排该怎么做啊?
rs!性别 = txtXb.Text
rs!系别 = txtXbb.Text
rs!班级 = txtBj.Text
rs.update
就可以对记录集添加了,为什么写那么多的东西啊