< asp: DropDownList ID = " DropDownList1 " runat = "server"
DataSourceID = " SqlDataSource2 " DataTextField = " Area" DataValueField = " Area"
SelectedValue = ' < % # Bind ( "Area" ) ID = " Label1 " runat = "server" Text = '< % # Bind ( "Area" ) ID = " SqlDataSource1 " runat = "server"
ConnectionString = "< % $ ConnectionStrings : NORTHWNDConnectionString %>"
DeleteCommand = " DELETE FROM [ Employees] WHERE [ Land ] = @ country "
InsertCommand =" INSERT INTO [Employees ] ([ Bevölkerung ], [ Capitol ], [ Erstellt ], [ Bereich] ) VALUES ( @ Bevölkerung, @ Capitol , @ Erstellt , @ Area) "
SelectCommand = " SELECT [ Land ], [ Bevölkerung ], [ Capitol ], [ Erstellt ], [ Bereich] FROM [ Employees] "
UpdateCommand = " UPDATE [ Mitarbeiter ] SET [ Bevölkerung ] = @ Bevölkerung, [ Capitol ] = @ Capitol , [ Erstellt ] = @ Erstellt , [Bereich ] = @ Bereich, in dem [ Land ] = @ Country " >
< ; asp : Parameter Name = " Country" Type = " Int32 " />
< asp: Parameter Name = " Bevölkerung " Type = "String" />
Download
< asp : Parameter Name = " Erstellt "Type =" DateTime "/>
Download
< asp : Parameter Name =" Country " Type = " Int32 " />
< asp : Parameter Name = " Bevölkerung " Type = "String" />
Download
;
Download
< /asp: SqlDataSource >
4
Klicken Sie auf " Datei", " Speichern", um eine Spalte auf einem GridView machen in der geographischen Objekte Dropdown-Liste .