コード例 #1
0
 public virtual ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable GetAllDataBy(int sessionID, global::System.Nullable<int> Reg_Year, global::System.Nullable<int> Reg_Term, int isTheory) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(sessionID));
     if ((Reg_Year.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(Reg_Year.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((Reg_Term.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((int)(Reg_Term.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     this.Adapter.SelectCommand.Parameters[3].Value = ((int)(isTheory));
     ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable dataTable = new ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #2
0
 public virtual ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable GetDataBy(int SessionID, int CourseID) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(SessionID));
     this.Adapter.SelectCommand.Parameters[1].Value = ((int)(CourseID));
     ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable dataTable = new ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
コード例 #3
0
 public virtual ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable GetData() {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable dataTable = new ResultCourseWiseDataSet.ResultCourseWiseDataTableDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }