DaniWeb Forum Index > Software Development > C#

C# RSS

get data from database in dropdown list

Please support our C# advertiser: Intel Parallel Studio Home

•

Join Date: Feb 2007

Posts: 3

Reputation: anjela is an unknown quantity at this point

Solved Threads: 0

anjela

Offline

Newbie Poster

get data from database in dropdown list

Feb 21st, 2007

i'm developing application in .net using c# that has 1 dropdown list .I want to take data in it .to show in list.please suggest me some help

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: get data from database in dropdown list

Feb 21st, 2007

select the info that you want into a datatable,
set the datatable as the datasource for the dropdown. call the databind function. and make sure you specify in the dropdown control which columns have correspond with the DataValueField and DataTextField

•

Join Date: Feb 2007

Posts: 3

Reputation: anjela is an unknown quantity at this point

Solved Threads: 0

anjela

Offline

Newbie Poster

Re: get data from database in dropdown list

Feb 22nd, 2007

can u give code for the get data from database in dropdown list

•

Join Date: Dec 2006

Posts: 79

Reputation: nikkiH is an unknown quantity at this point

Solved Threads: 4

nikkiH

Offline

Junior Poster in Training

Re: get data from database in dropdown list

Feb 22nd, 2007

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
       <asp:SqlDataSource ID="sda_nw1" runat="server" ConnectionString='<%$ ConnectionStrings:NORTHWIND %> ' 
        SelectCommand="SELECT orders.customerid, ContactName, count(OrderID) as numorders FROM orders join customers on orders.CustomerID=Customers.CustomerID group by orders.customerid, ContactName order by ContactName" 
        ProviderName="System.Data.SqlClient" OldValuesParameterFormatString="original_{0}">
        </asp:SqlDataSource>
 
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="sda_nw1" DataTextField="customerid"
            DataValueField="customerid">
        </asp:DropDownList><br />
       <asp:SqlDataSource ID="sda_nw1" runat="server" ConnectionString='<%$ ConnectionStrings:NORTHWIND %> ' 
        SelectCommand="SELECT orders.customerid, ContactName, count(OrderID) as numorders FROM orders join customers on orders.CustomerID=Customers.CustomerID group by orders.customerid, ContactName order by ContactName" 
        ProviderName="System.Data.SqlClient" OldValuesParameterFormatString="original_{0}">
        </asp:SqlDataSource>

<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="sda_nw1" DataTextField="customerid"
            DataValueField="customerid">
        </asp:DropDownList><br />

Google is your friend. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/

•

Join Date: Nov 2009

Posts: 1

Reputation: sachingargava is an unknown quantity at this point

Solved Threads: 0

sachingargava sachingargava is offline

Offline

Newbie Poster

-1

20 Days Ago

please give me the source code to retieve data from database todropdownlist in c#.net

•

Join Date: Oct 2009

Posts: 28

Reputation: sanch01r is an unknown quantity at this point

Solved Threads: 2

sanch01r

Offline

Light Poster

14 Days Ago

You can add data that is returned from a reader the same way you would programmatically add items to a combobox (combobox1.Items.Add(*Object to add to combobox*);

Here is a sample of code that I did a while ago, this reads all of the Columns on a particular table and adds it to a combobox.

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
            for (int i = 0; i < dr.FieldCount; i++)
            {
                Fields.Add(dr.GetName(i));
                comboBox1.Items.Add(dr.GetName(i));
 
 
            }
            for (int i = 0; i < dr.FieldCount; i++)
            {
                Fields.Add(dr.GetName(i));
                comboBox1.Items.Add(dr.GetName(i));


            }