结果集更新

XuguConnection conn = new XuguConnection();
conn.ConnectionString = conn_xugu;

try
{
    conn.Open();
    XuguCommand cmd = new XuguCommand();
    cmd.Connection = conn;
    string sql_sql = "select * from tp";
    XuguDataAdapter adapter = new XuguDataAdapter();
    adapter.SelectCommand = new XuguCommand(queryString, conn);
    string tableName = "tp";
    DataSet dataSet = new DataSet();
    adapter.Fill(dataSet, tableName);      
    foreach (DataRow dr in dataSet.Tables["tp"].Rows)
    {
        if (dr["PNAME"].ToString().Trim().Equals("测试部"))
          {
              dr.Delete(); //删除DataSet 中的行
              break;
          }
     }
    dataSet.Tables[tableName].Rows[0][1] = 38;//更新DataSet中第一行第2列的值
    dataSet.Tables[tableName].Rows[1][3] = "开发项目";
    string[] dd = new String[5] { "124", "24", "dsf", "dsgrt", "2016-12-12 12:11:11" };
    dataSet.Tables[tableName].Rows.Add(dd);//增加一行 考虑参数的形式
    //增加一行 
    adapter.Update(dataSet, tableName);

    return 0;
}
catch (System.Exception ex)
{
    Console.WriteLine(ex.ToString());
    conn.Close();
    return 0;
}