<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"SelectCommand="SELECT * FROM [product]" DeleteCommand="DELETE FROM [product] WHERE [pcode] = @pcode"InsertCommand="Insert into [product] ([pcode], [pname], [purl], [price],[disc]) VALUES (@pcode, @pname, @purl, @price, @disc)"UpdateCommand="UPDATE [products] SET [pname] = @pname, [disc] = @disc, [price] = @price, [purl] = @purl WHERE [pcode] = @pcode"><DeleteParameters><asp:Parameter Name="pcode" Type="string" /></DeleteParameters><UpdateParameters><asp:Parameter Name="pname" Type="string" /><asp:Parameter Name="disc" Type="String" /><asp:Parameter Name="price" Type="double" /><asp:Parameter Name="purl" Type="string" /><asp:Parameter Name="pcode" Type="string" /></UpdateParameters><InsertParameters><asp:Parameter Name="pcode" Type="string"/><asp:Parameter Name="pname" Type="string" /><asp:Parameter Name="purl" Type="string" /><asp:Parameter Name="price" Type="double" /><asp:Parameter Name="disc" Type="string" /></InsertParameters></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [product]"
DeleteCommand="DELETE FROM [product] WHERE [pcode] = @pcode"
InsertCommand="Insert into [product] ([pcode], [pname], [purl], [price],[disc]) VALUES (@pcode, @pname, @purl, @price, @disc)"
UpdateCommand="UPDATE [products] SET [pname] = @pname, [disc] = @disc, [price] = @price, [purl] = @purl WHERE [pcode] = @pcode">
<DeleteParameters>
<asp:Parameter Name="pcode" Type="string" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="pname" Type="string" />
<asp:Parameter Name="disc" Type="String" />
<asp:Parameter Name="price" Type="double" />
<asp:Parameter Name="purl" Type="string" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="pcode" Type="string"/>
<asp:Parameter Name="disc" Type="string" />
</InsertParameters>
</asp:SqlDataSource>