protected void Page_Load(object sender, EventArgs e) { string userId = Session["ID"].ToString(); try { IPCSystem_DBLayer.PoliceOfficer pObj = new IPCSystem_DBLayer.PoliceOfficer(); pObj.UserId = Session["ID"].ToString(); SqlDataReader sqlDataRrP = pObj.getPData(pObj); while (sqlDataRrP.Read()) { lblUserID.Text = sqlDataRrP["Name"].ToString().Trim(); lblCity.Text = sqlDataRrP["cityInCharged"].ToString(); } SqlConnection sqlcon = new SqlConnection("Data Source=AMRA-PC;Initial Catalog=IPCSystemDB;Integrated Security=true"); SqlDataAdapter sqladap = new SqlDataAdapter("SELECT userId as [Operator ID], PedestrianStation as [Pedestrian Station], PStatus as [Status] FROM Administrator where city='" + lblCity.Text + "'", sqlcon); DataSet dset = new DataSet(); sqladap.Fill(dset, "Administrator"); GridViewStatus.DataSource = dset.Tables["Administrator"].DefaultView; GridViewStatus.DataBind(); } catch (Exception ee) { ErrorLogging.LogError(ee, ""); Response.Redirect("Error.aspx", false); Context.ApplicationInstance.CompleteRequest(); } }
protected void btnRefresh_Click(object sender, EventArgs e) { GridViewStatus.DataBind(); Response.Redirect(Request.RawUrl); }