增删改,是一个样的指令:
//添加物品
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;
}