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");
}
