求SqlDataAdapter.DeleteCommand和SqlCommandBuilder用法代码。删除特定的一行记录。

[不懂必须要问]

求SqlDataAdapter.DeleteCommand和SqlCommandBuilder用法代码。删除特定的一行记录。

[wuyq11]

http://blog.csdn.net/ifan_net/archive/2006/11/10/1378466.aspx

[wuyq11]

SqlConnection conn = new SqlConnection("Server=local;uid=sa;pwd=sa;database=Northwind");
string qry = @"select * from employees where country='china'";
string del = @"delete from employees where employeeid=@employeeid";
try
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(qry,conn);
DataSet ds = new DataSet();
da.Fill(ds,"Employees");
DataTable dt=ds.Tables["employees"];

SqlCommand cmd = new SqlCommand(del,conn);
cmd.Parameters.Add("@employeeid",SqlDbType.Int,4,"employeeid");
string filter = @"xingm='wang'";
foreach (DataRow row in dt.Select(filter))
{
row.Delete();
}
da.DeleteCommand = cmd;
da.Update(ds,"employees");
foreach (DataRow row in dt.Rows)
{

}
}
catch (SqlException ex)
{
Console.WriteLine("The error:{0}", ex.Message);
}
finally
{
conn.Close();
} Console.ReadLine();
}

[不懂必须要问]

朋友，是删除哦。

[快40的码农]

二楼对的.