SCRREN SHORT

s.gif

CODE

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class gallry : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fillgrid();
fil();

}
}

protected void fillgrid()
{

DataTable dt = dataaccess.Returndata("select * from apkisakhi_category where status='1' order by category asc"
;

ddlcategory.DataSource = dt;
ddlcategory.DataTextField = dt.Columns["category"].ToString();
ddlcategory.DataValueField = dt.Columns["cat_code"].ToString();
ddlcategory.DataBind();

}
protected void ddlcategory_SelectedIndexChanged(object sender, EventArgs e)
{
try
 {
DataTable dt = dataaccess.Returndata("select * from apkisakhi_category where category='" +
ddlcategory.SelectedItem.Text + "'");

if (dt.Rows.Count != 0)
{
DataList1.Visible = true;
DataTable dt1 = dataaccess.Returndata("select * from apkisakhi_meta where cat_code='" +
ddlcategory.SelectedValue.ToString() + "'");
if (dt1.Rows.Count > 0)
{
Session["title"] = dt1.Rows[0]["title"].ToString();
ss.InnerText = Session["title"].ToString();
}
fil();

}
else
 {
Response.Write("<script>alert('choose one category')</script>");
DataList1.Visible = false;

lblcat.Text = "";
}
}
catch (Exception)
{
Response.Write("<script>alert('Error')</script>");
}

}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{


}
public int currentpage
{
get
 {
object o=this.ViewState["_c"];
if(o==null)
return 0;
else
 return(int)o;
}
set
 {
this.ViewState["_c"]=value;
}
}
private void fil()
{

DataTable dt1 = dataaccess.Returndata("select * from apkisakhi_category where category='" + ddlcategory.SelectedItem.Text + "'");
Session["cat"] = dt1.Rows[0]["cat_code"].ToString();
lblcat.Text = dt1.Rows[0]["category"].ToString();
DataTable dt = dataaccess.Returndata("select * from apkisakhi_addjellewery where status='1' and cat_code='" + Session["cat"] + "' order by j_code asc ");
PagedDataSource p = new PagedDataSource();
p.DataSource = dt.DefaultView;
p.AllowPaging = true;
p.PageSize = 15;
p.CurrentPageIndex = currentpage;
lblpage.Text="Page: "+" "+(currentpage+1).ToString()+" "+" of "+p.PageCount.ToString();
prev.Enabled = !p.IsFirstPage;
next.Enabled = !p.IsLastPage;
DataList1.DataSource = p;
DataList1.DataBind();
}

protected void prev_Click(object sender, EventArgs e)
{
currentpage -= 1;
fil();
}
protected void next_Click(object sender, EventArgs e)
{
currentpage += 1;
fil();

}
}