private void button1_Click(object sender, EventArgs e)
{
CourseInfoData data = new CourseInfoData();
data.Kcid = txtKcid.Text;
data.Kcname = txtKcname.Text;
data.Periodexpriment = int.Parse(txtPeriodexpriment.Text);
data.Periodteaching = int.Parse(txtPeriodteaching.Text);
data.Credit = float.Parse(txtCredit.Text);
data.Coursetype = txtCoursetype.Text;
if (txtKcid.Text == "" || txtKcid.Text == null)
{
MessageBox.Show("课程编号不能为空");
txtKcid.Focus();
return;
}
Classes.CourseInfoOperation op = new Classes.CourseInfoOperation();
if (op.InsertCourseInfo(data))
{
MessageBox.Show("插入成功");
}
else
{
MessageBox.Show("失败");
}
}
DataSet Bind()
{
CourseInfoData data = new CourseInfoData();
data.Kcid = txtKcid.Text;
data.Kcname = txtKcname.Text;
Classes.CourseInfoOperation op = new Classes.CourseInfoOperation();
ds = op.GetCourseInfo(data);
return(ds);
}
//删除
private void button3_Click(object sender, EventArgs e)
{
string kcid = txtKcid1.Text;
Classes.CourseInfoOperation op = new Classes.CourseInfoOperation();
if (op.DeleteCourse(kcid))
{
MessageBox.Show("成功");
}
else
{
MessageBox.Show("失败了");
}
dataGridView1.DataSource = Bind().Tables[0];
}
//修改
private void button2_Click(object sender, EventArgs e)
{
CourseInfoData data = new CourseInfoData();
data.Kcid = txtKcid1.Text;
data.Kcname = txtKcname1.Text;
data.Periodexpriment = int.Parse(txtPeriodexpriment1.Text);
data.Periodteaching = int.Parse(txtPeriodteaching1.Text);
data.Credit = float.Parse(txtCredit1.Text);
data.Coursetype = txtCoursetype1.Text;
Classes.CourseInfoOperation op = new Classes.CourseInfoOperation();
if (op.UpdateCourse(data))
{
MessageBox.Show("成功");
}
else
{
MessageBox.Show("失败了");
}
dataGridView1.DataSource = Bind().Tables[0];
}