void InitGrid()
{
//gridDataList.Add(new Person("John", "Smith"));
//gridDataList.Add(new Person("Gabriel", "Smith"));
//gridDataList.Add(new Person("Ashley", "Smith", "some comment"));
//gridDataList.Add(new Person("Adrian", "Smith", "some comment"));
//gridDataList.Add(new Person("Gabriella", "Smith", "some comment"));
//gridControl.DataSource = gridDataList;
string strsql = "select order_no,package_no from t_order";
string strsql2 = "select order_no,product_no from t_orderitem";
ConCls cls=new ConCls ();
SqlDataAdapter dap = new SqlDataAdapter(strsql, ConCls.GetCon());
SqlDataAdapter dap2 = new SqlDataAdapter(strsql2, ConCls.GetCon());
DataSet ds = new DataSet();
dap.Fill(ds, "order");
dap2.Fill(ds, "orderitem");
ds.Relations.Add("relations", ds.Tables["order"].Columns["order_no"], ds.Tables["orderitem"].Columns["order_no"]);
gridControl.DataSource = ds.Tables["order"];
}