I am using a grid control which has an edit mode and shows Support Requests.
I have changed Deaprtment to have a dropdownlist in edit mode which is working fine, what I would like to do is have a label display the "Department Name" column when not in edit mode as a "Department ID" is not very informative unless you know what the various codes mean.
Department Table for example consists of:
DepartmentID Department
1 Admin
2 HR
3 Sales
The Support Request Table saves the department for each record as "DepartmentID".
I've been searching around and can't find anything on this, can someone help me out please.
Here is my code:
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="RequestID" DataSourceID="RequestDataSource">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="RequestID" HeaderText="RequestID"
InsertVisible="False" ReadOnly="True" SortExpression="RequestID" />
<asp:BoundField DataField="EmailAddress" HeaderText="EmailAddress"
SortExpression="EmailAddress" />
<asp:BoundField DataField="Extension" HeaderText="Extension"
SortExpression="Extension" />
<asp:TemplateField HeaderText="DepartmentID" SortExpression="DepartmentID">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="DepartmentDataSource" DataTextField="Department"
DataValueField="DepartmentID" SelectedValue='<%# Bind("DepartmentID") %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("DepartmentID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PriorityID" HeaderText="PriorityID"
SortExpression="PriorityID" />
<asp:BoundField DataField="CategoryID" HeaderText="CategoryID"
SortExpression="CategoryID" />
<asp:BoundField DataField="Subject" HeaderText="Subject"
SortExpression="Subject" />
<asp:BoundField DataField="Problem" HeaderText="Problem"
SortExpression="Problem" />
<asp:BoundField DataField="Created" HeaderText="Created"
SortExpression="Created" />
<asp:BoundField DataField="StatusID" HeaderText="StatusID"
SortExpression="StatusID" />
<asp:BoundField DataField="AssignedID" HeaderText="AssignedID"
SortExpression="AssignedID" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="RequestDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ISDSupportConnectionString %>"
DeleteCommand="DELETE FROM [supportRequest] WHERE [RequestID] = @RequestID"
InsertCommand="INSERT INTO [supportRequest] ([EmailAddress], [Extension], [DepartmentID], [PriorityID], [CategoryID], [Subject], [Problem], [Created], [StatusID], [AssignedID]) VALUES (@EmailAddress, @Extension, @DepartmentID, @PriorityID, @CategoryID, @Subject, @Problem, @Created, @StatusID, @AssignedID)"
SelectCommand="SELECT * FROM [supportRequest]"
UpdateCommand="UPDATE [supportRequest] SET [EmailAddress] = @EmailAddress, [Extension] = @Extension, [DepartmentID] = @DepartmentID, [PriorityID] = @PriorityID, [CategoryID] = @CategoryID, [Subject] = @Subject, [Problem] = @Problem, [Created] = @Created, [StatusID] = @StatusID, [AssignedID] = @AssignedID WHERE [RequestID] = @RequestID">
<DeleteParameters>
<asp:Parameter Name="RequestID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="EmailAddress" Type="String" />
<asp:Parameter Name="Extension" Type="String" />
<asp:Parameter Name="DepartmentID" Type="Int32" />
<asp:Parameter Name="PriorityID" Type="Int32" />
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Problem" Type="String" />
<asp:Parameter Name="Created" Type="DateTime" />
<asp:Parameter Name="StatusID" Type="Int32" />
<asp:Parameter Name="AssignedID" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="EmailAddress" Type="String" />
<asp:Parameter Name="Extension" Type="String" />
<asp:Parameter Name="DepartmentID" Type="Int32" />
<asp:Parameter Name="PriorityID" Type="Int32" />
<asp:Parameter Name="CategoryID" Type="Int32" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Problem" Type="String" />
<asp:Parameter Name="Created" Type="DateTime" />
<asp:Parameter Name="StatusID" Type="Int32" />
<asp:Parameter Name="AssignedID" Type="Int32" />
<asp:Parameter Name="RequestID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<br />
<asp:SqlDataSource ID="DepartmentDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ISDSupportConnectionString %>"
SelectCommand="SELECT * FROM [supportDepartments]"></asp:SqlDataSource>
</div>
</form>