非连接模型DataSet下的增删改

//添加的方法
private void AddStudeng()
{
//为Student表新建数据行
DataRow dr = ds.Tables[“Student”].NewRow();
dr[“SNO”] = txtSNO.Text;
dr[“SName”] = txtSName.Text;
ds.Tables[“Student”].Rows.Add(dr);//向dataSet数据库中添加新的行
//更新Set数据库中数据到SQL
//2.定义查询语句
string sql = “insert into Student(SNO,SName) Values({0},’{1}’)”;
sql = string.Format(sql, txtSNO.Text, txtSName.Text);
//3.实例化cmd
SqlCommand cmd = new SqlCommand(sql, conn);
//4.实例化dataAdpter
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.InsertCommand = cmd;
//打开链接conn
conn.Open();
//提交
sda.Fill(ds, “Student”);
//关闭
conn.Close();
}
//更改的方法
private void UpdataStudent()
{
//1.首先修改Set数据库
//1.1实例化指定的行
DataRow dr = ds.Tables[“Student”].Rows.Find(txtSNO.Text);//指定行
if (dr!=null)
{
dr.BeginEdit();
dr[“SName”] = txtSName.Text;
dr.EndEdit();
}
//2.更新Set数据库到SQL
//2.1定义查询语句
string sql = “Update Student Set SName=’{1}’ where SNO={0}”;
sql = string.Format(sql, txtSNO.Text, txtSName.Text);
//2.2实例化cmd
SqlCommand cmd = new SqlCommand(sql, conn);
//2.3实例化dataAdepter
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.UpdateCommand = cmd;
//2.4打开conn
conn.Open();
//2.5将Set更新到sql
sda.Fill(ds, “Student”);
//关闭conn
conn.Close();
}
//删除的方法
private void DeleteStudent()
{
//定义接收SNO删除之前所选的SNO的信息
string sno = txtSNO.Text.Trim();
//1删除Set中数据
//1.1定义指定的行然后调用Delete的方法进行删除
ds.Tables[“Student”].Rows.Find(txtSNO.Text).Delete();
//2.更新数据到Sql
//2.1定义SQL语句
string sql = “delete from Student where SNO={0}”;
sql = string.Format(sql, sno);
//实例化cmd
SqlCommand cmd = new SqlCommand(sql, conn);
//实例化sqlA
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.DeleteCommand = cmd;
//打开
conn.Open();
//执行
sda.Fill(ds, “Student”);
//关闭
conn.Close();
}