private void button1_Click(object sender, EventArgs e) { String c_no = cno.Text.Trim(); String o_ono = ono.Text.Trim(); String o_khxm = khxm.Text.Trim(); String o_khsj = khsj.Text.Trim(); String o_khdz = khdz.Text.Trim(); String o_yb = yb.Text.Trim(); String o_dgsj = dgsj.Value.ToString("yyyy-MM-dd HH:mm:ss"); String o_dgsl = dgsl.Text.Trim(); String o_dj = dj.Text.Trim(); String o_dgzje = dgzje.Text.Trim(); String sql = string.Format("update [order] set ono='{0}',cno='{1}',khxm='{2}',khsj='{3}',khdz='{4}',yb='{5}',dgsj='{6}',dgsl='{7}',dj='{8}',dgzje='{9}' where ono='{10}'", o_ono, c_no, o_khxm, o_khsj, o_khdz, o_yb, o_dgsj, o_dgsl, o_dj, o_dgzje, oid); try { cmd = new SqlCommand(sql, conn); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("信息修改成功"); shangping sp = new shangping(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "请检查数据合法性!"); } }
private void button1_Click(object sender, EventArgs e) { conn.Open(); String sql = "insert into [order](ono,cno,khxm,khsj,khdz,yb,dgsj,dgsl,dj,dgzje) values (@ono,@cno,@khxm,@khsj,@khdz,@yb,@dgsj,@dgsl,@dj,@dgzje)"; try { SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@ono", int.Parse(ono.Text))); cmd.Parameters.Add(new SqlParameter("@cno", int.Parse(cno.Text))); cmd.Parameters.Add(new SqlParameter("@khxm", khxm.Text)); cmd.Parameters.Add(new SqlParameter("@khsj", khsj.Text)); cmd.Parameters.Add(new SqlParameter("@khdz", khdz.Text)); cmd.Parameters.Add(new SqlParameter("@yb", yb.Text)); cmd.Parameters.Add(new SqlParameter("@dgsj", DateTime.Parse(dgsj.Text))); cmd.Parameters.Add(new SqlParameter("@dgsl", dgsl.Text)); cmd.Parameters.Add(new SqlParameter("@dj", dj.Text)); cmd.Parameters.Add(new SqlParameter("@dgzje", dgzje.Text)); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { MessageBox.Show("信息录入成功"); shangping sp = new shangping(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "请检查数据合法性!"); } }
private void button1_Click(object sender, EventArgs e) { conn.Open(); String sql = "insert into Supplier(sname,contacts,phone,synopsis) values (@sname,@contacts,@phone,@synopsis)"; try { SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@sname", sname.Text)); cmd.Parameters.Add(new SqlParameter("@contacts", contacts.Text)); cmd.Parameters.Add(new SqlParameter("@phone", phone.Text)); cmd.Parameters.Add(new SqlParameter("@synopsis", synopsis.Text)); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { MessageBox.Show("信息录入成功"); shangping sp = new shangping(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "请检查数据合法性!"); } }
private void button1_Click(object sender, EventArgs e) { String t_name = tname.Text.Trim(); String t_picture = tpicture.Text.Trim(); String sql = string.Format("update type set tname='{0}',tpicture='{1}' where tname='{2}'", t_name, t_picture, name); try { cmd = new SqlCommand(sql, conn); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("信息修改成功"); shangping sp = new shangping(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "请检查数据合法性!"); } }
private void button1_Click(object sender, EventArgs e) { conn.Open(); String sql = "insert into type(tname,tpicture) values (@tname,@tpicture)"; try { SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@tname", tname.Text)); cmd.Parameters.Add(new SqlParameter("@tpicture", tpicture.Text)); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { MessageBox.Show("信息录入成功"); shangping sp = new shangping(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "请检查数据合法性!"); } }
private void button1_Click(object sender, EventArgs e) { String s_name = sname.Text.Trim(); String s_contacts = contacts.Text.Trim(); String s_phone = phone.Text.Trim(); String s_synopsis = synopsis.Text.Trim(); String sql = string.Format("update Supplier set sname='{0}',contacts='{1}',phone='{2}',synopsis='{3}' where sname='{4}'", s_name, s_contacts, s_phone, s_synopsis, name); try { cmd = new SqlCommand(sql, conn); int count = cmd.ExecuteNonQuery(); if (count > 0) { MessageBox.Show("信息修改成功"); shangping sp = new shangping(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "请检查数据合法性!"); } }