Dim conn1 as New OleDbConnection("your aa.mdb connect string") Dim conn2 as New OleDbConnection("your bb.mdb connect string")Dim DA1 as New OleDbDataAdapter("select * from cctable order by datetime,conn1) Dim DA2 as New OleDbDataAdapter("select * from cctable order by datetime,conn2)Dim DS1 as New DataSet() Dim DS2 as New DataSet()DA1.fill(DS1) DA2.fill(DS2)DataGrid1.Datasource=DS1 DataGrid1.Databind() DataGrid2.Datasource=DS2 DataGrid2.Databind() ............
[Visual Basic, C#] 以下示例指示 DataView 按照两列对表进行排序。 [Visual Basic] Private Sub SortByTwoColumns() ' Get the DefaultViewManager of a DataTable. Dim myDataView As DataView myDataView = DataTable1.DefaultView ' By default, the first column sorted ascending. myDataView.Sort = "State, ZipCode DESC" End Sub [C#] private void SortByTwoColumns() { // Get the DefaultViewManager of a DataTable. DataView myDataView = DataTable1.DefaultView; // By default, the first column sorted ascending. myDataView.Sort = "State, ZipCode DESC"; }
不好意思,我发帖的时候一个回复也没有,怪我速度太慢了,sorry:)
跨 ACCESS 数据库查询的SQL语句
解决方法: 例如“装材类型”和“装材”两张表是在不同的数据库中的,具体查询方法,如下: @"Select * from 装材类型 as a INNER JOIN [;database=" + AppDomain.CurrentDomain.BaseDirectory + "装材.zc].装材 as b ON a.BH=b.LXBH"
Dim conn2 as New OleDbConnection("your bb.mdb connect string")Dim DA1 as New OleDbDataAdapter("select * from cctable order by datetime,conn1)
Dim DA2 as New OleDbDataAdapter("select * from cctable order by datetime,conn2)Dim DS1 as New DataSet()
Dim DS2 as New DataSet()DA1.fill(DS1)
DA2.fill(DS2)DataGrid1.Datasource=DS1
DataGrid1.Databind()
DataGrid2.Datasource=DS2
DataGrid2.Databind()
............
[Visual Basic]
Private Sub SortByTwoColumns()
' Get the DefaultViewManager of a DataTable.
Dim myDataView As DataView
myDataView = DataTable1.DefaultView
' By default, the first column sorted ascending.
myDataView.Sort = "State, ZipCode DESC"
End Sub
[C#]
private void SortByTwoColumns()
{
// Get the DefaultViewManager of a DataTable.
DataView myDataView = DataTable1.DefaultView;
// By default, the first column sorted ascending.
myDataView.Sort = "State, ZipCode DESC";
}
解决方法:
例如“装材类型”和“装材”两张表是在不同的数据库中的,具体查询方法,如下:
@"Select * from 装材类型 as a INNER JOIN [;database=" + AppDomain.CurrentDomain.BaseDirectory + "装材.zc].装材 as b ON a.BH=b.LXBH"
解释: [;database=path;pwd=12].A
ACCESS的跨库是通过中括号实现的,包括路径,密码设置等;跨库的前提是已经打开了一个Connection。
我先试试..
myDataView.Sort = "State, ZipCode DESC";state zipcode 都是指什么那?
dv.Sort = "失败率 DESC";
DataGrid1.DataSource = dv;
DataGrid1.DataBind();编译通过,能运行,就是排的不对.