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 Peter Leow 293
1 Kornfeld Eliyahu Peter 220
2 Sergey Alexandrovich Kryukov 162
3 Maciej Los 160
4 OriginalGriff 153
0 OriginalGriff 383
1 Peter Leow 318
2 Kornfeld Eliyahu Peter 260
3 Maciej Los 230
4 Sergey Alexandrovich Kryukov 212


Advertise | Privacy | Mobile
Web04 | 2.8.150301.1 | Last Updated 12 Jul 2013
Copyright © CodeProject, 1999-2015
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