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