-
本版专家分：0结帖率 100% -
....我还有一个问题,就是:我把数据库一个表的记录按一个字段(关键字)递增排列显示在datagrid控件中,显示的同时,把此排序后的记录集的第一条显示在一个文本框,这该怎么实现啊?求你们帮帮我!先谢了!在线等!问题点数：20分
-
本版专家分：749 -
dim frm as Form
for each frm in forms
unload frm
next
-
本版专家分：749
-
Dim conn As New ADODB.Connection
With conn
.Provider = "SQLOLEDB"
.ConnectionString = "DATA SOURCE=(local);" & _
"INITIAL CATALOG=YY;" & _
"User ID = sa; Password=abc"
.Open
End With
Dim strSQl As String
strSQl = "Select * from 表1"
Dim rs As New ADODB.Recordset
rs.Open strSQl, conn, adOpenKeyset, adLockBatchOptimistic
Set grd.DataSource = rs
Text1.Text = rs("字段a")