Loading

Must declare the scalar variable "@ID". Description: An

Must declare the scalar variable "@ID". Description: An

Yogesh Vedpathak

Yogesh Vedpathak

10y3.7kLearn iOS Programming

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Webform1.aspx.cs" Inherits="aabhdi.Webform1" %>

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,

I think you must declare update and delete parameters like below-

<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>

Please have a look at below article too-
http://www.aspsnippets.com/Articles/Insert-Update-Edit-Delete-record-in-GridView-using-SqlDataSource-in-ASPNet.aspx
Manas Mohapatra10y ago
Use DataKeyNames property to delete/update records.
Make sure that ID column is present in "*" columns - so better to give proper column names.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
DataSourceID="SqlDataSource1" EnableModelValidation="True" DataKeyNames="ID">
asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DataConnectionString %>"
SelectCommand="SELECT ID,Others FROM [ABHIDI]"
UpdateCommand="UPDATE [ABHIDI] set [ID]= @ID,[NAME]= @NAME,[EMAIL]= @EMAIL,[MOBILE]= @MOBILE, where [ID]=@ID"
DeleteCommand="DELETE From [ABHIDI] Where [ID]=@ID" >
asp:SqlDataSource>
https://www.asp.net/web-forms/overview/data-access/accessing-the-database-directly-from-an-aspnet-page/inserting-updating-and-deleting-data-with-the-sqldatasource-vb
Yogesh Vedpathak10y ago
hiii please see all files and help me
advance thanks