John Palmer says: DataSet fullRolesDS = SqlHelper.ExecuteDataset(ConnString,CommandType.StoredProcedure,SP_NAME, StoredProcParams); John Palmer says: this._classSummaryDataSet = new InfoPackages.ClassSummaryDataSet(); this._classSummaryDataSet.EnforceConstraints = false; John Palmer says: SqlHelper.FillDataset(Properties.Settings.Default.DatabaseConnectionString, "usp_ClassSummaryDataSetCol", this._classSummaryDataSet, new string[] { "Classes", "Students", "Products", "Prizes", "PrizeStatus", "Items", "ProductSummary" }, this.ContractID); John Palmer says: this.DataSource = this._classSummaryDataSet.Items; John Palmer says: private void StudentHeader_Format(object sender, System.EventArgs eArgs) { int studentId = (int)txtStudentName.Value; //this.Fields["StudentID"].Value; InfoPackages.ClassSummaryDataSet.StudentsRow studentRow = this._classSummaryDataSet.Students.FindByStudentID(studentId); txtStudentName.Text = studentRow.strStudentName; John Palmer says: txtStudentRank.Text = studentRow.intRank.ToString(); John Palmer says: C:\SourceCode\1.DEV\GA\Aplus\Library\Reports\ClassSummary\ClassSummaryReport.cs John Palmer says: C:\SourceCode\1.DEV\GA\Aplus\Library\InfoPackages\ClassSummaryDataSet.xsd