private void Button2_Click(object sender, EventArgs e) { using (var context = new MSGCPAEntities1()) { var commandText = "UPDATE Remark SET remark='" + txt_Remark.Text.ToString() + "' where remark_Id='" + id.ToString() + "'"; context.Database.ExecuteSqlCommand(commandText); } clear(); MessageBox.Show("Updated Sucessfully"); PopulateDataGridView(); }
private void Btn_Update_Click(object sender, EventArgs e) { using (var context = new MSGCPAEntities1()) { var commandText = "UPDATE Section SET section1='" + txt_Section.Text.ToString() + "' where section_Id='" + id.ToString() + "'"; context.Database.ExecuteSqlCommand(commandText); } clear(); MessageBox.Show("Updated Sucessfully"); PopulateDataGridView(); }
private void Btn_Update_Click(object sender, EventArgs e) { using (var context = new MSGCPAEntities1()) { var commandText = "UPDATE Examination SET examination_Type='" + txt_Exam.Text.ToString() + "' where examination_Id='" + id.ToString() + "'"; //var name = new SqlParameter("@CategoryName", "Test"); context.Database.ExecuteSqlCommand(commandText); } clear(); MessageBox.Show("Updated Sucessfully"); PopulateDataGridView(); }
private void Btn_Update_Click(object sender, EventArgs e) { using (var context = new MSGCPAEntities1()) { var commandText = "UPDATE Result SET examination_Type='" + cmb_Exam.Text.ToString() + "',subject='" + cmb_Subject.Text.ToString() + "',marks_Obtained='" + txt_OM.Text.ToString() + "' where result_Id='" + id.ToString() + "'"; context.Database.ExecuteSqlCommand(commandText); } clear(); MessageBox.Show("Updated Sucessfully"); PopulateDataGridView(); }
private void btn_Imp_Click(object sender, EventArgs e) { OpenFileDialog open = new OpenFileDialog(); open.Filter = "Excel Files|*.xls;.xlsx;*.xlsm"; if (open.ShowDialog() == DialogResult.Cancel) { return; } FileStream stream = new FileStream(open.FileName, FileMode.Open); IExcelDataReader reader = ExcelReaderFactory.CreateOpenXmlReader(stream); DataSet result = reader.AsDataSet(); MSGCPAEntities1 db = new MSGCPAEntities1(); foreach (DataTable table in result.Tables) { foreach (DataRow dr in table.Rows) { Student std = new Student() { // student_Id=Convert.ToInt32(dr[0]), // full_Name=Convert.ToString(dr[1]), // grade=Convert.ToString(dr[9]), // section=Convert.ToString(dr[10]), // roll_No=Convert.ToInt32(dr[11]), // address=Convert.ToString(dr[2]), // // DOB=Convert.ToString(dr[6]), // parents_Name=Convert.ToString(dr[6]), // parent_Phone=Convert.ToString(dr[8]) student_Id = Convert.ToInt32(dr[0]), full_Name = Convert.ToString(dr[1]), grade = Convert.ToString(dr[2]), section = Convert.ToString(dr[3]), //roll_No = Convert.ToInt32(dr[4]), address = Convert.ToString(dr[5]), // DOB=Convert.ToString(dr[6]), parents_Name = Convert.ToString(dr[7]), parent_Phone = Convert.ToString(dr[8]) }; db.Student.Add(std); } } db.SaveChanges(); reader.Close(); stream.Close(); MessageBox.Show("Saved Successfully"); }