Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- con = new SqlConnection(conString);
- string sqlstring = string.Empty;
- if (Request.QueryString["Id"] != null)
- {
- btnSave.Visible = false;
- btnUpdate.Visible = true;
- String Wherecluase =Request.QueryString["Id"].ToString();
- if (Wherecluase == "" || Wherecluase == string.Empty)
- {
- sqlstring = "select Id,EmployeeName,MobileNumber,CONVERT(varchar(10),DOB,103) as DOB,[Status] from EmployeeList ";
- }
- else
- {
- sqlstring = "select Id,EmployeeName,MobileNumber,EmailID,CONVERT(varchar(10),DOB,103) as DOB,[Status] from EmployeeList where id = " + Wherecluase ;
- }
- SqlCommand cmd = new SqlCommand(sqlstring, con);
- con.Open();
- SqlDataReader r = cmd.ExecuteReader();
- while (r.Read())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement