Manage Format of Table

Question

Database table dynamic (commidities are dynamic)

Id  Month  Commodity  Amount
----------------------------
1   May     wheat      100
2   May     rice       200
3   June    wheat      400
4   July    maize      100

I can show it as it is on frontend easily but requirement is different

I want to display data with gridview in below format:

Month      wheat    rice    maize
--------------------------------
May        100      200     
June       400
July                        100

protected void Page_Load(object sender, EventArgs e)
 {
    if (!Page.IsPostBack)
    {
        getdata();
    }
}

public void getdata()
{
    using (GridFormatEntities context = new GridFormatEntities())
    {
        var result = (from r in context.tbl_Commodity
                      select new
                      {
                          Id=r.Id,
                          Month = r.Month,
                          Commodity = r.Commodity,
                          Amount = r.Amount
                      }).ToList();
        grdData.DataSource = result;
        grdData.DataBind();

    }
}

But you know that you have a bigger problem next year? Back to your issue, you could look at [this PIVOT implementation](http://stackoverflow.com/questions/963491/pivot-data-using-linq). Although i'm not sure if it works with your LINQ provider. — Tim Schmelter, Mar 23 '15 at 13:00
yes but i have face issue to total amount for same commodity & same month — sandeep singh, Mar 23 '15 at 13:04

Manage Format of Table

0 Answers0