Merge Grid view data on select
Question
Answers
All replies
-
User283571144 posted
Hi asp.ambur,
According to your description, I suggest you could create a dropdownlist change event. In this event you could rebind your gridview with the right datasource.
About how to merge the same row, I suggest you could firstly using datatable's AsEnumerable method ,then you could use Linq group to merge the same row's value.
More details, you could refer to below codes sample:
Aspx:
<form id="form1" runat="server"> <div> <asp:DropDownList ID="DropDownList1" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged" AutoPostBack="true"> <asp:ListItem Text="Single" Value="Single"></asp:ListItem> <asp:ListItem Text="Merge" Value="Merge"> </asp:ListItem> </asp:DropDownList> <hr /> <asp:GridView ID="GridView1" runat="server"></asp:GridView> </div> </form>Code-behind:
public partial class GrdiviewDropDownlistChange : System.Web.UI.Page { DataTable SingleTable; DataTable MergeTable; protected void Page_Load(object sender, EventArgs e) { SingleTable = new DataTable(); SingleTable.Columns.Add("Ref No"); SingleTable.Columns.Add("ItemName"); SingleTable.Columns.Add("Date"); SingleTable.Columns.Add("Qty"); SingleTable.Columns.Add("Amount"); SingleTable.Columns.Add("Per Qty Amount"); MergeTable = new DataTable(); MergeTable.Columns.Add("Ref No"); MergeTable.Columns.Add("ItemName"); MergeTable.Columns.Add("Date"); MergeTable.Columns.Add("Qty"); MergeTable.Columns.Add("Amount"); MergeTable.Columns.Add("Per Qty Amount"); SingleTable.Rows.Add("R1", "Apple", "01-Dec-17", 2, 500, 250); SingleTable.Rows.Add("R1", "Mango", "12-Dec-17", 6, 300, 50); SingleTable.Rows.Add("R2", "Banana", "05-Dec-17", 10, 20, 2); SingleTable.Rows.Add("R3", "Apple", "05-Dec-17", 5, 50, 10); var result = from row in SingleTable.AsEnumerable() group row by row.Field<string>("Ref No") into grp select new { gr = grp.ToList() }; foreach (var item in result) { DataRow d1 = MergeTable.NewRow(); for (int i = 0; i < MergeTable.Columns.Count; i++) { int count; int Numre = 0; string Strre = String.Empty; if (i==0) { var r = item.gr.First(); d1[i] = r[i]; } else { foreach (var dr in item.gr) { if (Int32.TryParse(dr[i].ToString(), out count)) { Numre += count; } else { Strre += dr[i]; } } if (string.IsNullOrEmpty(Strre)) { d1[i] = Numre; } else { d1[i] = Strre; } } } MergeTable.Rows.Add(d1); } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedValue == "Single") { GridView1.DataSource = SingleTable; GridView1.DataBind(); } else if (DropDownList1.SelectedValue == "Merge") { GridView1.DataSource = MergeTable; GridView1.DataBind(); } } }Results:
Best Regards,
Brando/
