void ShowData() { LV.Where("GroupID=" + (LB.SelectedValue == null ? "0" : LB.SelectedValue)); LV.ShowData(true); table = LV.DataTable; ToAdd(); LV.Focus(); }
void ShowData() { LV.ShowData(true); if (table == null) { table = LV.DataTable; } ToAdd(); LV.Focus(); }
void LVLoadA() { LVA = new MyListViewA(listView1); LVA.SetDB(conA, "Employees"); //LVA.RowColor = Color.AntiqueWhite;//行色(默认白色) LVA.ColumnWidths = new int[] { 0, 80, 80 };//列宽(默认80) //LVA.RowHeight = 35;//行高(默认25) //LVA.AlignCenter = true;//对齐方式(默认靠左) LVA.SetStyle(); //LVA.SetStyle("宋体", 16f, FontStyle.Bold);//设定样式2 LVA.QueryFields = "EmployeeID as ID,LastName+FirstName as 姓名,TitleOfCourtesy as 尊称";//输出列控制 //LVA.OrderBy("EmployeeID desc");//排序字段与排序方式(默认按首列升序) //LVA.Where("EmployeeID>2");//条件限制(默认无条件限制) //LVA.ClearWhere();//清除条件限制 //LVA.ClearOrderBy();//重置排序方式 //LVA.UseSpecialSQL("select EmployeeID as ID,LastName+FirstName as 姓名 from Employees");//使用自编SQL语句 //LVA.AbandonSpecialSQL();//不使用自编SQL语句并清除掉 LVA.ShowData(); Console.WriteLine("载入条数:" + LVA.CountRows);//获取总行数(数据显示后更新) }