error Must declare the variable '@pname'.
-
hi i m using asp.net with c# and trying to edit gridview but it's give error Must declare the variable '@pname'. my code is <asp:SqlDataSource ID="SqlDataSource1" Runat="server" ConnectionString="<%$ ConnectionStrings:mcplconnectionstring2 %>" UpdateCommand="UPDATE [mat_in] SET [pname] = @pname, [qty] = @qty, [sno_to] = @sno_to,[sno_from]=@sno_from WHERE [materialrecipt_no] = @materialrecipt_no" SelectCommand="SELECT [materialrecipt_no],[pname],[qty],[sno_to],[sno_from] FROM [mat_in]"> <UpdateParameters> <asp:Parameter Type="string" Name="ProductName"></asp:Parameter> <asp:Parameter Type="Decimal" Name="Quantity"></asp:Parameter> <asp:Parameter Type="Decimal" Name="Sr No(Start)"></asp:Parameter> <asp:Parameter Type="Decimal" Name="Sr No(End)"></asp:Parameter> </UpdateParameters> </asp:SqlDataSource> <asp:GridView ID="GridView1" Runat="server" BorderColor="#3366CC" BorderStyle="None" CellPadding="4" BackColor="White" BorderWidth="1px" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="materialrecipt_no" DataSourceID="SqlDataSource1"> <FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle> <PagerStyle ForeColor="#003399" HorizontalAlign="Left" BackColor="#99CCCC"></PagerStyle> <HeaderStyle ForeColor="#CCCCFF" Font-Bold="True" BackColor="#003399"></HeaderStyle> <Columns> <asp:CommandField ShowEditButton="True"></asp:CommandField> <asp:BoundField ReadOnly="True" HeaderText="materialrecipt no" InsertVisible="False" DataField="materialrecipt_no" SortExpression="materialrecipt_no"></asp:BoundField> <asp:TemplateField SortExpression="ProductName" HeaderText="Product"><EditItemTemplate> <asp:DropDownList ID="editProductName" Runat="server" DataSourceID="SqlDataSource1" DataTextField="pname" DataValueField="pname" Text='<%# Bind("pname") %>'></asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ErrorMessage="You must provide a Product Name."
-
hi i m using asp.net with c# and trying to edit gridview but it's give error Must declare the variable '@pname'. my code is <asp:SqlDataSource ID="SqlDataSource1" Runat="server" ConnectionString="<%$ ConnectionStrings:mcplconnectionstring2 %>" UpdateCommand="UPDATE [mat_in] SET [pname] = @pname, [qty] = @qty, [sno_to] = @sno_to,[sno_from]=@sno_from WHERE [materialrecipt_no] = @materialrecipt_no" SelectCommand="SELECT [materialrecipt_no],[pname],[qty],[sno_to],[sno_from] FROM [mat_in]"> <UpdateParameters> <asp:Parameter Type="string" Name="ProductName"></asp:Parameter> <asp:Parameter Type="Decimal" Name="Quantity"></asp:Parameter> <asp:Parameter Type="Decimal" Name="Sr No(Start)"></asp:Parameter> <asp:Parameter Type="Decimal" Name="Sr No(End)"></asp:Parameter> </UpdateParameters> </asp:SqlDataSource> <asp:GridView ID="GridView1" Runat="server" BorderColor="#3366CC" BorderStyle="None" CellPadding="4" BackColor="White" BorderWidth="1px" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="materialrecipt_no" DataSourceID="SqlDataSource1"> <FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle> <PagerStyle ForeColor="#003399" HorizontalAlign="Left" BackColor="#99CCCC"></PagerStyle> <HeaderStyle ForeColor="#CCCCFF" Font-Bold="True" BackColor="#003399"></HeaderStyle> <Columns> <asp:CommandField ShowEditButton="True"></asp:CommandField> <asp:BoundField ReadOnly="True" HeaderText="materialrecipt no" InsertVisible="False" DataField="materialrecipt_no" SortExpression="materialrecipt_no"></asp:BoundField> <asp:TemplateField SortExpression="ProductName" HeaderText="Product"><EditItemTemplate> <asp:DropDownList ID="editProductName" Runat="server" DataSourceID="SqlDataSource1" DataTextField="pname" DataValueField="pname" Text='<%# Bind("pname") %>'></asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ErrorMessage="You must provide a Product Name."