SqlDataAdapter da1 = new SqlDataAdapter("select * from menu_cat where res_id=" + Context.Request.QueryString["id"], con);
da1.Fill(ds1, "menu_cat");
cat_dd.DataSource = ds1;
cat_dd.DataTextField = "cat_name";
cat_dd.DataValueField = "cat_id";
cat_dd.DataBind();
now i want to know if above sql does not fetch any record then i want to populate cat_dd dropdown box as "select" value only. but bellow code does not working.
if (cat_dd.Selectedvalue == null)
{
// cat_dd.DataTextField = "Select....";
}
Loading
Blocked AccountPosted Feb 2, 2009, 2:11 AM
Hi,
If sql server doesn't fetch any record. then do like that.
if (object.Equals(ds1, null))
{
ListItem li = new ListItem();
li.Text = "Select";
li.Value = "0";
cat_dd.Items.Insert(0, li);
}
puskar majiPosted Feb 2, 2009, 4:09 AM