Dropdownlist add default blank while bind to sql server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

syncwa - 14 Feb 2006 10:31 GMT

Hi,

My dropdownlist is binded to a sql datasource.
I would like to have it list a blank entry on top and do not show real
data before user select it.
How can I do this.? Thanks

Reply to this Message

Alejandro Penate-Diaz - 14 Feb 2006 11:07 GMT

after you databind do this:
this.DropDownList1.Items.Insert(0,"");

> Hi,
>
> My dropdownlist is binded to a sql datasource.
> I would like to have it list a blank entry on top and do not show real
> data before user select it.
> How can I do this.? Thanks

Reply to this Message

syncwa - 14 Feb 2006 14:28 GMT

Sorry, I'm new to this. I put it in test.aspx.cs but it doesn't work.
Could you take a look at the following code to see where I should put
this? Regards

test.aspx.cs::

public partial class test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DropDownList1.Items.Insert(0, "");
}
}

test.aspx:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="testSqlDataSource1"
DataTextField="Company_Name" DataValueField="Company_ID">
</asp:DropDownList><asp:SqlDataSource ID="testSqlDataSource1"
runat="server" ConnectionString="<%$
ConnectionStrings:kConnectionString %>"
SelectCommand="SELECT [Company_Name], [Company_ID] FROM
[Companies]"></asp:SqlDataSource>

</div>
</form>
</body>
</html>

>after you databind do this:
>this.DropDownList1.Items.Insert(0,"");
[quoted text clipped - 5 lines]
>> data before user select it.
>> How can I do this.? Thanks

Reply to this Message

Alex D. - 14 Feb 2006 15:14 GMT

I would suggest to databind programatically instead of using the IDE.
otherwise I jus dont know how to do it ;-)

> Sorry, I'm new to this. I put it in test.aspx.cs but it doesn't work.
> Could you take a look at the following code to see where I should put
[quoted text clipped - 42 lines]
>>> data before user select it.
>>> How can I do this.? Thanks

Reply to this Message

Dropdownlist add default blank while bind to sql server

Free Magazines