Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
I had a dropdown bind which always selects the first value from the bound data, how to set the first value as "null value" can any 1 helps me
 
  void dropdown_bind()
    {
 
        adp = new SqlDataAdapter("sp_dropdownbind", con);
        adp.SelectCommand.CommandType = CommandType.StoredProcedure;
        ds = new DataSet();
        adp.Fill(ds);
 
        ddlTypeid.DataTextField = "Name";
        ddlTypeid.DataSource = ds.Tables[0];
        ddlTypeid.DataBind();
 
        ddlproductid.DataTextField = "ProductName";
        ddlproductid.DataSource = ds.Tables[1];
        ddlproductid.DataBind();
 
       
    }
Posted 12-Jul-13 1:02am
Edited 12-Jul-13 1:23am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

<asp:dropdownlist id="DropDownList2" runat="server" appenddatabounditems="true" xmlns:asp="#unknown">
 
<asp:listitem selected="True" text="" value=""></asp:listitem>
 
</asp:dropdownlist>
  Permalink  
Comments
kesav prakash at 12-Jul-13 6:28am
   
Thank u sushil i got the Right one
Sushil Mate at 12-Jul-13 6:28am
   
your welcome
kesav prakash at 12-Jul-13 7:05am
   
i posted the new question name
how to set the NULL value while insertion when DB datatype is integer
kindly answer for that

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 6,803
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,421
3 Manas Bhardwaj 4,841
4 Maciej Los 4,330


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 12 Jul 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100