EDN Admin
Well-known member
My GridView is working fine but I would like to show the related data in non edit mode rather than the numerical primary key. The DropDownList with the descriptive data appears in edit mode.
My code (Default.aspx) & screenshot is attached. The problem is TeamID and JobFunID.
Any ideas?
<pre class="prettyprint lang-vb <%@ Page Title="Home Page" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
CodeBehind="Default.aspx.vb" Inherits="WebApplication21._Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent
Welcome to ASP.NET!
To learn more about ASP.NET visit http://www.asp.net" title="ASP.NET Website www.asp.net .
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:F1_2011-3ConnectionString %>"
DeleteCommand="DELETE FROM [Employees] WHERE [EmployeeID] = @original_EmployeeID AND [TeamID] = @original_TeamID
AND [JobFunID] = @original_JobFunID AND [EmployeeSurname]
= @original_EmployeeSurname AND [EmployeeFirstName] = @original_EmployeeFirstName AND [DateOfBirth] = @original_DateOfBirth
AND [MaritalStatus] = @original_MaritalStatus AND
[Nationality] = @original_Nationality"
InsertCommand="INSERT INTO [Employees] ([TeamID], [JobFunID], [EmployeeSurname], [EmployeeFirstName], [DateOfBirth], [MaritalStatus],
[Nationality]) VALUES
(@TeamID, @JobFunID, @EmployeeSurname, @EmployeeFirstName, @DateOfBirth, @MaritalStatus, @Nationality)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [EmployeeID], [TeamID], [JobFunID], [EmployeeSurname], [EmployeeFirstName], [DateOfBirth], [MaritalStatus],
[Nationality] FROM [Employees]"
UpdateCommand="UPDATE [Employees] SET [TeamID] = @TeamID, [JobFunID] = @JobFunID, [EmployeeSurname] = @EmployeeSurname, [EmployeeFirstName]
= @EmployeeFirstName,
[DateOfBirth] = @DateOfBirth, [MaritalStatus] = @MaritalStatus, [Nationality] = @Nationality WHERE [EmployeeID] = @original_EmployeeID AND
[TeamID] = @original_TeamID AND
[JobFunID] = @original_JobFunID AND [EmployeeSurname] = @original_EmployeeSurname AND [EmployeeFirstName] = @original_EmployeeFirstName AND
[DateOfBirth] = @original_DateOfBirth AND [MaritalStatus] = @original_MaritalStatus AND [Nationality] = @original_Nationality
<DeleteParameters>
<asp
arameter Name="original_EmployeeID" Type="Int32" />
<asparameter Name="original_TeamID" Type="Int32" />
<asparameter Name="original_JobFunID" Type="Int32" />
<asparameter Name="original_EmployeeSurname" Type="String" />
<asparameter Name="original_EmployeeFirstName" Type="String" />
<asparameter Name="original_DateOfBirth" Type="DateTime" />
<asparameter Name="original_MaritalStatus" Type="String" />
<asparameter Name="original_Nationality" Type="String" />
</DeleteParameters>
<InsertParameters>
<asparameter Name="TeamID" Type="Int32" />
<asparameter Name="JobFunID" Type="Int32" />
<asparameter Name="EmployeeSurname" Type="String" />
<asparameter Name="EmployeeFirstName" Type="String" />
<asparameter Name="DateOfBirth" Type="DateTime" />
<asparameter Name="MaritalStatus" Type="String" />
<asparameter Name="Nationality" Type="String" />
</InsertParameters>
<UpdateParameters>
<asparameter Name="TeamID" Type="Int32" />
<asparameter Name="JobFunID" Type="Int32" />
<asparameter Name="EmployeeSurname" Type="String" />
<asparameter Name="EmployeeFirstName" Type="String" />
<asparameter Name="DateOfBirth" Type="DateTime" />
<asparameter Name="MaritalStatus" Type="String" />
<asparameter Name="Nationality" Type="String" />
<asparameter Name="original_EmployeeID" Type="Int32" />
<asparameter Name="original_TeamID" Type="Int32" />
<asparameter Name="original_JobFunID" Type="Int32" />
<asparameter Name="original_EmployeeSurname" Type="String" />
<asparameter Name="original_EmployeeFirstName" Type="String" />
<asparameter Name="original_DateOfBirth" Type="DateTime" />
<asparameter Name="original_MaritalStatus" Type="String" />
<asparameter Name="original_Nationality" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:F1_2011-3ConnectionString %>"
DeleteCommand="DELETE FROM [Teams] WHERE [TeamID] = @original_TeamID AND [TeamName] = @original_TeamName"
InsertCommand="INSERT INTO [Teams] ([TeamName]) VALUES (@TeamName)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [TeamID], [TeamName] FROM [Teams]"
UpdateCommand="UPDATE [Teams] SET [TeamName] = @TeamName WHERE [TeamID] = @original_TeamID AND [TeamName] = @original_TeamName
<DeleteParameters>
<asparameter Name="original_TeamID" Type="Int32" />
<asparameter Name="original_TeamName" Type="String" />
</DeleteParameters>
<InsertParameters>
<asparameter Name="TeamName" Type="String" />
</InsertParameters>
<UpdateParameters>
<asparameter Name="TeamName" Type="String" />
<asparameter Name="original_TeamID" Type="Int32" />
<asparameter Name="original_TeamName" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:F1_2011-3ConnectionString %>"
SelectCommand="SELECT [JobFunID], [JobFunction] FROM [JobFunction]"
ConflictDetection="CompareAllValues"
DeleteCommand="DELETE FROM [JobFunction] WHERE [JobFunID] = @original_JobFunID AND [JobFunction] = @original_JobFunction"
InsertCommand="INSERT INTO [JobFunction] ([JobFunction]) VALUES (@JobFunction)"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE [JobFunction] SET [JobFunction] = @JobFunction WHERE [JobFunID] = @original_JobFunID AND [JobFunction] = @original_JobFunction
<DeleteParameters>
<asparameter Name="original_JobFunID" Type="Int32" />
<asparameter Name="original_JobFunction" Type="String" />
</DeleteParameters>
<InsertParameters>
<asparameter Name="JobFunction" Type="String" />
</InsertParameters>
<UpdateParameters>
<asparameter Name="JobFunction" Type="String" />
<asparameter Name="original_JobFunID" Type="Int32" />
<asparameter Name="original_JobFunction" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="EmployeeID"
DataSourceID="SqlDataSource1
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowSelectButton="True" />
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID"
InsertVisible="False" ReadOnly="True" SortExpression="EmployeeID" />
<asp:TemplateField HeaderText="TeamID" SortExpression="TeamID
<EditItemTemplate>
<asp
ropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource2" DataTextField="TeamName" DataValueField="TeamID"
SelectedValue=<%# Bind("TeamID") %> Width="107px
</aspropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text=<%# Bind("TeamID") %>></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="JobFunID" SortExpression="JobFunID
<EditItemTemplate>
<aspropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource3"
DataTextField="JobFunction" DataValueField="JobFunID"
SelectedValue=<%# Bind("JobFunID") %> Width="130px" AutoPostBack="True
</aspropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text=<%# Bind("JobFunID") %>></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="EmployeeSurname" HeaderText="EmployeeSurname"
SortExpression="EmployeeSurname" />
<asp:BoundField DataField="EmployeeFirstName" HeaderText="EmployeeFirstName"
SortExpression="EmployeeFirstName" />
<asp:BoundField DataField="DateOfBirth" HeaderText="DateOfBirth"
SortExpression="DateOfBirth" />
<asp:BoundField DataField="MaritalStatus" HeaderText="MaritalStatus"
SortExpression="MaritalStatus" />
<asp:BoundField DataField="Nationality" HeaderText="Nationality"
SortExpression="Nationality" />
</Columns>
</asp:GridView>
You can also find http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
title="MSDN ASP.NET Docs documentation on ASP.NET at MSDN .
</asp:Content>
[/code]
<img alt="" src="http://social.msdn.microsoft.com/Forums/getfile/112706 <br/>
View the full article
My code (Default.aspx) & screenshot is attached. The problem is TeamID and JobFunID.
Any ideas?
<pre class="prettyprint lang-vb <%@ Page Title="Home Page" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
CodeBehind="Default.aspx.vb" Inherits="WebApplication21._Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent
Welcome to ASP.NET!
To learn more about ASP.NET visit http://www.asp.net" title="ASP.NET Website www.asp.net .
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:F1_2011-3ConnectionString %>"
DeleteCommand="DELETE FROM [Employees] WHERE [EmployeeID] = @original_EmployeeID AND [TeamID] = @original_TeamID
AND [JobFunID] = @original_JobFunID AND [EmployeeSurname]
= @original_EmployeeSurname AND [EmployeeFirstName] = @original_EmployeeFirstName AND [DateOfBirth] = @original_DateOfBirth
AND [MaritalStatus] = @original_MaritalStatus AND
[Nationality] = @original_Nationality"
InsertCommand="INSERT INTO [Employees] ([TeamID], [JobFunID], [EmployeeSurname], [EmployeeFirstName], [DateOfBirth], [MaritalStatus],
[Nationality]) VALUES
(@TeamID, @JobFunID, @EmployeeSurname, @EmployeeFirstName, @DateOfBirth, @MaritalStatus, @Nationality)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [EmployeeID], [TeamID], [JobFunID], [EmployeeSurname], [EmployeeFirstName], [DateOfBirth], [MaritalStatus],
[Nationality] FROM [Employees]"
UpdateCommand="UPDATE [Employees] SET [TeamID] = @TeamID, [JobFunID] = @JobFunID, [EmployeeSurname] = @EmployeeSurname, [EmployeeFirstName]
= @EmployeeFirstName,
[DateOfBirth] = @DateOfBirth, [MaritalStatus] = @MaritalStatus, [Nationality] = @Nationality WHERE [EmployeeID] = @original_EmployeeID AND
[TeamID] = @original_TeamID AND
[JobFunID] = @original_JobFunID AND [EmployeeSurname] = @original_EmployeeSurname AND [EmployeeFirstName] = @original_EmployeeFirstName AND
[DateOfBirth] = @original_DateOfBirth AND [MaritalStatus] = @original_MaritalStatus AND [Nationality] = @original_Nationality
<DeleteParameters>
<asp
arameter Name="original_EmployeeID" Type="Int32" /><asp
arameter Name="original_TeamID" Type="Int32" /><asp
arameter Name="original_JobFunID" Type="Int32" /><asp
arameter Name="original_EmployeeSurname" Type="String" /><asp
arameter Name="original_EmployeeFirstName" Type="String" /><asp
arameter Name="original_DateOfBirth" Type="DateTime" /><asp
arameter Name="original_MaritalStatus" Type="String" /><asp
arameter Name="original_Nationality" Type="String" /></DeleteParameters>
<InsertParameters>
<asp
arameter Name="TeamID" Type="Int32" /><asp
arameter Name="JobFunID" Type="Int32" /><asp
arameter Name="EmployeeSurname" Type="String" /><asp
arameter Name="EmployeeFirstName" Type="String" /><asp
arameter Name="DateOfBirth" Type="DateTime" /><asp
arameter Name="MaritalStatus" Type="String" /><asp
arameter Name="Nationality" Type="String" /></InsertParameters>
<UpdateParameters>
<asp
arameter Name="TeamID" Type="Int32" /><asp
arameter Name="JobFunID" Type="Int32" /><asp
arameter Name="EmployeeSurname" Type="String" /><asp
arameter Name="EmployeeFirstName" Type="String" /><asp
arameter Name="DateOfBirth" Type="DateTime" /><asp
arameter Name="MaritalStatus" Type="String" /><asp
arameter Name="Nationality" Type="String" /><asp
arameter Name="original_EmployeeID" Type="Int32" /><asp
arameter Name="original_TeamID" Type="Int32" /><asp
arameter Name="original_JobFunID" Type="Int32" /><asp
arameter Name="original_EmployeeSurname" Type="String" /><asp
arameter Name="original_EmployeeFirstName" Type="String" /><asp
arameter Name="original_DateOfBirth" Type="DateTime" /><asp
arameter Name="original_MaritalStatus" Type="String" /><asp
arameter Name="original_Nationality" Type="String" /></UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:F1_2011-3ConnectionString %>"
DeleteCommand="DELETE FROM [Teams] WHERE [TeamID] = @original_TeamID AND [TeamName] = @original_TeamName"
InsertCommand="INSERT INTO [Teams] ([TeamName]) VALUES (@TeamName)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [TeamID], [TeamName] FROM [Teams]"
UpdateCommand="UPDATE [Teams] SET [TeamName] = @TeamName WHERE [TeamID] = @original_TeamID AND [TeamName] = @original_TeamName
<DeleteParameters>
<asp
arameter Name="original_TeamID" Type="Int32" /><asp
arameter Name="original_TeamName" Type="String" /></DeleteParameters>
<InsertParameters>
<asp
arameter Name="TeamName" Type="String" /></InsertParameters>
<UpdateParameters>
<asp
arameter Name="TeamName" Type="String" /><asp
arameter Name="original_TeamID" Type="Int32" /><asp
arameter Name="original_TeamName" Type="String" /></UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:F1_2011-3ConnectionString %>"
SelectCommand="SELECT [JobFunID], [JobFunction] FROM [JobFunction]"
ConflictDetection="CompareAllValues"
DeleteCommand="DELETE FROM [JobFunction] WHERE [JobFunID] = @original_JobFunID AND [JobFunction] = @original_JobFunction"
InsertCommand="INSERT INTO [JobFunction] ([JobFunction]) VALUES (@JobFunction)"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE [JobFunction] SET [JobFunction] = @JobFunction WHERE [JobFunID] = @original_JobFunID AND [JobFunction] = @original_JobFunction
<DeleteParameters>
<asp
arameter Name="original_JobFunID" Type="Int32" /><asp
arameter Name="original_JobFunction" Type="String" /></DeleteParameters>
<InsertParameters>
<asp
arameter Name="JobFunction" Type="String" /></InsertParameters>
<UpdateParameters>
<asp
arameter Name="JobFunction" Type="String" /><asp
arameter Name="original_JobFunID" Type="Int32" /><asp
arameter Name="original_JobFunction" Type="String" /></UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="EmployeeID"
DataSourceID="SqlDataSource1
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowSelectButton="True" />
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID"
InsertVisible="False" ReadOnly="True" SortExpression="EmployeeID" />
<asp:TemplateField HeaderText="TeamID" SortExpression="TeamID
<EditItemTemplate>
<asp
ropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2" DataTextField="TeamName" DataValueField="TeamID"
SelectedValue=<%# Bind("TeamID") %> Width="107px
</asp
ropDownList></EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text=<%# Bind("TeamID") %>></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="JobFunID" SortExpression="JobFunID
<EditItemTemplate>
<asp
ropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource3" DataTextField="JobFunction" DataValueField="JobFunID"
SelectedValue=<%# Bind("JobFunID") %> Width="130px" AutoPostBack="True
</asp
ropDownList></EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text=<%# Bind("JobFunID") %>></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="EmployeeSurname" HeaderText="EmployeeSurname"
SortExpression="EmployeeSurname" />
<asp:BoundField DataField="EmployeeFirstName" HeaderText="EmployeeFirstName"
SortExpression="EmployeeFirstName" />
<asp:BoundField DataField="DateOfBirth" HeaderText="DateOfBirth"
SortExpression="DateOfBirth" />
<asp:BoundField DataField="MaritalStatus" HeaderText="MaritalStatus"
SortExpression="MaritalStatus" />
<asp:BoundField DataField="Nationality" HeaderText="Nationality"
SortExpression="Nationality" />
</Columns>
</asp:GridView>
You can also find http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
title="MSDN ASP.NET Docs documentation on ASP.NET at MSDN .
</asp:Content>
[/code]
<img alt="" src="http://social.msdn.microsoft.com/Forums/getfile/112706 <br/>
View the full article