private void btdelete_Click(object sender, EventArgs e)
{
Student_Info si = new Student_Info();
int id = (int)cbid.SelectedValue;
var del = (from t in db.Student_Info where t.Roll_No == id select t).SingleOrDefault();
db.Student_Info.Remove(del);
var result = db.SaveChanges();
if (result > 0)
{
MessageBox.Show("Data Deleted..");
}
this.student_InfoTableAdapter.Fill(this.assignmentDBDataSet.Student_Info);
}
private void btadd_Click(object sender, EventArgs e)
{
string name = txtname.Text;
DateTime dob = DateTime.Parse(dtpdob.Value.ToString());
string gender = null;
if (rbmale.Checked)
{
gender = rbmale.Text;
}
if (rbfemale.Checked)
{
gender = rbfemale.Text;
}
//string dept = cbdept.SelectedItem.ToString();
string course = cbcourse.SelectedItem.ToString();
string semester = cbsemester.SelectedItem.ToString();
string address = txtaddress.Text;
string phonenumber = txtphonenumber.Text;
Student_Info si = new Student_Info();
si.Name = name;
si.Dob = dob;
si.Gender = gender;
si.Course = course;
si.Semester = semester;
si.Address = address;
si.PhoneNumber = phonenumber;
db.Student_Info.Add(si);
var data = db.SaveChanges();
if (data > 0)
{
MessageBox.Show("Data inserted...");
}
else
{
MessageBox.Show("Data Not Inserted...");
}
}
