Must declare the scalar variable '@FirstName'

[Ken Adeniji]

Must declare the scalar variable '@FirstName'

ContactGridViewWebForm.aspx
<aspqlDataSource
RunAt="server"
ID="SqlDataSourceContact"

ConnectionString="server=localhost;database=WordEngineering;Integrated
Security=SSPI;"
ProviderName="System.Data.OleDb"
SelectCommand="SELECT SequenceOrderId, FirstName, LastName,
OtherName, Company FROM Contact ORDER BY SequenceOrderId"
UpdateCommand="UPDATE Contact SET FirstName=@FirstName,
LastName=@LastName, Company=@Company WHERE equenceOrderId=@SequenceOrderId"
href="mailtoequenceOrderId=@SequenceOrderId">SequenceOrderId=@SequenceOrderId"
/>

<asp:GridView
RunAt="server"
ID="GridViewContact"
AutoGenerateColumns=false
AutoGenerateEditButton=true
DataKeyField="SequenceOrderId"
AllowPaging="true"
AllowSorting="true"
ContactGridViewPage.aspx.cs
public string DatabaseConnectionString = "Provider=SQLOLEDB;Data
Source=localhost;Integrated Security=SSPI;Initial Catalog=WordEngineering;";
SqlDataSourceContact.ConnectionString = DatabaseConnectionString;
GridViewContact.DataSourceID = SqlDataSourceContact.ID;

 

[Ken Adeniji]

Must declare the scalar variable '@FirstName', occurs whem the user clicks
the update button in the edit mode.