grouping listview

Question

i have a listview..in that i m display the data from the data base..now i want to make a group with listview..

suppose i created a group 1,group2

so if i click in group1 so hole data should be display..this thing i did..
now i want to do next task on the below statement.

[[database- i have 4 column like item_Id,item_Name,item_Group,item_Ctgry
in this item category like a,b, c ...

see if i click on group2 so that in item_category data should be filter...

Upendra Pratap Shahi · Answer

SqlCommand cmd = new SqlCommand ( select item_Iditem_Nameitem_Groupitem_Ctgry from productsnrwmtrls where item_Group=' +yourvalue+ '  con); send yourvalue value from selected group.

anjali khan · Answer

USE [Sales_Purchase1] GO /****** Object: Table [dbo].[productsnrwmtrls] Script Date: 07/22/2015 17:44:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[productsnrwmtrls]( [item_Id] [int] IDENTITY(11) NOT NULL [item_Name] [nvarchar](100) NOT NULL [item_Group] [nvarchar](20) NULL [item_Ctgry] [nvarchar](1) NOT NULL CONSTRAINT [PK_productsnrwmtrls] PRIMARY KEY CLUSTERED ( [item_Id] ASC )WITH (PAD_INDEX = OFF STATISTICS_NORECOMPUTE = OFF IGNORE_DUP_KEY = OFF ALLOW_ROW_LOCKS = ON ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Cnvrsnfctr] DEFAULT ((1)) FOR [item_Cnvrsnfctr] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Cprice] DEFAULT ((0)) FOR [item_Cprice] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Sprice] DEFAULT ((0)) FOR [item_Sprice] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_Table_1_item_Avlblstck] DEFAULT ((0)) FOR [item_Stckavlbl] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Stckonordr] DEFAULT ((0)) FOR [item_Stckonordr] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Stcknproc] DEFAULT ((0)) FOR [item_Stcknproc] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Lstslno] DEFAULT ((0)) FOR [item_Lstslno] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Stat] DEFAULT (N'A') FOR [item_Stat] GO ALTER TABLE [dbo].[productsnrwmtrls] ADD CONSTRAINT [DF_productsnrwmtrls_item_Stmp] DEFAULT (getdate()) FOR [item_Stmp] GO

anjali khan · Answer

table structure item_Id int Unchecked item_Name nvarchar(100) Unchecked item_Group nvarchar(20) Checked item_Ctgry nvarchar(1) Unchecked table item_id item_Name item_Group item_Ctgry 1 PETA HB chair P 2 Stem- 7 frame R 3 product B 4 Foam B 5 product R 6 Base P 7 Base R

Upendra Pratap Shahi · Answer

If This is correct the kindly accept the answer .

Upendra Pratap Shahi · Answer

Bind according to your database because I've bind with my script so it'may not worked in your DB. Share your table script with data.

anjali khan · Answer

hi this is correct but it is not working... see in category column data is display like a a a a b b c c a c b like this so wants to be filter..

Upendra Pratap Shahi · Answer

Hello  Use below code- Design page- @ Page Language =C# AutoEventWireup =true CodeFile =ListVieLinkWithDB.aspx.cs Inherits =ListVieLinkWithDB %> DOCTYPE html > html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > title > style type =text/css> .linkCat { background-color : aqua ; } style > head > body > form id =form1 runat =server> div > h3 > ListView h3 > -- Linkbutton -- %> asp : LinkButton ID =lnkCat1 CssClass =linkCat runat =server ClientIDMode =Static Text =Cat1 OnClick =ENameLinkBtn_Click CommandArgument =Cat1> asp : LinkButton > asp : LinkButton ID =lnkCat2 CssClass =linkCat runat =server ClientIDMode =Static Text =Cat2 OnClick =ENameLinkBtn_Click CommandArgument =Cat2> asp : LinkButton > asp : LinkButton ID =lnkDefault CssClass =linkCat runat =server ClientIDMode =Static Text =Default OnClick =ENameLinkBtn_Click CommandArgument =Cat2> asp : LinkButton > asp : HiddenField ID =hdnText runat =server ClientIDMode =Static Value = /> -- end -- %> asp : ListView ID =lvCustomers runat =server GroupPlaceholderID =groupPlaceHolder1 ItemPlaceholderID =itemPlaceHolder1 OnPagePropertiesChanging =OnPagePropertiesChanging> LayoutTemplate > table border =1> tr > th > Product th > th > Quantity th > th > Price th > th > Category th > tr > asp : PlaceHolder runat =server ID =groupPlaceHolder1> asp : PlaceHolder > tr > td colspan =3> asp : DataPager ID =DataPager1 runat =server PagedControlID =lvCustomers PageSize =2> Fields > asp : NextPreviousPagerField ButtonType =Link ShowFirstPageButton =false ShowPreviousPageButton =true ShowNextPageButton =false /> asp : NumericPagerField ButtonType =Link /> asp : NextPreviousPagerField ButtonType =Link ShowNextPageButton =true ShowLastPageButton =false ShowPreviousPageButton =false /> Fields > asp : DataPager > td > tr > table > LayoutTemplate > GroupTemplate > tr > asp : PlaceHolder runat =server ID =itemPlaceHolder1> asp : PlaceHolder > tr > GroupTemplate > ItemTemplate > td > # Eval( ProductName ) %> td > td > # Eval( Qty ) %> td > td > # Eval( Price ) %> td > td > # Eval( CategoryId ) %> td > ItemTemplate > asp : ListView > div > form > body > html > Code behind page- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Configuration; public partial class ListVieLinkWithDB : System.Web.UI. Page { string connStr = ConfigurationManager .ConnectionStrings[ DefaultConnection ].ConnectionString; protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { ListViewControlBind(  ); } } protected void ListViewControlBind( string sGroup) { if (sGroup == Cat1 ) sGroup = 1 ; if (sGroup == Cat2 ) sGroup = 2 ; else sGroup =  ; SqlConnection con = new SqlConnection (connStr); con.Open(); string sQry = @select ProductNameQtyPriceCategoryId from dbo.Product ; SqlCommand cmd = new SqlCommand (sQry con); SqlDataAdapter da = new SqlDataAdapter (cmd); DataTable dt = new DataTable (); DataSet ds = new DataSet (); da.Fill(dt); con.Close(); //lvCustomers.DataSource = dt; //lvCustomers.DataBind(); ds.Tables.Add(dt); if (sGroup !=  ) { var dv = ds.Tables[0].DefaultView; dv.RowFilter = CategoryId=' + sGroup + ' ; DataSet ds1 = new DataSet (); var newdt = dv.ToTable(); ds1.Tables.Add(newdt); //bind data to data controls lvCustomers.DataSource = ds1.Tables[0]; lvCustomers.DataBind(); } else { lvCustomers.DataSource = ds.Tables[0]; lvCustomers.DataBind(); } } //paging code protected void OnPagePropertiesChanging( object sender PagePropertiesChangingEventArgs e) { (lvCustomers.FindControl( DataPager1 ) as DataPager ).SetPageProperties(e.StartRowIndex e.MaximumRows false ); if (hdnText.Value !=  ) { string yourValue = hdnText.Value.ToString(); if (yourValue == Default ) { ListViewControlBind(  ); } else { this .ListViewControlBind(yourValue); } } else { this .ListViewControlBind(  ); } } protected void ENameLinkBtn_Click( object sender EventArgs e) { LinkButton btn = ( LinkButton )(sender); string yourValue = btn.CommandArgument; // do what you need here if (yourValue == Default ) { hdnText.Value = yourValue; ListViewControlBind(  ); } else { hdnText.Value = yourValue; ListViewControlBind(yourValue); } } } this may helped you.

anjali khan · Answer

yes..i did same thing...but it is not working...

Upendra Pratap Shahi · Answer

You want to filter according to item_category or item group. If you want to filter with item group then use if(sGroup == ) { vardv = dt.DefaultView; dv.RowFilter =  item_Group =' + sGroup + '; //bind data to data controls lvCustomers.DataSource = dt; lvCustomers.DataBind(); } else { lvCustomers.DataSource = dt; lvCustomers.DataBind(); } because you send from hidden field as group name so try to filter on group. Try this  may it helped you. if helped accept this.

anjali khan · Answer

see in this it is working properly... but if I click on group1 and 2 any thing so filter data should be display from the item_caegory... in that column some field like a  b c so how to should be filter....

anjali khan · Answer

see in this it is working properly... but if I click on group1 and 2 any thing so filter data should be display from the item_caegory... in that column some field like a  b c so how to should be filter....

Upendra Pratap Shahi · Answer

What problem you have face in this. kindly share with us .

anjali khan · Answer

hi pl chk... ListView Text=Group1 OnClick=ENameLinkBtn_ClickCommandArgument=Group1> Text=Group2OnClick=ENameLinkBtn_ClickCommandArgument=Group2> --%> Text=Group3 OnClick=ENameLinkBtn_Click CommandArgument=Group3> --%> Text=ShowAllData OnClick=ENameLinkBtn_ClickCommandArgument=ShowAllData> ItemPlaceholderID=itemPlaceHolder1> item_Id item_Name item_Group item_Ctgry ShowNextPageButton=false /> ShowPreviousPageButton=false /> --%> > protected void Page_Load(object sender EventArgs e) { if(!IsPostBack) { BindListView(); } } protectedvoid BindListView(string sGroup) { DataSetds = new DataSet(); SqlConnection con = new SqlConnection(Data Source =CENSYS08\SQLSERVER2008R2;Initial Catalog=Sales_Purchase1;IntegratedSecurity=True); con.Open(); SqlCommand cmd = new SqlCommand(select item_Iditem_Nameitem_Groupitem_Ctgryfrom productsnrwmtrls con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); if(sGroup == ) { vardv = dt.DefaultView; dv.RowFilter = item_Ctgry=' + sGroup + '; //bind data to data controls lvCustomers.DataSource = dt; lvCustomers.DataBind(); } else { lvCustomers.DataSource = dt; lvCustomers.DataBind(); } } protectedvoid ENameLinkBtn_Click(object sender EventArgs e) { LinkButtonbtn = (LinkButton)(sender); stringyourValue = btn.CommandArgument; if(yourValue == Group1) { hdnText.Value = yourValue; BindListView(); } else { hdnText.Value = yourValue; BindListView(yourValue); }

Upendra Pratap Shahi · Answer

Where is your attachment dear?

anjali khan · Answer

hi Upendra please find the attached file...

Upendra Pratap Shahi · Answer

Where is your design page and its snap shot?

anjali khan · Answer

hi thanks for give the idea...but I cant be able to do... ListView --%> --%> item_Id item_Name item_Group item_Ctgry --%> > protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { BindListView(); } } protected void BindListView(string sGroup) { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(Data Source = CENSYS08\SQLSERVER2008R2;Initial Catalog=Sales_Purchase1;Integrated Security=True); con.Open(); SqlCommand cmd = new SqlCommand(select item_Iditem_Nameitem_Groupitem_Ctgry from productsnrwmtrls con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); if (sGroup == ) { var dv = dt.DefaultView; dv.RowFilter = item_Ctgry=' + sGroup + '; // bind data to data controls lvCustomers.DataSource = dt; lvCustomers.DataBind(); } else { lvCustomers.DataSource = dt; lvCustomers.DataBind(); } } protected void ENameLinkBtn_Click(object sender EventArgs e) { LinkButton btn = (LinkButton)(sender); string yourValue = btn.CommandArgument; if (yourValue == Group1) { hdnText.Value = yourValue; BindListView(); } else { hdnText.Value = yourValue; BindListView(yourValue); }

anjali khan · Answer

hi thanks for give the idea...but I cant be able to do... ListView --%> --%> item_Id item_Name item_Group item_Ctgry --%> > protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { BindListView(); } } protected void BindListView(string sGroup) { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(Data Source = CENSYS08\SQLSERVER2008R2;Initial Catalog=Sales_Purchase1;Integrated Security=True); con.Open(); SqlCommand cmd = new SqlCommand(select item_Iditem_Nameitem_Groupitem_Ctgry from productsnrwmtrls con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); if (sGroup == ) { var dv = dt.DefaultView; dv.RowFilter = item_Ctgry=' + sGroup + '; // bind data to data controls lvCustomers.DataSource = dt; lvCustomers.DataBind(); } else { lvCustomers.DataSource = dt; lvCustomers.DataBind(); } } protected void ENameLinkBtn_Click(object sender EventArgs e) { LinkButton btn = (LinkButton)(sender); string yourValue = btn.CommandArgument; if (yourValue == Group1) { hdnText.Value = yourValue; BindListView(); } else { hdnText.Value = yourValue; BindListView(yourValue); }

Upendra Pratap Shahi · Answer

Thanks anjali khan for appreciation and use link button text for this or put link button value in hidden field and do your work according to your need as per in my article.

anjali khan · Answer

this is correct...thank a lot... but i dont want be use ddl... i want to be used like linkbutten

Raja T · Answer

Hi Anjali Try this code ASPX ------------- ListView ItemPlaceholderID=itemPlaceHolder1> item_Id item_Name item_Group item_Ctgry .CS ---- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; namespace TestDemo { public partial class listview_db : System.Web.UI.Page { SqlConnection con = new SqlConnection(Data Source=test;Initial Catalog=TestDemo;User Id=sa;Password=passwd@123;); protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { LoadDropdown(); } } private void LoadDropdown() { try { string strqry = ; strqry = select distinct item_Ctgry from tbl_itm_category; DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(strqrycon); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); ddlGroup.DataTextField = item_Ctgry; ddlGroup.DataValueField = item_Ctgry; ddlGroup.DataSource = dr; ddlGroup.DataBind(); string temp = string.Empty; temp = -- Select --; ListItem objlstItem = new ListItem(temp ); ddlGroup.Items.Insert(0 objlstItem); } catch (Exception ex) { throw (ex); //Response.Redirect(Default.aspx); } } private void BindListView(string val) { //throw new NotImplementedException(); string query = ; if (val == -- Select --) { query = select * from tbl_itm_category; } else { query = select * from tbl_itm_category where item_Ctgry=' + val + '; } SqlDataAdapter da = new SqlDataAdapter(query con); DataSet ds = new DataSet(); da.Fill(ds Table1); lvCustomers.DataSource = ds.Tables[0]; lvCustomers.DataBind(); } protected void ddlGroup_SelectedIndexChanged(object sender EventArgs e) { string val1 = ddlGroup.SelectedItem.Text.ToString(); if (val1 != ) { BindListView(val1); } } } } Db script ---------- CREATE TABLE [dbo].[tbl_itm_category]( [item_Id] [int] NULL [item_Name] [varchar](50) NULL [item_Group] [varchar](50) NULL [item_Ctgry] [varchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO INSERT [dbo].[tbl_itm_category] ([item_Id] [item_Name] [item_Group] [item_Ctgry]) VALUES (1001 N'Red' N'C' N'Color') INSERT [dbo].[tbl_itm_category] ([item_Id] [item_Name] [item_Group] [item_Ctgry]) VALUES (1002 N'Blue' N'B' N'Color') INSERT [dbo].[tbl_itm_category] ([item_Id] [item_Name] [item_Group] [item_Ctgry]) VALUES (1003 N'Yellow' N'G' N'Color') INSERT [dbo].[tbl_itm_category] ([item_Id] [item_Name] [item_Group] [item_Ctgry]) VALUES (1004 N'DDD' N'A' N'Cat2') INSERT [dbo].[tbl_itm_category] ([item_Id] [item_Name] [item_Group] [item_Ctgry]) VALUES (1005 N'EEE' N'K' N'Cat2') INSERT [dbo].[tbl_itm_category] ([item_Id] [item_Name] [item_Group] [item_Ctgry]) VALUES (1006 N'FFF' N'L' N'Cat3')

anjali khan · Answer

I did like the below dta.. Design page item_Id item_Name item_Group item_Ctgry item_Ctgry Cs page… protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { BindListView(); } } protected void BindListView(string sGroup) { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(Data Source = CENSYS08\SQLSERVER2008R2;Initial Catalog=Sales_Purchase1;Integrated Security=True); con.Open(); SqlCommand cmd = new SqlCommand(select item_Iditem_Nameitem_Groupitem_Ctgry from productsnrwmtrls con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); con.Close(); if (sGroup == ) //if (sGroup != ) { var dv = dt.DefaultView; dv.RowFilter = item_Ctgry=' + sGroup + '; // bind data to data controls lvCustomers.DataSource = dt; lvCustomers.DataBind(); } else { lvCustomers.DataSource = dt; lvCustomers.DataBind(); } } protected void ENameLinkBtn_Click(object sender EventArgs e) { LinkButton btn = (LinkButton)(sender); string yourValue = btn.CommandArgument; if (yourValue == ShowAllData) { hdnText.Value = yourValue; BindListView(); } else { hdnText.Value = yourValue; BindListView(yourValue); } } } }

anjali khan · Answer

hi I did this thing and it is showing the data...but I want to filter the records but how I don't know...

Upendra Pratap Shahi · Answer

You can bind with database and filter as per given in article or from your query.

anjali khan · Answer

hi upendra this is correct but it is used by without database...but I want to use sql database....

Upendra Pratap Shahi · Answer

Hello anjali khan  Kindly go through below link it may helped you to understand the concept- http://www.c-sharpcorner.com/UploadFile/77a82c/bind-listview-without-database-on-linkbutton-click/