or
I use C # with Visual Studio 2010.
I use an class Order and I have a property <OrderDetail> List. And I would use a grid to binding my class and to use the hierarchy to display also OrderDetail. But I do not know how. Can you explain to me?
public class Order
{ public Order() { } public int Id {get;set;} public List<OrderDetail> ListOrderDetail {get;set;} } public class OrderDetail { public OrderDetail() { } public string Article{get;set;} public int Qte {get;set;} public double Price {get;set;} public double PriceHT {get {return Qte*Price;}} }protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { SqlDataAdapter da = new SqlDataAdapter(); ds = new DataSet(); DataTable dt = new DataTable(); SqlConnection conn = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); conn.Open(); try { cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "MyStored"; da.SelectCommand = cmd; ds.Tables.Clear(); ds.Clear(); ds.AcceptChanges(); da.Fill(ds); Session.Clear(); Session.Add("Source", ds); radgrid.DataSource = null; radgrid.DataSource = ds.Tables[0]; radgrid.DataBind(); } catch { } conn.Close(); } }