XtraGrid使用心得.doc

XtraGrid使用心得 XtraGrid的关键类就是：GridControl和GridView。GridControl本身不显示数据，数据都是显示在 GridView/CardView/XXXXView中。GridControl是各种View的容器。所以要控制显示，要从GridView这些类入 手。关于GridControl与GridView的关系，我不说了。下面给出一段代码。实际使用中常用到。 ??????? public Form2()??????? {??????????? InitializeComponent(); ??????????? //不显示内置的导航条。??????????? gc1.UseEmbeddedNavigator = false; ??????????? //不显示分组的面板??????????? gv1.OptionsView.ShowGroupPanel = false;??????????? gv2.OptionsView.ShowGroupPanel = false; ??????????? //自动改变行高适应内容??????????? gv1.OptionsView.RowAutoHeight = true;??????????? gv2.OptionsView.RowAutoHeight = true; ??????????? //允许自动合并单元格??????????? gv1.OptionsView.AllowCellMerge = true; ??????????? //如果主从表中，没有找到从表内容也要显示(默认是不显示的)??????????? gv1.OptionsDetail.AllowExpandEmptyDetails = true; ??????????? //显示自动筛选行(效果跟Excel的自动筛选差不多)??????????? gv2.OptionsView.ShowAutoFilterRow = true; ??????????? //使得GridView不能编辑??????????? gv1.OptionsBehavior.Editable = false;??????????? gv2.OptionsBehavior.Editable = false; ??????????? //内置编辑器显示的模式??????????? gv1.OptionsBehavior.EditorShowMode = DevExpress.Utils.EditorShowMode.Click; ??????????? //主从表显示的功能是否可用??????????? //gv1.OptionsDetail.EnableMasterViewMode = false; ??????????? //如果显示了主从表，每点开个加号，就会显示一个Tabs，里面往往显示了两个面板。??????????? //事实上没必要这样干的。一般选择关闭。关闭的对象是主GridView的此项属性。??????????? gv1.OptionsDetail.ShowDetailTabs = false; ??????????? ??????? } ??????? private void btnExit_Click(object sender, EventArgs e)??????? {??????????? this.Close(); ??????? } ??????? private void btnOk_Click(object sender, EventArgs e)??????? {??????????? //设置连接字符串??????????? DbHelperSQL.ConnectionString = DbHelperSQL.CreateConnectionString(@BUDDHAS\SQLEXPRESS, sa, 00000, RTDMES); ??????????? DataSet ds = new DataSet();??????????? //父GridView的数据??????????? string sql = select sc_prno,sc_prna from mespb04h;??????????? DbHelperSQL.QueryD(sql,ds,main); ??????????? //子GridView的数据??????????? sql = select pa_name,pa_no,sc_prno from mespb09h;??????????? DbHelperSQL.QueryD(s