private void GetInquiryData()
{
string jk = "select * from inquiry ORDER BY InquiryDate DESC";
DataSet ds = new DataSet();
ds = dc.getdata(jk);
DataTable dt = ds.Tables[0];
PagedDataSource pgitems = new PagedDataSource();
pgitems.DataSource = dt.DefaultView;
pgitems.AllowPaging = true;
//Control page size from here
pgitems.PageSize = 8;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= pgitems.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
//Finally, set the datasource of the repeater
InquiryRptr.DataSource = pgitems;
InquiryRptr.DataBind();
//GalleryRptr.DataSource = ds;
//GalleryRptr.DataBind();
}
private void GetInquiryData()
{
string jk = "select admissionform.id,admissionform.RegistarionDate,admissionform.FName,admissionform.MName,admissionform.LName,admissionform.Gender,admissionform.State,admissionform.StudenMobile,admissionform.EmailId,admissionform.IsAnswered,admissioncategory.Category from admissionform join admissioncategory on admissionform.AdmissionInId = admissioncategory.id";
DataSet ds = new DataSet();
ds = dc.getdata(jk);
DataTable dt = ds.Tables[0];
PagedDataSource pgitems = new PagedDataSource();
pgitems.DataSource = dt.DefaultView;
pgitems.AllowPaging = true;
//Control page size from here
pgitems.PageSize = 8;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= pgitems.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
//Finally, set the datasource of the repeater
InquiryRptr.DataSource = pgitems;
InquiryRptr.DataBind();
//GalleryRptr.DataSource = ds;
//GalleryRptr.DataBind();
}
protected void SearchBtn_Click(object sender, EventArgs e)
{
if (DateTb.Text != "")
{
DateTime sDt = Convert.ToDateTime(DateTb.Text);
string zk = "select * from inquiry where InquiryDate='" + sDt.ToShortDateString() + "'";
DataSet ds2 = new DataSet();
ds2 = dc.getdata(zk);
DataTable dt = ds2.Tables[0];
PagedDataSource pgitems = new PagedDataSource();
pgitems.DataSource = dt.DefaultView;
pgitems.AllowPaging = true;
//Control page size from here
pgitems.PageSize = 8;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= pgitems.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
//Finally, set the datasource of the repeater
InquiryRptr.DataSource = pgitems;
InquiryRptr.DataBind();
}
}
protected void SearchBtn_Click(object sender, EventArgs e)
{
if (AdmissionDD.SelectedIndex != 0)
{
//DateTime sDt = Convert.ToDateTime(DateTb.Text);
string zk = "select admissionform.id,admissionform.FName,admissionform.MName,admissionform.LName,admissionform.RegistarionDate,admissionform.Gender,admissionform.State,admissionform.StudenMobile,admissionform.EmailId,admissionform.IsAnswered,admissioncategory.Category from admissionform join admissioncategory on admissionform.AdmissionInId = admissioncategory.id where admissionform.AdmissionInId='" + AdmissionDD.SelectedValue + "'";
DataSet ds2 = new DataSet();
ds2 = dc.getdata(zk);
DataTable dt = ds2.Tables[0];
PagedDataSource pgitems = new PagedDataSource();
pgitems.DataSource = dt.DefaultView;
pgitems.AllowPaging = true;
//Control page size from here
pgitems.PageSize = 8;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPaging.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i <= pgitems.PageCount - 1; i++)
{
pages.Add((i + 1).ToString());
}
rptPaging.DataSource = pages;
rptPaging.DataBind();
}
else
{
rptPaging.Visible = false;
}
//Finally, set the datasource of the repeater
InquiryRptr.DataSource = pgitems;
InquiryRptr.DataBind();
}
}