C# (CSharp) QLKSDataSet_DoanhThu.SP_DOANH_THUDataTable Examples

Example #1

File: QLKSDataSet_DoanhThu.Designer.cs Project: haodophuc/etak4

 public virtual QLKSDataSet_DoanhThu.SP_DOANH_THUDataTable GetData(global::System.Nullable <int> YEAR)
 {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((YEAR.HasValue == true))
     {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(YEAR.Value));
     }
     else
     {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     QLKSDataSet_DoanhThu.SP_DOANH_THUDataTable dataTable = new QLKSDataSet_DoanhThu.SP_DOANH_THUDataTable();
     this.Adapter.Fill(dataTable);
     return(dataTable);
 }

Example #2

File: QLKSDataSet_DoanhThu.Designer.cs Project: haodophuc/etak4

        public virtual int Fill(QLKSDataSet_DoanhThu.SP_DOANH_THUDataTable dataTable, global::System.Nullable <int> YEAR)
        {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((YEAR.HasValue == true))
            {
                this.Adapter.SelectCommand.Parameters[1].Value = ((int)(YEAR.Value));
            }
            else
            {
                this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
            }
            if ((this.ClearBeforeFill == true))
            {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);

            return(returnValue);
        }