好记性不如烂笔头,写下来,以后可以查看。
private void mnuLoad_Click(object sender, System.EventArgs e)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
// TODO: Load Customers
![](/Images/OutliningIndicators/InBlock.gif)
Database db = null;
db = DatabaseFactory.CreateDatabase();
![](/Images/OutliningIndicators/InBlock.gif)
DataSet ds = db.ExecuteDataSet(
CommandType.Text,
"SELECT CustomerID,CompanyName,ContactName,ContactTitle From Customers");
![](/Images/OutliningIndicators/InBlock.gif)
gridControl1.DataSource = ds.Tables[0];
![](/Images/OutliningIndicators/InBlock.gif)
//设置成一次选择一行,并且不能被编辑
this.gridView1.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.gridView1.OptionsBehavior.Editable = false;
this.gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
//设置列的标题
gridView1.Columns[0].Caption = "客户编号";
gridView1.Columns[1].Caption = "公司名称";
gridView1.Columns[2].Caption = "联系人";
gridView1.Columns[3].Caption = "联系内容";
//设置列的名称,便于进行分组和Foot的统计等信息显示
gridView1.Columns[0].Name = "CustomerID";
//增加一个Group列进行分组
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[]
{
new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Count, "CustomerID", null, "(Count={0})")});
![](/Images/OutliningIndicators/InBlock.gif)
}
另外又做了一个全面的测试,代码如下:
private void mnuLoad_Click(object sender, System.EventArgs e)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
// TODO: Load Customers
![](/Images/OutliningIndicators/InBlock.gif)
Database db = null;
db = DatabaseFactory.CreateDatabase();
![](/Images/OutliningIndicators/InBlock.gif)
DataSet ds = db.ExecuteDataSet(
CommandType.Text,
"SELECT ID,Name,Age From UserInfo");
![](/Images/OutliningIndicators/InBlock.gif)
gridControl1.DataSource = ds.Tables[0];
![](/Images/OutliningIndicators/InBlock.gif)
//设置成一次选择一行,并且不能被编辑
this.gridView1.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
this.gridView1.OptionsBehavior.Editable = false;
this.gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;
//设置列的标题
gridView1.Columns[0].Caption = "编号";
gridView1.Columns[1].Caption = "名称";
gridView1.Columns[2].Caption = "年龄";
//设置列的名称,便于进行分组和Foot的统计等信息显示
gridView1.Columns[0].Name = "ID";
gridView1.Columns[1].Name = "Name";
gridView1.Columns[2].Name = "Age";
//增加一个Group列进行分组
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[]
{
new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Count, "ID", null, "(Count={0})")});
![](/Images/OutliningIndicators/InBlock.gif)
//增加一个Group列进行分组
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
this.gridView1.GroupSummary.AddRange(new DevExpress.XtraGrid.GridSummaryItem[]
{
new DevExpress.XtraGrid.GridGroupSummaryItem(DevExpress.Data.SummaryItemType.Max , "Age", null, "(Max={0})")});
![](/Images/OutliningIndicators/InBlock.gif)
//设置并制作Foot下面的统计信息
this.gridView1.GroupFooterShowMode = DevExpress.XtraGrid.Views.Grid.GroupFooterShowMode.VisibleAlways;
this.gridView1.OptionsView.ShowFooter = true;
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
gridView1.Columns[2].SummaryItem.DisplayFormat = "(Age={0})";
gridView1.Columns[2].SummaryItem.FieldName = "Age";
gridView1.Columns[2].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
}
//设置成cardview格式
private void menuItem2_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
gridControl1.MainView = this.cardView1;
}
//设置成GridView格式
private void menuItem4_Click(object sender, EventArgs e)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
gridControl1.MainView = this.gridView1 ;
}