I am getting this error.
System.Data.SqlClient.SqlException: Must declare the variable '@InventoryID'.
At first I left the parameter declaration in the aspx page and then I tried
moving it to the codebehind as well. Still errored.
Codebehind snip----------------
public partial class Admin_AdminCreateInventory : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser user = Membership.GetUser();
SqlDataSource1.SelectCommand = "SELECT [InventoryID],
[InventoryName], [creationDate] FROM [InventoryList] WHERE ([owner] = '" +
user.ProviderUserKey.ToString() + "')";
SqlDataSource1.DeleteParameters.Add("InventoryID",
TypeCode.Int32, "");
SqlDataSource1.DeleteCommand = "DELETE FROM [InventoryList]
WHERE [InventoryID] = @InventoryID";
}
}
aspx snip----------------------
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master"
AutoEventWireup="true" CodeFile="AdminCreateInventory.aspx.cs"
Inherits="Admin_AdminCreateInventory" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<br />
Your current inventory Databases:<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:BaseConnectionString
%>"></asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" />
</Columns>
</asp:GridView>
</asp:Content>
