So I know that this has been an occurring issue, but Ican't seem to find a solution to my this message. "FullName" was created trough "DropDownList1" by the following command in query builder "SELECT EmpID, FName, + ' ' LName AS FullName FROM Employee". "FullName" is supposed to be the data field that displays in the dropdownlist and EmpID is the value. I'm kind of new to visual studio and its languages. I hope someone can find what the problem is here, thanks in advance!
C#
namespace WebApplication2
{
public partial class Recipe
{
protected global::System.Web.UI.WebControls.GridView GridView1;
protected global::System.Web.UI.WebControls.SqlDataSource SqlDataSource1;
protected global::System.Web.UI.WebControls.FormView FormView1;
protected global::System.Web.UI.WebControls.SqlDataSource SqlDataSource2;
protected global::System.Web.UI.WebControls.FormView FormView2;
protected global::System.Web.UI.WebControls.SqlDataSource SqlDataSource3;
protected global::System.Web.UI.WebControls.SqlDataSource SqlDataSource4;
protected global::System.Web.UI.WebControls.SqlDataSource SqlDataSource5;
protected global::System.Web.UI.WebControls.SqlDataSource SqlDataSource6;
}
}
C#
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication2
{
public partial class Recipe : Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void FormView1_PageIndexChanging(object sender,
FormViewPageEventArgs e)
{
}
protected void FormView2_PageIndexChanging(object sender,
FormViewPageEventArgs e)
{
}
}
}
ASP.NET
<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="Recipe.aspx.cs" Inherits="WebApplication2.Recipe" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="RecipeID" DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display." OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AllowSorting="True">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="RecipeID" HeaderText="RecipeID" ReadOnly="True" SortExpression="RecipeID" />
<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
<asp:BoundField DataField="Instructions" HeaderText="Instructions" SortExpression="Instructions" />
<asp:BoundField DataField="EmpID" HeaderText="EmpID" SortExpression="EmpID" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LABB7ConnectionString1 %>" DeleteCommand="DELETE FROM [Recipe] WHERE [RecipeID] = @RecipeID" InsertCommand="INSERT INTO [Recipe] ([Name], [Description], [Instructions], [EmpID]) VALUES (@Name, @Description, @Instructions, @EmpID)" ProviderName="<%$ ConnectionStrings:LABB7ConnectionString1.ProviderName %>" SelectCommand="SELECT [RecipeID], [Name], [Description], [Instructions], [EmpID] FROM [Recipe]" UpdateCommand="UPDATE [Recipe] SET [Name] = @Name, [Description] = @Description, [Instructions] = @Instructions, [EmpID] = @EmpID WHERE [RecipeID] = @RecipeID">
<DeleteParameters>
<asp:Parameter Name="RecipeID" Type="Int64" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Instructions" Type="String" />
<asp:Parameter Name="EmpID" Type="Int64" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Instructions" Type="String" />
<asp:Parameter Name="EmpID" Type="Int64" />
<asp:Parameter Name="RecipeID" Type="Int64" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:FormView ID="FormView1" runat="server" DataKeyNames="RecipeID" DataSourceID="SqlDataSource2" DefaultMode="Insert" OnPageIndexChanging="FormView1_PageIndexChanging" Width="226px">
<EditItemTemplate>
RecipeID:
<asp:Label ID="RecipeIDLabel1" runat="server" Text='<%# Eval("RecipeID") %>' />
<br />
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
Description:
<asp:TextBox ID="DescriptionTextBox" runat="server" Text='<%# Bind("Description") %>' />
<br />
Instructions:
<asp:TextBox ID="InstructionsTextBox" runat="server" Text='<%# Bind("Instructions") %>' />
<br />
EmpID:
<asp:TextBox ID="EmpIDTextBox" runat="server" Text='<%# Bind("EmpID") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<InsertItemTemplate>
Name:
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' />
<br />
Description:
<asp:TextBox ID="DescriptionTextBox" runat="server" Text='<%# Bind("Description") %>' />
<br />
Instructions:
<asp:TextBox ID="InstructionsTextBox" runat="server" Text='<%# Bind("Instructions") %>' />
<br />
EmpID:
<asp:DropDownList ID="DropDownList1" SelectedValue='<%# Bind("EmpID") %>' runat="server" DataSourceID="SqlDataSource3" DataTextField="FullName" DataValueField="EmpID">
</asp:DropDownList>
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
RecipeID:
<asp:Label ID="RecipeIDLabel" runat="server" Text='<%# Eval("RecipeID") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Bind("Name") %>' />
<br />
Description:
<asp:Label ID="DescriptionLabel" runat="server" Text='<%# Bind("Description") %>' />
<br />
Instructions:
<asp:Label ID="InstructionsLabel" runat="server" Text='<%# Bind("Instructions") %>' />
<br />
EmpID:
<asp:Label ID="EmpIDLabel" runat="server" Text='<%# Bind("EmpID") %>' />
<br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" />
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" />
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:LABB7ConnectionString1 %>" DeleteCommand="DELETE FROM [Recipe] WHERE [RecipeID] = @RecipeID" InsertCommand="INSERT INTO [Recipe] ([Name], [Description], [Instructions], [EmpID]) VALUES (@Name, @Description, @Instructions, @EmpID)" SelectCommand="SELECT EmpID, FName + ' ' + LName AS FullName FROM Employee" UpdateCommand="UPDATE [Recipe] SET [Name] = @Name, [Description] = @Description, [Instructions] = @Instructions, [EmpID] = @EmpID WHERE [RecipeID] = @RecipeID">
<DeleteParameters>
<asp:Parameter Name="RecipeID" Type="Int64" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Instructions" Type="String" />
<asp:Parameter Name="EmpID" Type="Int64" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="Instructions" Type="String" />
<asp:Parameter Name="EmpID" Type="Int64" />
<asp:Parameter Name="RecipeID" Type="Int64" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
Lägg till ingrediens<br />
<asp:FormView ID="FormView2" runat="server" DataKeyNames="IngredientID,RecipeID" DataSourceID="SqlDataSource3" DefaultMode="Insert" OnPageIndexChanging="FormView2_PageIndexChanging">
<EditItemTemplate>
IngredientID:
<asp:Label ID="IngredientIDLabel1" runat="server" Text='<%# Eval("IngredientID") %>' />
<br />
RecipeID:
<asp:Label ID="RecipeIDLabel1" runat="server" Text='<%# Eval("RecipeID") %>' />
<br />
amount:
<asp:TextBox ID="amountTextBox" runat="server" Text='<%# Bind("amount") %>' />
<br />
unit:
<asp:TextBox ID="unitTextBox" runat="server" Text='<%# Bind("unit") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<InsertItemTemplate>
IngredientID:
<asp:DropDownList ID="DropDownList2" SelectedValue='<%# Bind("IngredientID") %>' runat="server" DataSourceID="SqlDataSource4" DataTextField="Name" DataValueField="IngredientID">
</asp:DropDownList>
<br />
RecipeID:
<asp:DropDownList ID="DropDownList3" SelectedValue='<%# Bind("RecipeID") %>' runat="server" DataSourceID="SqlDataSource5" DataTextField="Name" DataValueField="RecipeID">
</asp:DropDownList>
<br />
amount:
<asp:TextBox ID="amountTextBox" runat="server" Text='<%# Bind("amount") %>' />
<br />
unit:
<asp:DropDownList ID="DropDownList4" SelectedValue='<%# Bind("unit") %>' runat="server" DataSourceID="SqlDataSource6" DataTextField="unit" DataValueField="unit">
</asp:DropDownList>
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</InsertItemTemplate>
<ItemTemplate>
Ingredient:
<asp:Label ID="IngredientIDLabel" runat="server" Text='<%# Eval("IngredientID") %>' />
<br />
Recipe:
<asp:Label ID="RecipeIDLabel" runat="server" Text='<%# Eval("RecipeID") %>' />
<br />
amount:
<asp:Label ID="amountLabel" runat="server" Text='<%# Bind("amount") %>' />
<br />
unit:
<asp:Label ID="unitLabel" runat="server" Text='<%# Bind("unit") %>' />
<br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" />
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" />
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:LABB7ConnectionString1 %>" DeleteCommand="DELETE FROM [RecipeIngredient] WHERE [IngredientID] = @IngredientID AND [RecipeID] = @RecipeID" InsertCommand="INSERT INTO [RecipeIngredient] ([IngredientID], [RecipeID], [amount], [unit]) VALUES (@IngredientID, @RecipeID, @amount, @unit)" SelectCommand="SELECT * FROM [RecipeIngredient]" UpdateCommand="UPDATE [RecipeIngredient] SET [amount] = @amount, [unit] = @unit WHERE [IngredientID] = @IngredientID AND [RecipeID] = @RecipeID">
<DeleteParameters>
<asp:Parameter Name="IngredientID" Type="Int64" />
<asp:Parameter Name="RecipeID" Type="Int64" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="IngredientID" Type="Int64" />
<asp:Parameter Name="RecipeID" Type="Int64" />
<asp:Parameter Name="amount" Type="Int32" />
<asp:Parameter Name="unit" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="amount" Type="Int32" />
<asp:Parameter Name="unit" Type="String" />
<asp:Parameter Name="IngredientID" Type="Int64" />
<asp:Parameter Name="RecipeID" Type="Int64" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:LABB7ConnectionString1 %>" SelectCommand="SELECT [IngredientID], [Name] FROM [Ingredient]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:LABB7ConnectionString1 %>" SelectCommand="SELECT [Name], [RecipeID] FROM [Recipe]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:LABB7ConnectionString1 %>" SelectCommand="SELECT * FROM [Unit]"></asp:SqlDataSource>
</asp:Content>
What I have tried:
I have been trying to figure out where "FullName" is missing