winForm常规操作.docxVIP

DBHelper类class DBHelper{ String connstr = Data Source=.;Initial Catalog=FlowerSys;User ID=sa; SqlConnection conn; //封装数据库对象 public SqlConnection Conn { get { if (conn == null) { conn = new SqlConnection(connstr); } return conn; } } //打开数据库连接 public void OpenConn() { if (Conn.State == ConnectionState.Broken) { Conn.Close(); Conn.Open(); } else if (Conn.State == ConnectionState.Closed) { Conn.Open(); } } //关闭数据库连接 public void CloseConn() { if (Conn.State == ConnectionState.Broken || Conn.State == ConnectionState.Open) { Conn.Close(); } }}连接式 增，删，改//sql代码使用string.Format()方法组合出。 string sql = string.Format(update FlowerSale set SaleCount={0},SalePrice={1}, Remark={2} where SaleId={3}, txtCount.Text.Trim(), txtPrice.Text.Trim(), txtRemark.Text.Trim(), Id); try { db.OpenConn();//连接数据库 //生成Command对象将sql语句和连接对象传入 SqlCommand comm = new SqlCommand(sql, db.Conn); //调用ExecuteNonQuery()方法执行sql操作并返回受影响的行数 int num = comm.ExecuteNonQuery(); if (num == 1) { MessageBox.Show(更新成功！); } else { MessageBox.Show(更新失败！); } } catch (Exception ex) { MessageBox.Show(ex.Message);//发生异常时显示错误信息 } finally { db.CloseConn();//关闭数据库连接 } this.Close();//更新完之后关闭连接式 查询操作string sql = select fs.SaleId,fs.SaleCount,fs.SalePrice,fs.Remark from FlowerSale as fs where fs.SaleId= + Id; SqlDataReader reader = null;//声明一个对象用来保存查询结果 try { db.OpenConn();//打开连接 SqlCommand comm = new SqlCommand(sql, db.Conn); //查询操作使用ExecuteReader()方法，注意返回结果为SqlDataReader类型 reader = comm.ExecuteReader(); //循环获取查询内容 while (reader.Read()) { lblNo.Text = reader[SaleId].ToString(); txtCount.Text = reader[SaleCount].ToString(); txtPrice.Text = reader[SalePrice].ToString(); txtRemark.Text = reader[Remark].ToString(); } } catch (Exception ex) { //发生异常时显示错误信息 MessageBox.Show(ex.Message); } finally { reader.Close();//关闭SqlDataReader。 db.CloseConn();//关闭连接 }非空验证foreach (Control item in this.Controls) { if (item is TextBox) { if (item.Text.Trim() == string.Empty) { MessageBox.Show(请输入所有手机信息); return; } } }断开式 comboBox数据绑定//查询语句 String sql = sele