drop down list in databound gridview help?

Hi,
I am using a gridview to show information from a database

nameid | name | address1 | postcode | countryid
1 | bob | 24 green street | ga22ac | 2

and a country table

countryid | countryname

1 | USA
2 | United Kingdom

the user table is shown in the gridview as a series of text boxes,but instead of a 2 for countryid as a textbox, i'd like it to be a drop down list with either USA, United Kingdom, or anything else from the country table column so that its possible to change this value.

for the life of me i cant seem to figure it out. please could someone show me the light !

thanks alot

P&P :-)

Nov 26 '07 #1

Subscribe Post Reply

1506

dip_developer

648

Expert 512MB

Hi,
I am using a gridview to show information from a database

nameid | name | address1 | postcode | countryid
1 | bob | 24 green street | ga22ac | 2

and a country table

countryid | countryname

1 | USA
2 | United Kingdom

the user table is shown in the gridview as a series of text boxes,but instead of a 2 for countryid as a textbox, i'd like it to be a drop down list with either USA, United Kingdom, or anything else from the country table column so that its possible to change this value.

for the life of me i cant seem to figure it out. please could someone show me the light !

thanks alot

P&P :-)

There are various techniques you can use to populate a DropDownList inside the GridView control. The most simple is using the SqlDataSource object. Simply assign the DataSource property of the DropDownList to the SqlDataSource object through the smart tag.Populate your country DropDownList using custom method PopulateDropDownList().

Here is the method :

Expand|Select|Wrap|Line Numbers

  
public DataSet PopulateDropDownList() 

{

SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString);

SqlDataAdapter myAdapter = new SqlDataAdapter("SELECT * FROM tblCountry", myConnection);

DataSet myDataset = new DataSet();

myAdapter .Fill(myDataset , "tblCountry");

return myDataset ; 

}

Now call this method like this :

Expand|Select|Wrap|Line Numbers

  
<ItemTemplate>

<asp:DropDownList ID="DropDownList1" runat="server" DataSource="<%# PopulateDropDownList() %>" 
 DataTextField="countryname" DataValueField = "countryid">

</asp:DropDownList>

</ItemTemplate>

Nov 26 '07 #2

pieandpeas

brilliant!, thanks alot, are there any other methods anyone could recommend, i'd like to email this on to someone to have a read up on.

thanks again!

Nov 26 '07 #3

Similar topics

GridView W/Drop Down List Question

by: Bishop | last post by:

I made a GridView with a Drop Down List using the example here: http://www.orcsweb.com/articles/dotnet_control_templates.aspx It appears to work except that it dosn't actually save the updated...

ASP.NET

DataBound Drop Down List

by: thebison | last post by:

Hi all, I hope someone can help with this relatively simple problem. I am building a timesheet application using ASP.NET C# with Visual Studio 2003.As it is only a protoype application, my...

ASP.NET

When click update button inside Gridview, got problem about value of drop down list

by: ayneekeaw | last post by:

When I click the update button/link at the Gridview to update the data from drop down list into the SQL. The selected value of drop down list change to default value. How can I fix this problem

.NET Framework

Changing drop down select stmt

by: David | last post by:

I cannot get a simple changing of a SelectCommand for a SqlDataSource used in a drop-down list to work. If I do the same process to my GridView SqlDataSource it works fine. Can anyone help? I am...

ASP.NET

Problems with Drop Down List Control

by: Derty | last post by:

Have an issue with a simple drop down list that I need to filter results of a database table and page display. I can get the drop down list to populate correctly but can't make the page databound...

ASP.NET

Drop down list on each GridView row

by: McGeeky | last post by:

Hi. I have a read only GridView. For each row I want to display a drop down list which contains a list of actions the user can select from for that particular row. E.g. "view details". When they...

ASP.NET

Drop down list error: "Databinding methods such as Eval(), XPath(),and Bind() can only be used in the context of a databound control."

by: yosri2005 | last post by:

Hello, I'm sure many of you have seen the error message in the subject. I found quiet a few posts on the web regarding this issue, but the ones I saw mainly tackle this issue when you have a...

ASP.NET

Icon graphics in gridview drop-down field?

by: Mark B | last post by:

I'd like to have a field in a gridview (or standalone on a webpage) that not only drops down each salespersons name but also precedes their name with a blue, red, green or orange dot icon depicting...

ASP.NET

GridView w/ drop down menu

by: Slickuser | last post by:

Hi, I would like to put a drop down menu in a gridview with the datatype selected from the SQL database. These are the values will show. red orange white green

C# / C Sharp

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET