public virtual int FillBy(pyatLevelDS.tbluserinfoDataTable dataTable, int userid) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(userid));
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(pyatLevelDS.tblphoneNumbersDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillBy(pyatLevelDS.tbluserDataTable dataTable, string username, string password, string EmailID) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     if ((username == null)) {
         throw new global::System.ArgumentNullException("username");
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = ((string)(username));
     }
     if ((password == null)) {
         throw new global::System.ArgumentNullException("password");
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(password));
     }
     if ((EmailID == null)) {
         throw new global::System.ArgumentNullException("EmailID");
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = ((string)(EmailID));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }