Add items to dropdown menu

Oct 28 2006 2:19 AM
There is a dropdownlist where in the items are added dynamically.

However, there is an item "All Messages" that is to be added so that when a user selects "All Messages" from the DropDown List, it will displays all the items along with their information in datagrid.

But if user selects a single item, all that item and its information will be reflected in the datagrid.

My problem, is how can I make "All Messages" appear first in the dropdown list so that the user sees only "All Messages" in the Dropdown list when he views the datagrid and then can select a particular item of his choice later on.

The code I have written is :


SqlConnection conn = new SqlConnection(ConnectionString);

SqlDataAdapter additemsda = new SqlDataAdapter("select Newsletter_Topic from Admin_Add_Newsletter_Topic", conn);

conn.Open();

DataSet additemsds = new DataSet();

additemsda.Fill(additemsds, "Admin_Add_Newsletter_Topic");

DataTable additemsdt = new DataTable();

additemsdt = additemsds.Tables["Admin_Add_Newsletter_Topic"];

DataRow[] additemsdr = new DataRow[additemsdt.Rows.Count];

additemsdr = additemsdt.Select();

ArrayList Article = new ArrayList();

if (additemsdr.Length != 0)

{

Article_Grp = additemsdr[0]["Newsletter_Topic"].ToString();

for (int i = 0; i < additemsdr.Length; i++)

{

Article.Add(additemsdr[i]["Newsletter_Topic"].ToString());

}

ddlType.DataSource = Article;

ddlType.DataBind();

ddlType.Items.Add("All Messages");

}

conn.Close();


Please help


Answers (2)