public Ad_UpdateCourse(Ad_CourseManage parent, string cid, string cname, string cterm, string cpoint, string ctime, string cquality) { InitializeComponent(); pform = parent; tbox_cid.Text = cid; tbox_cname.Text = cname; tbox_credit.Text = cpoint; cbox_term.Text = cterm; tbox_hour.Text = ctime; cbox_feature.Text = cquality; oldcid = cid.Trim(); string sql = "select distinct cquality from courses"; if (Ad_CourseManage.ExecuteSql(sql) != 0) { this.cbox_feature.DataSource = Ad_CourseManage.Query(sql).Tables["courses"]; cbox_feature.DisplayMember = "cquality"; } string sql1 = "select distinct cterm from courses"; if (Ad_CourseManage.ExecuteSql(sql) != 0) { this.cbox_term.DataSource = Ad_CourseManage.Query(sql1).Tables["courses"]; cbox_term.DisplayMember = "cterm"; } }
private void btn_course_Click(object sender, EventArgs e) { Ad_CourseManage childrenForm = new Ad_CourseManage(this); childrenForm.Owner = this; this.Hide(); childrenForm.Show(); }
public Ad_CourseManage(LoginIn_Ad parent) { InitializeComponent(); pform = parent; string sql = "select distinct cterm from courses"; if (Ad_CourseManage.ExecuteSql(sql) != 0) { this.cbox_term.DataSource = Ad_CourseManage.Query(sql).Tables["courses"]; cbox_term.DisplayMember = "cterm"; } }
private void btn_confirm_Click(object sender, EventArgs e) { string newcid = tbox_cid.Text.Trim(); string cname = tbox_cname.Text.Trim(); string cterm = cbox_term.Text; string cpoint = tbox_credit.Text.Trim(); string ctime = tbox_hour.Text.Trim(); string cquality = cbox_feature.Text; string sql = "update courses set cid = '" + newcid + "',cname='" + cname + "',cterm=" + int.Parse(cterm) + ",cpoint=" + int.Parse(cpoint) + ",ctime =" + int.Parse(ctime) + ",cquality ='" + cquality + "' where cid = '" + oldcid + "'"; if (Ad_CourseManage.ExecuteSql(sql) != 0) { MessageBox.Show("修改成功!"); } this.pform.Show(); this.Close(); }
private void btn_confirm_Click(object sender, EventArgs e) { string cid = tbox_cid.Text.Trim(); string cname = tbox_cname.Text.Trim(); string cpoint = tbox_credit.Text.Trim(); string cterm = cbox_term.Text; string cquality = cbox_feature.Text; string ctime = tbox_hour.Text.Trim(); //SQL添加数据语句字符串 string sql = "insert into courses(cid,cname,cterm,cpoint,ctime,cquality) values('" + cid + "','" + cname + "'," + int.Parse(cterm) + "," + int.Parse(cpoint) + "," + int.Parse(ctime) + ",'" + cquality + "')"; if (Ad_CourseManage.ExecuteSql(sql) != 0)//向源数据库传递并执行SQL语句 { MessageBox.Show("添加课程信息成功!"); } this.pform.Show(); this.Close(); }