private void btnSave_Click(object sender, EventArgs e) { if (dgvTempStd.Rows.Count > 0) { if (DialogResult.Yes == MessageBox.Show("Are you sure want to save these data?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { Model.DBSchoolEntities db = new Model.DBSchoolEntities(); foreach (DataGridViewRow dr in dgvTempStd.Rows) { Model.tblStd std = new Model.tblStd() { BrId = null, SchoolId = 1, StdName = dr.Cells["StdName"].Value.ToString() }; db.tblStds.Add(std); } db.SaveChanges(); } GLOBAL.GLOBALMETHODS.SHOW_MESSAGEBOX(Resources.msgs.SaveRecord, Resources.msgs.SaveRecordTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { GLOBAL.GLOBALMETHODS.SHOW_MESSAGEBOX("Please Add atleast one Standrad.", "Required", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void BindStds() { Model.DBSchoolEntities db = new Model.DBSchoolEntities(); var tblStds = db.tblStds; DataTable dt = new DataTable(); dt.Columns.Add("StdName"); dt.Columns.Add("StdId"); foreach (var dr in tblStds) { DataRow drdt = dt.NewRow(); drdt["StdName"] = dr.StdName; drdt["StdId"] = dr.StdId; dt.Rows.Add(drdt); } dgvStd.DataSource = dt; }