void DefineView() { LV = new MyListViewA(listView1); LV.SetDB(Global.con, "Labels"); LV.ColumnWidths = new int[] { 0, 0, 0, 230, 65 };//列宽(默认80) LV.RowHeight = 30; LV.RowColor = Color.LightGray; LV.SetStyle("Cambria", 16, FontStyle.Bold); LV.QueryFields = "LabelID,GroupID,Path,LabelName as 标签名,LabelOrder as 序号"; LV.Where("GroupID=" + GroupID); LV.OrderBy("LabelOrder"); ShowData(); }
void DefineView() { LB = new MyListBox(listBox1, "select * from NoteGroups order by GroupOrder", "GroupName", "GroupID", Global.con); CBB = new MyComboBox(comboBox1, "select * from NoteGroups order by GroupOrder", "GroupName", "GroupID", Global.con); try { LB.SelectedIndex = 0; } catch { LB.SelectedIndex = -1; } //==== LV = new MyListViewA(listView1); LV.SetDB(Global.con, "Notes"); LV.ColumnWidths = new int[] { 0, 0, 0, 150, 220 };//列宽(默认80) LV.RowHeight = 30; //LV.AlignCenter = true; LV.SetStyle("Cambria", 14, FontStyle.Bold); LV.QueryFields = "NoteID,GroupID,Content,TimeOfRevision as 修改时间,Title as 笔记标题"; LV.OrderBy("TimeOfRevision desc"); ShowData(); }
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);//获取总行数(数据显示后更新) }