我的程序,用adodc连接数据库,在access库中是升序排列的,可是用datagrid显示的时候,却不安升序显示了?帮帮我,请问怎么办?
Dim strConnect As String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\东辛\sj.mdb;Mode=ReadWrite;Persist Security Info=False"
Adodc1.ConnectionString = strConnect
Set DataGrid1.DataSource = Adodc1
Dim strConnect As String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\东辛\sj.mdb;Mode=ReadWrite;Persist Security Info=False"
Adodc1.ConnectionString = strConnect
Set DataGrid1.DataSource = Adodc1
Dim CN As New ADODB.Connection
Dim RS As New ADODB.Recordset
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
App.Path & "\File.mdb;Persist Security Info=False"
RS.CursorLocation = adUseClient
RS.Open "select * from Table1 order by Field1", CN, adOpenDynamic, adLockReadOnlyset DataGrid1.DataSource = RS试试,好久没用过VB了,不知对不对.打开ADO记录集的时候SQL语句中用Order排序
http://www.sijiqing.com/vbgood/taishan/index.html