Dim strSQL As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT 姓名,学好,总分,课程 FROM ZERO_TAB", cnn
If Not rs.EOF Then
Set Datagrid.DataSource = rs
End If
请教如何实现按照总分在DATAGRID里面按照降序排列???谢谢
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.ConnectionString = connstr
cnn.Open
rs.Open "SELECT 姓名,学好,总分,课程 FROM ZERO_TAB", cnn
If Not rs.EOF Then
Set Datagrid.DataSource = rs
End If
请教如何实现按照总分在DATAGRID里面按照降序排列???谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货