Hi! please see this code it gives runtime error:Must declare the scalar variable "@LastName".


SqlDataSource datasource1 = new SqlDataSource();
datasource1.ConnectionString = WebConfigurationManager.ConnectionStrings["connectionstring1"].ConnectionString;


datasource1.UpdateCommand = "Update [Employees] Set [LastName]=@LastName, [FirstName]=@FirstName where [EmployeeID]=@EmployeeID";

datasource1.UpdateParameters.Add("@LastName", "James");
datasource1.UpdateParameters.Add("@FirstName", "Jimmy");
datasource1.UpdateParameters.Add("@EmployeeID",Tex tBox1.Text.ToString() );

datasource1.Update();


Please tell me where i am wrong???