keithwilson1
asked on
Updating a GridView that contain a dropdownlist using a Update SqlDataSource
I have created a aspx page that contains a gridview with a dropdownlist that will be updated for every row in the gridview. I want to know the correct parameter values to use when setting up the sqldatasource. I will be using a button to initate the process. Below is my html.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="AssignRole.aspx. vb" Inherits="AssignRole" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblSSCampus" runat="server" Text="SS Campus:"></asp:Label>
<asp:DropDownList ID="ddlSSCampus" runat="server" DataSourceID="SSCampusSqlD ataSource" DataTextField="SchoolName" DataValueField="SchoolId">
</asp:DropDownList><br />
<br />
<asp:Label ID="lblReqPosition" runat="server" Text="Requested Position:"></asp:Label>
<asp:DropDownList ID="ddlPosition" runat="server" DataSourceID="PositionSqlD ataSource" DataTextField="Name" DataValueField="PositionId ">
</asp:DropDownList><br />
<br />
<br />
<asp:GridView ID="grdAssignRole" runat="server" AutoGenerateColumns="False " DataSourceID="RoleAssignme ntSqlDataS ource">
<Columns>
<asp:TemplateField HeaderText="Role" SortExpression="Role_name" >
<EditItemTemplate>
<asp:DropDownList ID="ddlAssignRole" runat="server" DataSourceID="StatusSqlDat aSource"
DataTextField="Role_Name" DataValueField="ID" SelectedIndex='<%#Bind("Id ") %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblRole" runat="server" Text='<%# Bind("Role_name")
%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="applicationId" HeaderText="applicationId" InsertVisible="False"
ReadOnly="True" SortExpression="applicatio nId" Visible="false" />
<asp:BoundField DataField="FacultyName" HeaderText="FacultyName" ReadOnly="True"
SortExpression="FacultyNam e" />
<asp:BoundField DataField="FacultyId" HeaderText="FacultyId" SortExpression="FacultyId" />
<asp:BoundField DataField="StatusId" HeaderText="StatusId" SortExpression="StatusId" Visible="false" />
<asp:BoundField DataField="Position" HeaderText="Position" SortExpression="Position" />
<asp:BoundField DataField="SchoolName" HeaderText="Home Campus" ReadOnly="True" SortExpression="SchoolName " />
<asp:BoundField DataField="OrderNo" HeaderText="OrderNo" SortExpression="OrderNo" Visible="false" />
<asp:BoundField DataField="limitedAvailabi lity" HeaderText="limitedAvailab ility"
ReadOnly="True" SortExpression="limitedAva ilability" Visible="false" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SSCampusSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SummerSc hoolConnec tionString %>"
SelectCommand="ssrSP_getAl lSSCampuse s" SelectCommandType="StoredP rocedure">
<SelectParameters>
<asp:Parameter DefaultValue="4" Name="yrId" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
<asp:SqlDataSource ID="PositionSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SummerSc hoolConnec tionString %>"
SelectCommand="refSP_getPo sitions" SelectCommandType="StoredP rocedure">
<SelectParameters>
<asp:Parameter DefaultValue="0" Name="appId" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="RoleAssignmentSqlDataS ource" runat="server" ConnectionString="<%$ ConnectionStrings:SummerSc hoolConnec tionString %>"
SelectCommand="ssrSP_getRo leAssignme nts" SelectCommandType="StoredP rocedure">
<SelectParameters>
<asp:Parameter DefaultValue="4" Name="yrId" Type="Int32" />
<asp:ControlParameter ControlID="ddlSSCampus" DefaultValue="" Name="SSSchoolId" PropertyName="SelectedValu e"
Type="String" />
<asp:ControlParameter ControlID="ddlPosition" Name="Position" PropertyName="SelectedValu e"
Type="Int32" />
<asp:Parameter DefaultValue="0" Name="Status" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="RolesSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SummerSc hoolConnec tionString %>"
SelectCommand="ssrSP_getRo les" SelectCommandType="StoredP rocedure">
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="SSRole" Type="Int32" />
<asp:Parameter DefaultValue="0" Name="admin" Type="Int32" />
<asp:Parameter DefaultValue="4" Name="yrId" Type="Int32" />
<asp:Parameter DefaultValue="''" Name="schCode" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="AssignRolesSqlDataSour ce" runat="server" UpdateCommand="ssrSP_assig nRole" UpdateCommandType="StoredP rocedure">
<UpdateParameters>
<asp:ControlParameter ControlID="grdAssignRole" Name="applicationId" PropertyName="Columns" />
<asp:ControlParameter ControlID="grdAssignRole" Name="ddlAssignRole.Select edValue" PropertyName="Columns" />
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="AssignRole.aspx.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblSSCampus" runat="server" Text="SS Campus:"></asp:Label>
<asp:DropDownList ID="ddlSSCampus" runat="server" DataSourceID="SSCampusSqlD
</asp:DropDownList><br />
<br />
<asp:Label ID="lblReqPosition" runat="server" Text="Requested Position:"></asp:Label>
<asp:DropDownList ID="ddlPosition" runat="server" DataSourceID="PositionSqlD
</asp:DropDownList><br />
<br />
<br />
<asp:GridView ID="grdAssignRole" runat="server" AutoGenerateColumns="False
<Columns>
<asp:TemplateField HeaderText="Role" SortExpression="Role_name"
<EditItemTemplate>
<asp:DropDownList ID="ddlAssignRole" runat="server" DataSourceID="StatusSqlDat
DataTextField="Role_Name" DataValueField="ID" SelectedIndex='<%#Bind("Id
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblRole" runat="server" Text='<%# Bind("Role_name")
%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="applicationId" HeaderText="applicationId"
ReadOnly="True" SortExpression="applicatio
<asp:BoundField DataField="FacultyName" HeaderText="FacultyName" ReadOnly="True"
SortExpression="FacultyNam
<asp:BoundField DataField="FacultyId" HeaderText="FacultyId" SortExpression="FacultyId"
<asp:BoundField DataField="StatusId" HeaderText="StatusId" SortExpression="StatusId" Visible="false" />
<asp:BoundField DataField="Position" HeaderText="Position" SortExpression="Position" />
<asp:BoundField DataField="SchoolName" HeaderText="Home Campus" ReadOnly="True" SortExpression="SchoolName
<asp:BoundField DataField="OrderNo" HeaderText="OrderNo" SortExpression="OrderNo" Visible="false" />
<asp:BoundField DataField="limitedAvailabi
ReadOnly="True" SortExpression="limitedAva
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SSCampusSqlDataSource"
SelectCommand="ssrSP_getAl
<SelectParameters>
<asp:Parameter DefaultValue="4" Name="yrId" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
<asp:SqlDataSource ID="PositionSqlDataSource"
SelectCommand="refSP_getPo
<SelectParameters>
<asp:Parameter DefaultValue="0" Name="appId" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="RoleAssignmentSqlDataS
SelectCommand="ssrSP_getRo
<SelectParameters>
<asp:Parameter DefaultValue="4" Name="yrId" Type="Int32" />
<asp:ControlParameter ControlID="ddlSSCampus" DefaultValue="" Name="SSSchoolId" PropertyName="SelectedValu
Type="String" />
<asp:ControlParameter ControlID="ddlPosition" Name="Position" PropertyName="SelectedValu
Type="Int32" />
<asp:Parameter DefaultValue="0" Name="Status" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="RolesSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:SummerSc
SelectCommand="ssrSP_getRo
<SelectParameters>
<asp:Parameter DefaultValue="1" Name="SSRole" Type="Int32" />
<asp:Parameter DefaultValue="0" Name="admin" Type="Int32" />
<asp:Parameter DefaultValue="4" Name="yrId" Type="Int32" />
<asp:Parameter DefaultValue="''" Name="schCode" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="AssignRolesSqlDataSour
<UpdateParameters>
<asp:ControlParameter ControlID="grdAssignRole" Name="applicationId" PropertyName="Columns" />
<asp:ControlParameter ControlID="grdAssignRole" Name="ddlAssignRole.Select
</UpdateParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.