protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
else
{
maikal mk = new maikal();
int lvl = mk.returnlevel(Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"])), Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])));
}
if (!IsPostBack)
{
txtName.Focus();
txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
lblGridTitle.Text = " Today Visitor List ";
SqlDataAdapter ad = new SqlDataAdapter("select Name,Phone,Mobile,Email,Reason,Detail from Reception where Date='" + DateTime.Now.Date + "' ORDER BY SN DESC", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GrvVisitorview.DataSource = ds;
GrvVisitorview.DataBind();
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
public void grid()
{
SqlDataAdapter ad = new SqlDataAdapter("select Name,Phone,Mobile,Email,Reason,Detail from Reception where Date='" + DateTime.Now.Date + "' ORDER BY SN DESC", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GrvVisitorview.DataSource = ds;
GrvVisitorview.DataBind();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grid();
GrvVisitorview.PageIndex = e.NewPageIndex;
GrvVisitorview.DataBind();
}
