private void MakeDataView()
{
DataView dv = new DataView(); dv.Table = DataSet1.Tables["Suppliers"];
dv.AllowDelete = true;
dv.AllowEdit = true;
dv.AllowNew = true;
dv.RowFilter = "City = 'Berlin'";
dv.RowStateFilter = DataViewRowState.ModifiedCurrent;
dv.Sort = "CompanyName DESC";
// Simple bind to a TextBox control
Text1.DataBindings.Add("Text", dv, "CompanyName");
}
没试去用
dv.RowFilter = "distinct City";
我想应该是不好使。还是在查询的SQL语句中完成吧。
{
DataView dv = new DataView(); dv.Table = DataSet1.Tables["Suppliers"];
dv.AllowDelete = true;
dv.AllowEdit = true;
dv.AllowNew = true;
dv.RowFilter = "City = 'Berlin'";
dv.RowStateFilter = DataViewRowState.ModifiedCurrent;
dv.Sort = "CompanyName DESC";
// Simple bind to a TextBox control
Text1.DataBindings.Add("Text", dv, "CompanyName");
}
没试去用
dv.RowFilter = "distinct City";
我想应该是不好使。还是在查询的SQL语句中完成吧。
我是想用dateview筛选出不重复的记录做为Combox的下拉选项,如果每个Combox都从数据庫 中重新取回table 的话是似呼有些不合算,因为我的Combox和Grid都是用同一个表按理说只要生成不同的视图就可以了,Dateview真的做不到吗?