winform 增删节查

winform 增删改查

增删改，是一个样的指令：

?//添加物品
??????????? try
??????????? {
??????????????? gmyConn = gmyConn == null ? mySqlConnection.GetConn() : gmyConn;
??????????????? SqlCommand cmd2 = gmyConn.CreateCommand();
??????????????? cmd2.CommandText = string.Format("insert into H_Acticle (ActicleName,ActicleNB,WorkShop,ActicleValidDate,TypeId,ActicleNote,ActicleEnglishName) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", ActicleName, ActicleNB, WorkShop, ActicleValidDate, typeId, ActicleNote, ActicleEnglishName);
??????????????? int i = cmd2.ExecuteNonQuery();//增加，删除，修改
??????????????? if (i == 1)
??????????????? {
??????????????????? MessageBox.Show("添加成功！");
??????????????????? this.DialogResult = DialogResult.OK;
??????????????????? return;

??????????????? }
??????????????? else
??????????????? {
??????????????????? MessageBox.Show("添加失败！");
??????????????????? this.DialogResult = DialogResult.OK;
??????????????????? return;
??????????????? }
??????????? }
??????????? catch (Exception ex)
??????????? {
??????????????? MessageBox.Show("系统错误" + ex.Message);

??????????? }

?

查询

? try
??????????????? {
??????????????????? gmyConn = gmyConn == null ? mySqlConnection.GetConn() : gmyConn;
??????????????????? //命令对象
??????????????????? SqlCommand cmd = gmyConn.CreateCommand();
??????????????????? cmd.CommandText = "select * from table1";
??????????????????? using (SqlDataReader reader = cmd.ExecuteReader())
??????????????????? {
??????????????????????? if (reader.Read()) //while循环读取数据行,得到是一个集合，如果是if,就是得到的一条数据了
??????????????????????? {
??????????????????????????? typeId = Convert.ToInt32(reader["TypeId"]); //读取当前行的第1列的数据

??????????????????????? }
??????????????????? }
??????????????? }
??????????????? catch (Exception ex)
??????????????? {
??????????????????? MessageBox.Show("系统故障！" + ex.Message);
??????????????????? return;
??????????????? }