hi all ;
i have a DDl (DropDownList3) in my page C# web application
and i write this code
ListItem li = new ListItem("-- select all --", "0");
DropDownList3.Items.Insert(0, li);
and i fill it with sqldatasource (Group_name,Group_Id)
dispaly text = Group_name (Varchar in DB)
value=Group_Id (Int in DB)
now when i write a SQL Qury to select a data based on DDL selectd value ex:
select * from Groups where Group_Id = DropDownList3.SelectedValue
if i choose any item its work (Excpe Select All )
Becuse there is no group_id (0)
Question Now :
how to select All Groups If i choose --Select All )