c#多表查詢結果數據集更新問題

Question

参考这里，
ADO.NET中的多数据表操作浅析
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx

Answer 1

另外一个通过向导生成的代码也可以参考一下，
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx

Answer 2

你先用SQL语句建立一个新表
表内的字段类型,长度,非空约束~按你选定的多表的字段来做
然后用单表的方法去更新~~~

Answer 3

public static void UpdateDataset(DataSet dataSet, string[] tableNames)
        {            OleDbConnection conn = new OleDbConnection();
            conn = conntodata.conndata();
            OleDbTransaction trans = conn.BeginTransaction();
            try
            {
                foreach (string tableName in tableNames)
                {
                    UpdateDataset(trans,conn,dataSet,tableName);
                }
                trans.Commit();
            }
            catch (System.Data.OleDb.OleDbException e)
            {
                trans.Rollback();
                throw new Exception(e.Message);
            }
            finally
            {
                conn.Close();
            }
        }
        public static void UpdateDataset(OleDbTransaction trans, OleDbConnection conn, DataSet dataSet, string tableName)
        {
            string ls_sql = "select top 0 * from " + tableName;            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            OleDbDataAdapter da = new OleDbDataAdapter(ls_sql, conn);
            OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
            da.SelectCommand.Transaction = trans;
            
            try
            {
                da.Update(dataSet, tableName);
                //ds.AcceptChanges();
            }
            catch (System.Data.OleDb.OleDbException e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                da.Dispose();
                cb.Dispose();
                dataSet.Dispose();
            }
        }
怎麼更新不了啊,

Answer 4

不能沉下去,我想很多新手都想知道,能源碼作參考最好,最好不要用select top 0 from 表,哪樣感覺不好