private void frm_Barcordes_Load(object sender, EventArgs e) { // load all student course registration IDs try { gridBarcode.DataSource = null; var source = RegistrationCodesDataAccess.getBarcodes(); //gridBarcode.DataSource = source // .Select(x => new // { // StudentID = x.StudentId, // StudentName = x.StudentName, // CourseId = x.CourseId, // CourseName = x.CourseName, // RegistrationId = x.RegistrationId, // IssuedDate = x.IssuedDate, // IssuedBy = x.IssuedBy // }); gridBarcode.DataSource = source; gridBarcode.Columns["StudentId"].HeaderText = "Student ID"; gridBarcode.Columns["StudentName"].HeaderText = "Student Name"; gridBarcode.Columns["CourseId"].HeaderText = "Course ID"; gridBarcode.Columns["CourseName"].HeaderText = "Course Name"; gridBarcode.Columns["RegistrationId"].HeaderText = "Course Registration ID"; gridBarcode.Columns["IssuedDate"].HeaderText = "Issued Date"; gridBarcode.Columns["IssuedBy"].HeaderText = "Issued By"; } catch (Exception ex) { MessageBox.Show("Failed : " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }