Klik op de knop 'Start' in Windows en selecteer " Microsoft Visual Studio . " Kopen van 2

Klik op " Open" en selecteer de ASP.NET Web pagina in die u wilt een kolom op een GridView maken in een keuzelijst
3

Voeg de volgende code toe aan uw webpagina na de " vorm " lijn : .

< , asp : GridView ID = " GridView1 " runat = " server " AutoGenerateColumns = " False "

DataKeyNames
= " Land " DataSourceID = " SqlDataSource1 "

Aanmelden>

< asp ShowEditButton="True" : BoundField DataField = " Land " HeaderText = " Land "

InsertVisible
= " False " ReadOnly = " True " SortExpression = "Land " >

< asp /: BoundField DataField = " Bevolking " HeaderText = " Bevolking "

SortExpression
= " Bevolking " />

< asp : BoundField DataField = " Capitol " HeaderText = " Capitol "

SortExpression
= " Capitol " >

< asp /: BoundField DataField = " Gemaakt " HeaderText = " gemaakt "

SortExpression
= " gemaakt " />

< br >

< asp : DropDownList ID = " DropDownList1 " runat = " server "

DataSourceID = " SqlDataSource2 " DataTextField
= " Ruimte " DataValueField = " Ruimte "

SelectedValue = ' < % # Bind ( " Area " ) ID = " Label1 " runat = " server " Text = ' < % # Bind ( " Area " ) ID = " SqlDataSource1 " runat = " server "

ConnectionString
= " < % $ connectionStrings : NORTHWNDConnectionString % > "

DeleteCommand = " DELETE FROM [ Werknemers ] WHERE [ Land ] = @ land "

InsertCommand = " INSERT INTO [ Medewerkers ] ( [ Bevolking ] , [ Capitool ] , [ Gemaakt ] , [Gebied ] ) VALUES ( @ Bevolking , @ Capitool , @ Gemaakt , @ Area ) " < br >

SelectCommand = " SELECT [ Land ] , [ Bevolking ] , [ Capitool ] , [ Gemaakt ] , [Gebied ] FROM [ Werknemers ] "

UpdateCommand = " UPDATE [ Werknemers ] SET [ Bevolking ] = @ Bevolking , [ Capitool ] = @ Capitol , [ Gemaakt ] = @ Gemaakt , [Gebied ] = @ Area WHERE [ Land ] = @ Land " >

< , asp : Parameter Name = " Land " type = " Int32 " >

>

< asp /< /DeleteParameters : Parameter Naam = " Bevolking " type = " String " />

Name="Capitol" Type="String" />

< asp : Parameter Name = " gemaakt "Type = " DateTime " />

Name="Area" Type="String" />

< asp : Parameter Name = " Land " type = " Int32 " />

< /UpdateParameters >

< asp : Parameter Name = " Bevolking " type = " String " />

Name="Capitol" Type="String" />

Name="Created" Type="DateTime" /> ;

Name="Area" Type="String" />

< /InsertParameters >

< /asp : SqlDataSource > < br >

Klik 4 " File ", " Opslaan " om een column te maken op een GridView in de geografische keuzelijst objecten .