protected void status_SelectedIndexChanged(object sender, EventArgs e) { if (status.SelectedItem.Value == "Approve") { Approve.Visible = false; Reject.Visible = false; con.Open(); SqlCommand cmd = new SqlCommand("Select ApplicationID,(FirstName + LastName) as Name,Email,Phone,AptType,Rent,Status from UserDetails,Application where UserDetails.userId = Application.userId and Application.Status = 'Approve' ;", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); Pending.DataSource = dt; Pending.DataBind(); con.Close(); } else if (status.SelectedItem.Value == "Pending") { con.Open(); SqlCommand cmd = new SqlCommand("Select ApplicationID,(FirstName + LastName) as Name,Email,Phone,AptType,Rent,Status from UserDetails,Application where UserDetails.userId = Application.userId and Application.Status = 'Pending' ;", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); Pending.DataSource = dt; Pending.DataBind(); con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { con.Open(); SqlCommand cmd = new SqlCommand("Select ApplicationID,(FirstName + LastName) as Name,Email,Phone,AptType,Rent,Status from UserDetails,Application where UserDetails.userId = Application.userId and Application.Status = 'Pending' ;", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); Pending.DataSource = dt; Pending.DataBind(); con.Close(); } }