Developer Express XtraGrid使用技巧

1.基本grid的用法

1.1 gridControl-->view-->gridView

绑定到grid上的字段可以拖动删除，在任意字段上右键点column chooser 可以将删除的字段添加进来

字段上右键选择实现选定需要的信息和排序

字段上右键选择分组(group by   column)，也可以直接将字段拖到上面实现分组

字段上右键选择group by box后可以取消分组栏，（不能实现拖动分组，但可以选择分组）

字段上右键选择best fit可以实现该字段最佳宽度（便于查看）

1.2 gridControl-->view-->cardView

以卡片形式存放数据

可以自己设定过滤选项

1.3 gridControl-->view-->banderGridView

将字段分段显示，前提是给gridControl先绑定一个dataset

动态绑定的时候不能分段，也不能分行

1.3 gridControl-->view-->advBanderGridView

高级分段显示，动态绑定的字段可以在前台向下拖动后分段，但效果不好，相当于分行显示的样子

1.4 else

可以通过create ner view增加一个view ，但程序只显示你选定的view

zoom的使用   快速上升，也就是选择子项后单独显示（上到最高显示）

1.5 feature browser

-->priview   可以指定在每行中预览的字段

-->filtering 可以自动过滤（optingview.showAutoFiterRow）

1.7 Master-Detail 绑定的问题
首先在gridControl1中指定dataSource 的绑定是主表
然后在level设计器中添加层（retrieve details）
最后用代码绑定：
using (SqlConnection con = new SqlConnection(SqlHepler.CONN_STRING))
             {
                 //SqlDataAdapter sda1 = new SqlDataAdapter("select * from Orders",con);
                 //sda1.Fill(this.northwindDataSet.Orders);

                 SqlDataAdapter sda2 = new SqlDataAdapter("select * from [Order Details]",con);
                 sda2.Fill(this.northwindDataSet.Order_Details);
             }

1.8 summary的用法

             //If the GridOptionsView.ShowFooter option is set,
             //the summary(of course some else can ) can be displayed within the footer cell.
             gridView1.OptionsView.ShowFooter = true;

             //初始化，也可以不用指定
             colOrderID.SummaryItem.FieldName = "OrderID";
             colOrderID.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Count;

2.XtraGrid的打印

借用别人写的一个类

class DevPrint
     {

         //*********************字段*********************
         private string pageHeaderName="";
         private string pageFooterName="";
         private bool isPrintPage=true;
         private bool isPrintDate=true;
         private int headerLocation=1;
         private int footerLocation=1;
         private int pageLocation=3;
         private int dateLocation=5;
         private bool enableEditPage = true;
         private System.Drawing.Font pageHeaderFont = null;
         private System.Drawing.Font pageFooterFont = null;
         private System.Drawing.Printing.Margins devMargins = null;
         private System.Drawing.Printing.PaperKind devPaperKind = System.Drawing.Printing.PaperKind.A4;//可以自定义修改纸张
         private DevExpress.XtraPrinting.PageHeaderArea PHA = new DevExpress.XtraPrinting.PageHeaderArea();
         private DevExpress.XtraPrinting.PageFooterArea PFA = new DevExpress.XtraPrinting.PageFooterArea();
         //*********************字段*********************

         //*********************属性*********************
         //标题
         public string PageHeaderName
         {
            get
            {
                return pageHeaderName;
            }
            set
            {
                pageHeaderName=value;
            }
         }
        
         //页脚
         public string PageFooterName
         {
            get
            {
                return pageFooterName;
            }
            set
            {
                pageFooterName = value;
            }
         }

         //是否打印页数
         public bool IsPrintPage
         {
            get
            {
                return isPrintPage;
            }
            set
            {
                isPrintPage = value;
            }
         }

         //是否打印时间
         public bool IsPrintDate
         {
            get
            {
                return isPrintDate;
            }
            set
            {
                isPrintDate = value;
            }
         }

         //header的位置（左，中，右）
         public int HeaderLocation
         {
            get
            {
                return headerLocation;
            }
            set
            {
                headerLocation=value;
            }
         }

         //footer的位置（左，中，右）
         public int FooterLocation
         {
            get
            {
                return footerLocation;
            }
            set
            {
                footerLocation=value;
            }
         }

         //页数的位置
         public int PageLocation
         {
            get
            {
                return pageLocation;
            }
            set
            {
                pageLocation=value;
            }
         }

         //时间的位置
         public int DateLocation
         {
            get
            {
                return dateLocation;
            }
            set
            {
                dateLocation=value;
            }
         }
           
         //是否允许编辑页面
         public bool EnableEditPage
         {
            get
            {
                return enableEditPage;
            }
            set
            {
                enableEditPage = value;
            }
         }

         //标题字体
         public System.Drawing.Font PageHeaderFont
         {
            get
            {
                return pageHeaderFont;
            }
            set
            {
                pageHeaderFont = value;
            }
         }

         //页脚字体
         public System.Drawing.Font PageFooterFont
         {
            get
            {
                return pageFooterFont;
            }
            set
            {
                pageFooterFont = value;
            }
         }

         //页边距
         public System.Drawing.Printing.Margins DevMargins
         {
            get
            {
                return devMargins;
            }
            set
            {
                devMargins = value;
            }
         }

         //纸张类型
         public System.Drawing.Printing.PaperKind DevPaperKind
         {
            get
            {
                return devPaperKind;
            }
            set
            {
                devPaperKind = value;
            }
         }
         //*********************字段*********************

         private void PageHeaderFooterSettings()
         {
             PHA.Content.Clear();
             PFA.Content.Clear();
             string[] stringsPHA = new string[] {"","",""};
             string[] stringsPFA = new string[] {"","",""};
             switch(headerLocation)
             {
                 case 0:stringsPHA[0]=pageHeaderName;
                  break;
                 case 1:stringsPHA[1]=pageHeaderName;
                  break;
                 case 2:stringsPHA[2]=pageHeaderName;
                  break;
                 default:stringsPHA[1]=pageHeaderName;
                  break;
             };
             switch(footerLocation)
             {
                 case 0:stringsPFA[0]=pageFooterName;
                  break;
                 case 1:stringsPFA[1]=pageFooterName;
                  break;
                 case 2:stringsPFA[2]=pageFooterName;
                  break;
                 default:stringsPFA[1]=pageFooterName;
                  break;
             };
             if (isPrintPage)
             {
                 switch(pageLocation)
                 {
                      case 0:stringsPHA[0]=stringsPHA[0]+"[Page # of Pages #]";
                       break;
                      case 1:stringsPHA[1]=stringsPHA[1]+"[Page # of Pages #]";
                       break;
                      case 2:stringsPHA[2]=stringsPHA[2]+"[Page # of Pages #]";
                       break;
                      case 3:stringsPFA[2]=stringsPFA[2]+"[Page # of Pages #]";
                       break;
                      case 4:stringsPFA[1]=stringsPFA[1]+"[Page # of Pages #]";
                       break;
                      case 5:stringsPFA[0]=stringsPFA[0]+"[Page # of Pages #]";
                       break;
                      default:stringsPFA[2]=stringsPFA[2]+"[Page # of Pages #]";
                       break;
                 };
             }
             if (isPrintDate)
             {
                 switch(dateLocation)
                 {
                      case 0:stringsPHA[0]=stringsPHA[0]+"[Date Printed]";
                       break;
                      case 1:stringsPHA[1]=stringsPHA[1]+"[Date Printed]";
                       break;
                      case 2:stringsPHA[2]=stringsPHA[0]+"[Date Printed]";
                       break;
                      case 3:stringsPFA[2]=stringsPFA[2]+"[Date Printed]";
                       break;
                      case 4:stringsPFA[1]=stringsPFA[1]+"[Date Printed]";
                       break;
                      case 5:stringsPFA[0]=stringsPFA[0]+"[Date Printed]";
                       break;
                      default:stringsPFA[0]=stringsPFA[0]+"[Date Printed]";
                       break;
                 };
             }
             PHA.Content.AddRange(stringsPHA);
             PFA.Content.AddRange(stringsPFA);
             if (pageHeaderFont != null)
             {
                 try
                 {
                     PHA.Font = pageHeaderFont;
                 }
                 catch
                 {
                     PHA.Font = new Font(new System.Drawing.FontFamily("楷体_GB2312"),20,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point);
                 }
             }
             else
             {
                 PHA.Font = new Font(new System.Drawing.FontFamily("楷体_GB2312"),20,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point);
             }
             if (pageFooterFont != null)
             {
                 try
                 {
                     PFA.Font = pageFooterFont;
                 }
                 catch
                 {
                     PFA.Font = new Font(new System.Drawing.FontFamily("楷体_GB2312"),9,System.Drawing.FontStyle.Bold,System.Drawing.GraphicsUnit.Point);
                 }
             }
         }

         public void ShowDevPreview(DevExpress.XtraPrinting.IPrintable printComponent)
         {
             PageHeaderFooterSettings();
             DevExpress.XtraPrinting.PrintingSystem ps = new DevExpress.XtraPrinting.PrintingSystem();
             DevExpress.XtraPrinting.PrintableComponentLink pc =new    DevExpress.XtraPrinting.PrintableComponentLink();
             pc.Component = printComponent;
             pc.Landscape = true;
             //是否指定页边距尺寸
             if (devMargins != null)
                         pc.Margins = devMargins;
             //是否定义纸张
             if (devPaperKind != System.Drawing.Printing.PaperKind.A4)
                pc.PaperKind = devPaperKind;
             //标题和页脚的显示
             pc.PageHeaderFooter =   new DevExpress.XtraPrinting.PageHeaderFooter(PHA,PFA);
             pc.CreateDocument(ps);
             pc.EnablePageDialog = enableEditPage;
             pc.ShowPreview();
          }

     }