protected void Page_Load(object sender, EventArgs e) { try { if (Session["User_ID"] == null) { Response.Redirect("SessionExpired.aspx", false); } else { SqlConnection con = new SqlConnection(constr.getconstr()); con.Open(); Session["Doc_ID"] = Request.QueryString["Doc_ID"]; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Get_AD"; cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; string doc = Session["Doc_ID"].ToString(); cmd.Parameters.AddWithValue("@Doc_ID", doc); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ad.Fill(ds); Grd_Get_SOP_List.DataSource = ds.Tables[0]; Grd_Get_SOP_List.DataBind(); } } catch (Exception ex) { lblErrorMsg.Text = ""; lblErrorMsg.Text = ex.Message; } }
protected void btn_Get_Doc_List_Click(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection(constr.getconstr()); SqlCommand cmd = new SqlCommand("View_User_TP", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "Approve"); cmd.Parameters.AddWithValue("@User_Name", Drp_User.SelectedValue); cmd.Parameters.AddWithValue("@Dept_Name", Drp_Dept.SelectedValue); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ad.Fill(ds); Grd_Get_SOP_List.DataSource = ds.Tables[0]; Grd_Get_SOP_List.DataBind(); } catch (Exception ex) { lblErrorMsg.Text = ""; lblErrorMsg.Text = ex.Message; } }