mistake is
@SerialNo
instead of
@SerilNo
hiii guys we can write stored procedure for this we can avoid this type of error...............
we can use stored procedures also
Create procedure updateproc(@No int,@Date varchar(50) ,@From varchar(50) ,@IssueDate varchar(50) ,@FlightNo varchar(50) ,@ClassBasis varchar(50) ,@Issuer varchar(50) ,@SerialNo varchar(50))
As
Begin
Update [Ticket] Set No = @No, Date = @Date, [From] = @From, [To] = @To, IssueDate = @IssueDate, FlightNo = @FlightNo, ClassBasis = @ClassBasis, Issuer = @Issuer, Code = @Code, Form = @Form, SerialNo = @SerialNo Where No = @No"
end