public void Fill() { this.Clear(); DataTable dataTable = Interviewer_Dal.GetDataTable(); DataRow dataRow; Interviewer interviewer; for (int i = 0; i < dataTable.Rows.Count; i++) { dataRow = dataTable.Rows[i]; interviewer = new Interviewer(dataRow); if (interviewer.DBId != 0) { Add(interviewer); } } }
public static void FillDataSet(DataSet dataSet, string orderBy) { Dal.FillDataSet(dataSet, tableName, orderBy); Interviewer_Dal.FillDataSet(dataSet); DataRelation dataRelationNomineeScoreType_Interviewer = new DataRelation( "NomineeScoreType_Interviewer" , dataSet.Tables[Interviewer_Dal.tableName].Columns["ID"] , dataSet.Tables[tableName].Columns["Interviewer"]); dataSet.Relations.Add(dataRelationNomineeScoreType_Interviewer); Nominee_Dal.FillDataSet(dataSet); DataRelation dataRelationNomineeScoreType_Nominee = new DataRelation( "NomineeScoretype_Nominee" , dataSet.Tables[Nominee_Dal.tableName].Columns["Id"] , dataSet.Tables[tableName].Columns["Nominee"]); dataSet.Relations.Add(dataRelationNomineeScoreType_Nominee); ScoreType_Dal.FillDataSet(dataSet); DataRelation dataRelationNomineeScoreType_ScoreType = new DataRelation( "NomineeScoretype_ScoreType" , dataSet.Tables[ScoreType_Dal.tableName].Columns["Id"] , dataSet.Tables[tableName].Columns["ScoreType"]); dataSet.Relations.Add(dataRelationNomineeScoreType_ScoreType); }