protected void ButtonCli_Click(object sender, EventArgs e)
{
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select user_id, first_name, last_name, city, province, gender, age, status from clientaccepted";
cmd.ExecuteNonQuery();
DataTable dtt = new DataTable();
MySqlDataAdapter daa = new MySqlDataAdapter(cmd);
daa.Fill(dtt);
GridViewCli.DataSource = dtt;
GridViewCli.DataBind();
conn.Close();
}
protected void sortDSC_Click(object sender, EventArgs e)
{
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select user_id,first_name,last_name,username, gender, age, email from client where gender='female'";
cmd.ExecuteNonQuery();
DataTable dtt = new DataTable();
MySqlDataAdapter daa = new MySqlDataAdapter(cmd);
daa.Fill(dtt);
GridViewCli.DataSource = dtt;
GridViewCli.DataBind();
conn.Close();
}