protected void Search_SelectedIndexChanged(object sender, EventArgs e)
{
ddlKeyWord.Items.Clear();
ddlKeyWord.Items.Insert(0, new ListItem("SELECT ", ""));
if (ddlSearch.SelectedItem.Text == "Country") //Country
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Country ORDER BY Country ASC";
ddlKeyWord.DataTextField = "Country";
ddlKeyWord.DataValueField = "CountryID";
}
else if (ddlSearch.SelectedItem.Text == "Course") //Course
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Course ORDER BY CourseDescription ASC";
ddlKeyWord.DataTextField = "CourseDescription";
ddlKeyWord.DataValueField = "CourseID";
}
else if (ddlSearch.SelectedItem.Text == "University") //University
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Institution ORDER BY Institution ASC";
ddlKeyWord.DataTextField = "Institution";
ddlKeyWord.DataValueField = "InstitutionID";
}
else if (ddlSearch.SelectedItem.Text == "Batch") //Bactch
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Batch ORDER BY Batch ASC";
ddlKeyWord.DataTextField = "Batch";
ddlKeyWord.DataValueField = "BatchID";
}
else if (ddlSearch.SelectedItem.Text == "Intake") //Intake
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Intake ORDER BY Intake ASC";
ddlKeyWord.DataTextField = "Intake";
ddlKeyWord.DataValueField = "IntakeID";
}
else if (ddlSearch.SelectedItem.Text == "Year") //Graduate Year
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Year ORDER BY Year ASC";
ddlKeyWord.DataTextField = "Year";
ddlKeyWord.DataValueField = "YearID";
}
else if (ddlSearch.SelectedItem.Text == "StudentGender") //Gender
{
}
else if (ddlSearch.SelectedItem.Text == "Ethnicity") //Ethnicity
{
sqlDataSourceKeyWord.SelectCommand = "SELECT * FROM Ethnicity ORDER BY Ethnicity ASC";
ddlKeyWord.DataTextField = "Ethnicity";
ddlKeyWord.DataValueField = "EthnicityID";
}
}
As you can see in the coding below, for gender, i want to create dropdownlist for gender,
1)Female
2)Male
in .aspx, i know how to create it, just using <asp:Listitem> but I dont know how to create the list in .cs. Anyone here have any solution?