Click here to Skip to main content
11,412,833 members (75,645 online)
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 399
1 Sascha Lefévre 200
2 Maciej Los 180
3 ProgramFOX 130
4 Sergey Alexandrovich Kryukov 110
0 Sergey Alexandrovich Kryukov 9,025
1 OriginalGriff 7,317
2 Maciej Los 3,570
3 Abhinav S 3,298
4 Peter Leow 3,084


Advertise | Privacy | Mobile
Web03 | 2.8.150427.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