grouping listview

Accepted answer

SqlCommand cmd = new SqlCommand("select item_Id,item_Name,item_Group,item_Ctgry from productsnrwmtrls where item_Group='"+yourvalue+"'", con);

send yourvalue value from selected group.

anjali khan11y ago

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(1,1) 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 khan11y ago

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 Shahi11y ago

If This is correct the kindly accept the answer.

Upendra Pratap Shahi11y ago

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 khan11y ago

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 Shahi11y ago

Hello ,

Use below code-

Design page-

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ListVieLinkWithDB.aspx.cs" Inherits="ListVieLinkWithDB" %>

DOCTYPE html>

<title>title>

.linkCat {

background-color: aqua;

}

style>

head>

<body>

<div>

<h3>ListViewh3>

<%-- 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">

<tr>

<th>Product

th>

<th>Quantity

th>

<th>Price

th>

<th>Category

th>

tr>

<asp:PlaceHolder runat="server" ID="groupPlaceHolder1">asp:PlaceHolder>

<tr>

<asp:DataPager ID="DataPager1" runat="server" PagedControlID="lvCustomers" PageSize="2">

<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>

<tr>

<asp:PlaceHolder runat="server" ID="itemPlaceHolder1">asp:PlaceHolder>

tr>

GroupTemplate>

<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 ProductName,Qty,Price,CategoryId 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 khan11y ago

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

Upendra Pratap Shahi11y ago

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 khan11y ago

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 khan11y ago

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 Shahi11y ago

What problem you have face in this.

kindly share with us .

anjali khan11y ago

hi

pl chk...

ListView

<%--LinkButton--%>

Text="Group1" OnClick="ENameLinkBtn_Click"CommandArgument="Group1">

<%--

Text="Group2"OnClick="ENameLinkBtn_Click"CommandArgument="Group2">--%>

<%--

Text="Group3" OnClick="ENameLinkBtn_Click" CommandArgument="Group3">--%>

Text="ShowAllData" OnClick="ENameLinkBtn_Click"CommandArgument="ShowAllData">

ItemPlaceholderID="itemPlaceHolder1">

<%--

--%>

item_Id	item_Name	item_Group	item_Ctgry
ShowNextPageButton="false" /> ShowPreviousPageButton="false" />

item_Id

item_Name

item_Group

item_Ctgry

ShowNextPageButton="false" />

ShowPreviousPageButton="false" />

<%# Eval("item_Id")%>

<%# Eval("item_Name")%>

<%# Eval("item_Group")%>

<%# Eval("item_Ctgry")%>>

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_Id,item_Name,item_Group,item_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 Shahi11y ago

Where is your attachment dear?

anjali khan11y ago

hi Upendra,

please find the attached file...

Upendra Pratap Shahi11y ago

Where is your design page and its snap shot?

anjali khan11y ago

hi thanks for give the idea...but I cant be able to do...

ListView

<%--LinkButton--%> <%----%> <%----%>
<%----%>

item_Id	item_Name	item_Group	item_Ctgry

<%# Eval("item_Id")%> <%# Eval("item_Name")%> <%# Eval("item_Group")%> <%# Eval("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_Id,item_Name,item_Group,item_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 khan11y ago

hi thanks for give the idea...but I cant be able to do...

ListView

<%--LinkButton--%> <%----%> <%----%>
<%----%>

item_Id	item_Name	item_Group	item_Ctgry

<%# Eval("item_Id")%> <%# Eval("item_Name")%> <%# Eval("item_Group")%> <%# Eval("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_Id,item_Name,item_Group,item_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 Shahi11y ago

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 khan11y ago

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

Raja T11y ago

Hi Anjali,

Try this code

ASPX

-------------

ListView

ItemPlaceholderID="itemPlaceHolder1">

item_Id	item_Name	item_Group	item_Ctgry

<%# Eval("item_Id")%>

<%# Eval("item_Name")%>

<%# Eval("item_Group")%>

<%# Eval("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(strqry,con);

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 khan11y ago

I did like the below dta.. Design page

item_Id	item_Name	item_Group	item_Ctgry

<%# Eval("item_Id")%> <%# Eval("item_Name")%> <%# Eval("item_Group")%> 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_Id,item_Name,item_Group,item_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 khan11y ago

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 Shahi11y ago

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

anjali khan11y ago

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

Upendra Pratap Shahi11y ago

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/