private void Bind() { DataSet tableSet = new DataSet(); DataTable pTable = GetTable("select distinct LXMC,count(LXMC) from table group by LXMC"); pTable.TableName = "主表"; tableSet.Tables.Add(pTable); foreach (DataRow row in pTable.Rows) { string mc = row["LXMC"].ToString(); if (mc != "" && !string.IsNullOrEmpty(mc)) { string sql = "select LXMC,QLMC,TBDW from table where LXMC='" + mc + "'"; DataTable childTable = GetTable(sql); childTable.TableName = mc; tableSet.Tables.Add(childTable); tableSet.Relations.Add(mc, tableSet.Tables["主表"].Columns["LXMC"], tableSet.Tables[mc].Columns["LXMC"]); } } gridControl1.DataSource = tableSet.Tables["主表"].DefaultView; }