如何把VB提取的SQL数据库表单数据用文本显示出来? 30
Setcn=NewADODB.ConnectionSetrs=NewADODB.Recordsetcn.ConnectionString="dsn=xn;uid=sa;p...
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.ConnectionString = "dsn=xn;uid=sa;pwd=8888;database=hd"
cn.Open
cmd.ActiveConnection = cn
cmd.CommandType = adCmdText
cmd.CommandText = "select * from 成绩表"
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockReadOnly
rs.Open cmd
Set DataGrid1.DataSource = rs
rs是个提取的数据集 现在是用DataGrid1.DataSource显示的 我需要用多个textbox文本显示每个科目的分数怎么做呢 展开
Set rs = New ADODB.Recordset
cn.ConnectionString = "dsn=xn;uid=sa;pwd=8888;database=hd"
cn.Open
cmd.ActiveConnection = cn
cmd.CommandType = adCmdText
cmd.CommandText = "select * from 成绩表"
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockReadOnly
rs.Open cmd
Set DataGrid1.DataSource = rs
rs是个提取的数据集 现在是用DataGrid1.DataSource显示的 我需要用多个textbox文本显示每个科目的分数怎么做呢 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询