private void btnClassQuery_Click(object sender, EventArgs e) { Class queryobject = new Class(); if (!String.IsNullOrEmpty(txtClassID.Text)) { queryobject.Class_id = int.Parse(txtClassID.Text); } queryobject.ClassDescription = txtClassDescription.Text; queryobject.ClassName = txtClassName.Text; List<object> dataRet = queryobject.get(); List<Class> data = new List<Class>(); foreach (object o in dataRet) { data.Add(o as Class); } var _bind = data.Select(a => new { ClassID = a.Class_id, ClassName = a.ClassName, ClassDescription = a.ClassDescription, }).ToList(); dataGridClass.DataSource = _bind; utility.AddDeleteAndEditButton(dataGridClass); // Link for getting buttons working as part of grid. // http://stackoverflow.com/questions/10769316/add-a-button-in-a-new-column-to-all-rows-in-a-datagrid dataGridClass.Update(); }
private void btnAddClass_Click(object sender, EventArgs e) { // Create Object Class newObj = new Class(); newObj.ClassDescription = txtClassDescription.Text; newObj.ClassName = txtClassName.Text; // Assign read form's fields to object's fields // Call Save newObj.save(); // http://tech.pro/tutorial/776/csharp-tutorial-binding-a-datagridview-to-a-collection this.Close(); }
/// <summary> /// Object Specific function /// </summary> /// <param name="dr"></param> /// <returns></returns> public override object convertFromReader(OleDbDataReader dr) { Class gotFromDB = new Class(); gotFromDB.Class_id = int.Parse(dr[DatabaseCoachingInst.Class.Class_id.ToString()].ToString()); gotFromDB.ClassDescription = dr[DatabaseCoachingInst.Class.ClassDescription.ToString()].ToString(); gotFromDB.ClassName = dr[DatabaseCoachingInst.Class.ClassName.ToString()].ToString(); // write similar code for other fields. return gotFromDB; }