拖一个dev控件GridControl到窗体上,点击Click here to change view >Create new view > BandedGridView 创建一个绑定视图
写一个类绑定数据源的类如下。
using System;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DevExpress.XtraRichEdit;
using DevExpress.XtraGrid.Views;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraGrid.Views.Base;
using DevExpress.Utils;
using DevExpress.XtraGrid;
using DevExpress.XtraGrid.Columns;
using DevExpress.XtraGrid.Views.BandedGrid;
using DevExpress.XtraEditors.Repository;
namespace HumActDT
{
public class HumActDT
{
//调用函数_各分区每年GDP数据表
public void EDivGDPDTInv(DevExpress.XtraGrid.Views.BandedGrid.BandedGridView bgView, DevExpress.XtraGrid.GridControl gCtl)
{
bgView.Bands.Clear();
bgView.GroupPanelText = "各分区每年GDP数据表";
GridBand year = bgView.Bands.AddBand("年份");
GridBand FirGDP = bgView.Bands.AddBand("农村");
GridBand SecGDP = bgView.Bands.AddBand("城市");
GridBand FirdbArea = FirGDP.Children.AddBand("东北地区");
GridBand FirhbArea = FirGDP.Children.AddBand("华北地区");
GridBand FirxbArea = FirGDP.Children.AddBand("西北地区");
GridBand SecdbArea = SecGDP.Children.AddBand("东北地区");
GridBand SechbArea = SecGDP.Children.AddBand("华北地区");
GridBand SecxbArea = SecGDP.Children.AddBand("西北地区");
DataTable dt = new DataTable();
dt.Columns.Add("年份");
for (int i = 0; i <= 9; i++)
{
string nf = 200 + i.ToString();
dt.Rows.Add(new object[] { nf });
}
for (int j = 10; j <= 13; j++)
{
string nf = 20 + j.ToString();
dt.Rows.Add(new object[] { nf });
}
bgView.OptionsView.ShowColumnHeaders = false;
gCtl.DataSource = dt;
}
}
}
在窗体中调用上面的类,运行效果如下图。