📄 cs.txt
字号:
this.label1.Size = new System.Drawing.Size(352, 16);
this.label1.TabIndex = 1;
this.label1.Text = "（请在网格控件内单击鼠标右键弹出菜单，测试各项功能。）";
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=D:\我的程序库\lgxgrid帮助文档\示例\LgxGrid示例\cs.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global
Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New
Database Password="""";Jet OLEDB:Create System Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False";
//
// menuItem28
//
this.menuItem28.Index = 8;
this.menuItem28.Text = "清除所有数据";
this.menuItem28.Click += new System.EventHandler(this.menuItem28_Click);
//
// menuItem29
//
this.menuItem29.Index = 2;
this.menuItem29.Text = "插入一行";
this.menuItem29.Click += new System.EventHandler(this.menuItem29_Click);
//
// menuItem30
//
this.menuItem30.Index = 3;
this.menuItem30.Text = "删除当前行";
this.menuItem30.Click += new System.EventHandler(this.menuItem30_Click);
//
// menuItem31
//
this.menuItem31.Index = 6;
this.menuItem31.Text = "数据排序";
this.menuItem31.Click += new System.EventHandler(this.menuItem31_Click);
//
// cs
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(368, 277);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.label1,
this.axlgxgrid1});
this.Name = "cs";
this.Text = "Lgxgrid示例";
this.Load += new System.EventHandler(this.cs_Load);
((System.ComponentModel.ISupportInitialize)(this.axlgxgrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new cs());
}
private void cs_Load(object sender, System.EventArgs e)
{
//为控件添加列,参数依次为:列标题,模式(1为textbox,2为combox),列宽,是否允许编辑
axlgxgrid1.hadd("学号", 2, 300, true,null);
axlgxgrid1.hadd ("学生姓名", 2, 800, true,null);
axlgxgrid1.hadd ("语文", 1, 520, true,null);
axlgxgrid1.hadd ("数学", 1, 520, true,null);
axlgxgrid1.hadd ("英语", 1, 520, true,null);
axlgxgrid1.hadd ("物理", 1, 520, true,null);
axlgxgrid1.hadd ("化学", 1, 520, true,null);
axlgxgrid1.hadd ("总分", 1, 658, false,null);
axlgxgrid1.hadd ("平均分", 1, 700, false,null);
//以下合并表头,参数依次为:列标题,起始行号,起始列号,终止行号,终止列号,标识(首次合并为1)
axlgxgrid1.Unite ("学" +(char)13+"号", 0, 0, 1, 0, 1,null);
axlgxgrid1.Unite ("学 生"+(char)13+"姓 名", 0, 1, 1, 1, 1,null);
axlgxgrid1.Unite ("各 科 成 绩", 0, 2, 0, 6, 1,null);
axlgxgrid1.Unite ("统 计", 0, 7, 0, 8, 1,null);
axlgxgrid1.Unite ("语文", 1, 2, 1, 2, 1,null);
axlgxgrid1.Unite ("数学", 1, 3, 1, 3, 1,null);
axlgxgrid1.Unite ("英语", 1, 4, 1, 4, 1,null);
axlgxgrid1.Unite ("物理", 1, 5, 1, 5, 1,null);
axlgxgrid1.Unite ("化学", 1, 6, 1, 6, 1,null);
axlgxgrid1.Unite ("总分", 1, 7, 1, 7, 1,null);
axlgxgrid1.Unite ("平均分", 1, 8, 1, 8, 1,null);
//以下为添加姓名列项目
axlgxgrid1.ComboClear(1);
axlgxgrid1.ComboClear(2);
axlgxgrid1.ComAdd (2, "text", "李明");// '参数依次为:列号,模式(text为文本,sql为以sql查询方式添加,要连接数据库),文本或sql字符串
axlgxgrid1.ComAdd (2, "text", "黄小义");
axlgxgrid1.ComAdd (2, "text", "张天兰");
axlgxgrid1.ComAdd (2, "text", "艾兵");
axlgxgrid1.ComAdd (2, "text", "罗大权");
axlgxgrid1.ComAdd (2, "text", "李燕燕");
axlgxgrid1.Slwok = true; //使列宽可以拖动
}
private void axlgxgrid1_MouseDownEvent(object sender, AxLgxgridV10.__lgxgrid_MouseDownEvent e)
{
if(e.button ==2)
{
Point t;
t=new Point();
t.X=(int)e.x;
t.Y=(int)e.y;
this.contextMenu1.Show(this,t);
}
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
MessageBox.Show(axlgxgrid1.backcolor.ToString() );
}
private void menuItem4_Click(object sender, System.EventArgs e)
{
if (axlgxgrid1.CloseAdd ==true)
{
axlgxgrid1.CloseAdd=false;
}
else
{
axlgxgrid1.CloseAdd =true;
}
}
private void menuItem5_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.lists);
}
private void menuItem6_Click(object sender, System.EventArgs e)
{
axlgxgrid1.GridUnite((int)axlgxgrid1.Nrow,(short)axlgxgrid1.Nlist,(int)axlgxgrid1.NrowEnd,(short)axlgxgrid1.NlistEnd ,0);
}
private void menuItem8_Click(object sender, System.EventArgs e)
{
MessageBox.Show(axlgxgrid1.forecolor.ToString () );
}
private void menuItem7_Click(object sender, System.EventArgs e)
{
axlgxgrid1.HbackColor=Color.FromArgb(100,203, 235,215);
}
private void menuItem9_Click(object sender, System.EventArgs e)
{
axlgxgrid1.HforeColor =Color.Red;
}
private void menuItem10_Click(object sender, System.EventArgs e)
{
axlgxgrid1.LineColor=Color.FromArgb(108,100,100,200);
}
private void menuItem11_Click(object sender, System.EventArgs e)
{
axlgxgrid1.SplitGrid((int)axlgxgrid1.Nrow, (short)axlgxgrid1.Nlist);
}
private void menuItem13_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.Nlist);
}
private void menuItem14_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.NlistEnd);
}
private void menuItem15_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.Nrow);
}
private void menuItem16_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.NrowEnd);
}
private void menuItem17_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.RowHeight);
}
private void menuItem18_Click(object sender, System.EventArgs e)
{
MessageBox.Show(""+axlgxgrid1.rows);
}
private void menuItem19_Click(object sender, System.EventArgs e)
{
if (axlgxgrid1.Slwok ==true)
{
axlgxgrid1.Slwok =false;
}
else
{
axlgxgrid1.Slwok =true;
}
}
private void menuItem22_Click(object sender, System.EventArgs e)
{
axlgxgrid1.Txtsnap=(short)(axlgxgrid1.Txtsnap+1);
if (axlgxgrid1.Txtsnap>2)
{
axlgxgrid1.Txtsnap=0;
}
}
private void menuItem23_Click(object sender, System.EventArgs e)
{
string Pt;
Pt=Application.StartupPath;
if (Pt.Length>3)
Pt=(Pt+"\\");
ADODB.Connection mysjk=new ADODB.ConnectionClass();
string sjkf;
sjkf = "Driver={Microsoft Access Driver (*.mdb)}; DBQ="+Pt+"cs.mdb;";
//MessageBox.Show(sjkf);
mysjk.Open(sjkf,null,null,0);
ADODB.Recordset myre;
object p=null;
myre=mysjk.Execute("select * from cjb;",out p,0);
int i=1;
int j=0;
while(!myre.EOF)
{
for(j=0;j<=myre.Fields.Count-1;j++)
{
axlgxgrid1.SetData(i,j+1,myre.Fields[j]);
}
myre.MoveNext();
i++;
}
myre.Close();
mysjk.Close();
}
private void axlgxgrid1_DataChang(object sender, AxLgxgridV10.__lgxgrid_DataChangEvent e)
{
int ok;
ok=(int)e.lid;
if(ok<8)
{
float Zf=0;
float Pjf=0;
//MessageBox.Show(""+axlgxgrid1.rows);
for(int i=0;i<=4;i++)
{
if(axlgxgrid1.Getdata(e.hid,i+3)!="")
Zf=Zf+float.Parse(axlgxgrid1.Getdata(e.hid,i+3));
}
Pjf=Zf/5;
axlgxgrid1.SetData(e.hid,8,Zf);
axlgxgrid1.SetData(e.hid,9,Pjf);
}
}
private void menuItem25_Click(object sender, System.EventArgs e)
{
axlgxgrid1.Gridclear();
}
private void menuItem27_Click(object sender, System.EventArgs e)
{
LgxgridV10.PrinterInfos pr;
pr = axlgxgrid1.PrinterInfoGet();
pr.TitleText = "2004年春初中学生成绩表";
pr.TableHeadFont.Size = 12;
pr.TableHeadFont.Name = "黑体";
pr.TableHeadFont.Bold = true;
pr.ColorOrBlack = 1;
pr.MainFont.Size = 12;
pr.Ltext = "填表单位：";
pr.TableTop = pr.TableTop - 0.6;
pr.ULtext = "填表人：";
pr.UBtext = "负责人：";
pr.URtest = "审批人： ";
pr.TellText = "说明：（1）各班主任要在期考后3天内把成绩交教导处。" + (char)13+"\n" + " （2）各班班主任要写好质量分析。";
//(char)13+"\n"为插入一个回车换行符
pr.ListScale = 1.7;
pr.RowH = 600;
pr.LineWidth = 2;
axlgxgrid1.PrinterInfoSet(pr);
axlgxgrid1.SetPrintShow();
}
private void menuItem28_Click(object sender, System.EventArgs e)
{
axlgxgrid1.Clear();
}
private void menuItem29_Click(object sender, System.EventArgs e)
{
axlgxgrid1.InRow(axlgxgrid1.Nrow);
}
private void menuItem30_Click(object sender, System.EventArgs e)
{
axlgxgrid1.DelRow(axlgxgrid1.Nrow);
}
private void menuItem31_Click(object sender, System.EventArgs e)
{
axlgxgrid1.OrderList(1,axlgxgrid1.rows,1,LgxgridV10.px.Depress,LgxgridV10.pxmode.CharacterMode);
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -