StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("Insert into Students");
sqlBuilder.Append("(StudentName,StudentIdNo,Gender,Birthday,CardNo,");
sqlBuilder.Append("Age,PhoneNumber,StudentAddress,ClassId,StuImage)");
sqlBuilder.Append(" values(@StudentName,@StudentIdNo,@Gender,@Birthday,");
sqlBuilder.Append("@CardNo,@Age,@PhoneNumber,@StudentAddress,@ClassId,@StuImage)");
sqlBuilder.Append(";select @@Identity");
sqlBuilder.Append("Insert into Students");
sqlBuilder.Append("(StudentName,StudentIdNo,Gender,Birthday,CardNo,");
sqlBuilder.Append("Age,PhoneNumber,StudentAddress,ClassId,StuImage)");
sqlBuilder.Append(" values(@StudentName,@StudentIdNo,@Gender,@Birthday,");
sqlBuilder.Append("@CardNo,@Age,@PhoneNumber,@StudentAddress,@ClassId,@StuImage)");
sqlBuilder.Append(";select @@Identity");