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(); }