drop down list in databound gridview help?

[pieandpeas]

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 :-)

[dip_developer]

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 :

 
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 :

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

[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!