hi
i used unorderlist menu in my index.aspx
index.aspx
<li class="current">
<a href="house.aspx?H_name=all">furniture</a>
<ul>
<li>
<a href="house.aspx?H_name=sofa">sofa</a>
</li>
<li class="current">
<a "href="house.aspx?H_name=table"">table </a>
</li>
<li>
when users click on each of item it go to House.aspx page and accordin to H_name value it bind data in House.aspx page
House.aspx
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 in index.aspx i use repeater to bind my menu item from database
<li class="current">
<a href=House.aspx?H_name=all">Furniture</a>
<ul>
<asp:Repeater ID="rptMenu" runat="server">
<ItemTemplate>
<li><ahref=House.aspx?H_name=all"><%#Eval("name") %></a> </li>
</ItemTemplate>
</asp:Repeater>
</ul>
</li>
and here i want do like before
here i used repeater so how i can define H_name for my item in datarepeater?that when it go to house.aspx page depending to that H_name it show data before i define h_name one by one for items but here what should i do ?
best regards
