摘要：create proc proc_Page(@pageIndex int,@pageSize int,@Count int output)asbegin declare @start int = (@pageIndex-1)*@pageSize +1 declare @end int = @page 阅读全文

摘要：添加存储过程 if OBJECT_ID('P_add') is not nulldrop proc P_addgocreate proc P_add--参数@UserName varchar(100),@UserPwd varchar(100),@UserSex int,@UserDate date 阅读全文

摘要：分页存储过程--判断存储过程是否存在if OBJECT_ID('proc_Page') is not null--删除存储过程drop proc proc_Pagego--创建存储过程create proc proc_Page--参数@ClaId int=0, --班级Id@Sage datetim 阅读全文

摘要：public class DBHelper { //连接数据库 static SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=IOT1706B;Integrated Security=True"); stat 阅读全文