Ecode Ename Apr-sal May-sal Jun-sal Jul-sal
1 abc 10000 10000 10000 10000
2 def 12000 12000 12000 12000
and so on
Thanks
Start by posting the code that you have written as binding to a GridView or ListView is pretty simple and openly published. That way we can make sure that you are at least making an attempt given your previous posts.
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("ID"), new DataColumn("Name"),new DataColumn("Price") });
dt.Rows.Add(1, "Apple",12);
dt.Rows.Add(2, "Grape",32);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
How it works.
Feel free to let me know if you have any question.
Best Regards.
Abraham
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
It seems you're asking about how to prepare data for the pivot table (cross-tab) in C#. For this purpose you can try my
NReco PivotData library:
// lets assume this is your input data with columns:
// "Ecode", "Ename", "month", "salary"
DataTable tbl;
var pvtData = new PivotData(
new[] {"Ecode", "Ename", "month" }, // columns for grouping
new SumAggregatorFactory("salary") // measure to calculate
);
pvtData.ProcessData(new DataTableReader(tbl));
var pvtTbl = new PivotTable(
new [] {"Ecode", "Ename"}, //rows
new [] {"month"}, //columns
pvtData);
// now you can use pvtTbl.RowKeys and pvtTbl.ColumnKeys to iterate through pivot table
// and use indexer to access the value and prepare data for binding to ListView
// or you can use 'PivotTableDataTableWriter' class from NReco.PivotData.Extensions nuget package and get pivoted DataTable:
var dataTableWr = new PivotTableDataTableWriter("Test");
var tbl = dataTableWr.Write(pvtTbl);
NReco.PivotData nuget package can be used for free in single-deployment non-SaaS apps; For advanced components from NReco.PivotData.Extensions commercial license is required.
Member
504 Points
1776 Posts
Gridview/Listview
Jun 30, 2018 11:44 AM|JagjitSingh|LINK
Hi
How to create Gridview/Listview like below
Thanks
All-Star
54581 Points
24476 Posts
Re: Gridview/Listview
Jun 30, 2018 11:52 AM|mgebhard|LINK
Start by posting the code that you have written as binding to a GridView or ListView is pretty simple and openly published. That way we can make sure that you are at least making an attempt given your previous posts.
https://msdn.microsoft.com/en-us/library/fkx0cy6d(v=vs.110).aspx
Also it seems like you might be asking a design question. Do you need a pivot query? Can you explain the problem you are trying to solve?
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-2017
Member
740 Points
321 Posts
Re: Gridview/Listview
Jul 02, 2018 09:42 AM|Abraham Qian|LINK
Hi JagjitSingh,
According to your description, you want to bind the data to gridview/listview, I have made a demo, wish it is useful to you.
Aspx.
<div> <asp:GridView ID="GridView1" runat="server" GridLines="None"></asp:GridView> </div>Code behind.
protected void Page_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[] { new DataColumn("ID"), new DataColumn("Name"),new DataColumn("Price") }); dt.Rows.Add(1, "Apple",12); dt.Rows.Add(2, "Grape",32); this.GridView1.DataSource = dt; this.GridView1.DataBind(); }How it works.
Feel free to let me know if you have any question.
Best Regards.
Abraham
All-Star
102952 Points
19469 Posts
MVP
Re: Gridview/Listview
Jul 03, 2018 01:05 AM|vinz|LINK
That's pretty much basic. What exactly you were trying to accomplish? Also, what have you tried?
If you are new on working with ASP.NET GridView, you can download a copy of this eBook: ASP.NET GridView Control Pocket Guide
Microsoft MVP, CodeProject MVP, C# Corner MVP
Blog | Twitter | Linkedin
Member
80 Points
37 Posts
Re: Gridview/Listview
Jul 18, 2018 06:48 AM|VitaliyMF|LINK
It seems you're asking about how to prepare data for the pivot table (cross-tab) in C#. For this purpose you can try my NReco PivotData library:
// lets assume this is your input data with columns: // "Ecode", "Ename", "month", "salary" DataTable tbl; var pvtData = new PivotData( new[] {"Ecode", "Ename", "month" }, // columns for grouping new SumAggregatorFactory("salary") // measure to calculate ); pvtData.ProcessData(new DataTableReader(tbl)); var pvtTbl = new PivotTable( new [] {"Ecode", "Ename"}, //rows new [] {"month"}, //columns pvtData); // now you can use pvtTbl.RowKeys and pvtTbl.ColumnKeys to iterate through pivot table // and use indexer to access the value and prepare data for binding to ListView // or you can use 'PivotTableDataTableWriter' class from NReco.PivotData.Extensions nuget package and get pivoted DataTable: var dataTableWr = new PivotTableDataTableWriter("Test"); var tbl = dataTableWr.Write(pvtTbl);NReco.PivotData nuget package can be used for free in single-deployment non-SaaS apps; For advanced components from NReco.PivotData.Extensions commercial license is required.