CREATE PROCEDURE  MySampleUpdate(
@studentno char(10) OUTPUT;
@studentname char(15);
@studentsex   char(2);
@studentbirthday char(8);
@studentpassword char(10);
@studentdepartmentno char(10);
@studentdepartmentname char(20);
@studentclass char(10);
@education char(10) )
AS
update tblstudentinformation set
   studentname=@studentname,
   studentsex=@studentsex,
   studentbirthday=@studentbirthday,
studentpassword=@studentpassword,
studentdepartmentno=@studentdepartmentno, studentdepartmentname=@studentdepartmentname,
studentclass=@studentclass,
  education=@education
  FROM tblstudentinformation WHERE studentno=@studentno
 GO
C#提示C:\Inetpub\MySite\webapps\student.aspx.cs(221): 应输入 ;
其他错误类似

解决方案 »

  1.   

    CREATE PROCEDURE " MySampleUpdate"(
    @studentno char(10)OUTPUT;
    @studentname char(15);
    @studentsex   char(2);
    @studentbirthday char(8);
    @studentpassword char(10);
    @studentdepartmentno char(10);
    @studentdepartmentname char(20);
    @studentclass char(10);
    @education char(10) )
    AS
      

  2.   

    CREATE PROCEDURE  MySampleUpdate(
    @studentno char(10)OUTPUT;
    @studentname char(15);
    @studentsex   char(2);
    @studentbirthday char(8);
    @studentpassword char(10);
    @studentdepartmentno char(10);
    @studentdepartmentname char(20);
    @studentclass char(10);
    @education char(10) )这一部分的分号都是逗号吧!