Click here to Skip to main content
11,715,043 members (69,039 online)
Rate this: bad
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();
      ddlTypeid.DataTextField = "Name";
      ddlTypeid.DataSource = ds.Tables[0];
      ddlproductid.DataTextField = "ProductName";
      ddlproductid.DataSource = ds.Tables[1];

Posted 12-Jul-13 0:02am
Edited 12-Jul-13 0:23am

1 solution

Rate this: bad
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>
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 Sergey Alexandrovich Kryukov 520
1 Richard MacCutchan 275
2 Maciej Los 259
3 ManasKumarM 155
4 Frankie-C 125
0 Sergey Alexandrovich Kryukov 775
1 CHill60 415
2 Richard MacCutchan 405
3 Maciej Los 389
4 OriginalGriff 320

Advertise | Privacy | Mobile
Web02 | 2.8.150901.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