hi
i have 2 page
1-index.aspx
2-House.aspx
and these are my table in database
1-House_menu Table
|
Id
|
Name
|
H_name
|
|
1
|
Sofa
|
Furniture
|
|
2
|
Table
|
Furniture
|
|
3
|
Iron
|
Electric
|
|
4
|
Vaccume cleaner
|
Electric
|
2-House_p Table that save users product information
|
Id
|
Name
|
H_name
|
Subset
|
description
|
|
1
|
Couch
|
Furniture
|
House furniture
|
Test1
|
|
2
|
Armchair
|
Furniture
|
House furniture
|
Test2
|
|
3
|
Blender
|
Electric
|
Kitchen
|
Test3
|
|
4
|
Oven
|
Electric
|
Kitchen
|
Test4
|
i have 1 unorderlist menu in index.aspx
and 1 unorderlist in House.aspx page
i bind unorderlist from database
1-index.aspx
Bind repeater from House_menu Table
<li class="current">
<a href="House.aspx?H_name=all">Furniture</a>
<ul>
<asp:Repeater ID="rptMenu" runat="server">
<ItemTemplate>
<li><a href="Houseaspx?H_name=<%#Eval("H_name") %>"><%#Eval("name") %></a> </li>
</ItemTemplate>
</asp:Repeater>
</ul>
</li>
and in House.aspx page i bind repeater from HOuse_p table subset column
<ul>
<asp:Repeater ID="rptMenuE" runat="server">
<ItemTemplate>
<li><a href="House.aspx?subset=<%#Eval("subset") %>">
<%#Eval("Subset") %></a> </li>
</ItemTemplate>
</asp:Repeater>
</ul>
when users click on menu item in index.aspx menu it go to house.aspx and bind datalist according to H_name column from House_p table
this is code
private void GetCustomersPageWise(int pageIndex)
{
{
if (Request.QueryString["H_name"] != "all")
{
using (SqlCommand cmd = new SqlCommand("GetCustomersPageWise1", _cn))
{
string BehCode = Request.QueryString["H_name"];
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@H_name", BehCode);
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", PageSize);
cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
_cn.Open();
IDataReader idr = cmd.ExecuteReader();
DataList1.DataSource = idr;
DataList1.DataBind();
idr.Close();
_cn.Close();
int recordCount = Convert.ToInt32(cmd.Parameters["@RecordCount"].Value);
this.PopulatePager(recordCount, pageIndex);
}
}
else
{
using (SqlCommand cmd = new SqlCommand("GetCustomersPageWise", _cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", PageSize);
cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4);
cmd.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
_cn.Open();
IDataReader idr = cmd.ExecuteReader();
DataList1.DataSource = idr;
DataList1.DataBind();
idr.Close();
_cn.Close();
int recordCount = Convert.ToInt32(cmd.Parameters["@RecordCount"].Value);
this.PopulatePager(recordCount, pageIndex);
}
}
}
now i want when users click on menu item in House.aspx page it bind datalist from House_p table according to Subset column
how i can do it ?
best regards
