예제 #1
0
 public StoredProcedure getQuestion_hot(int startRowIndex,int endRowIndex,int toalCount)
 {
     StoredProcedure sp=new StoredProcedure("getQuestion_hot",this.Provider);
     sp.Command.AddParameter("startRowIndex",startRowIndex,DbType.Int32);
     sp.Command.AddParameter("endRowIndex",endRowIndex,DbType.Int32);
     sp.Command.AddParameter("toalCount",toalCount,DbType.Int32);
     return sp;
 }
예제 #2
0
파일: ExecuteSql.cs 프로젝트: zzmy/chatroom
 //执行sql命令,返回数据在DataTable对象
 public int run(DataTable table, string sqlText)
 {
     Debug.Assert(sproc == null);
     sproc = new StoredProcedure(sqlText);
     int flag  = sproc.Run(table);
     this.ErrorMessage = sproc.ErrorMessage;
     sproc.Dispose();
     sproc = null;
     return flag;
 }