如何将数据集中的记录插入数据库

我正在使用Windows表单。



我已经过滤了我的数据集中的记录，我需要将其复制到我的数据库的本地副本，但需要一个示例如何去做这个。当地的数据库已经建成。我试图遍历数据集中每个表中的列并插入。这就是我到目前为止。

I am using Windows forms.

I have filtered records in my dataset that I need to copy to a local copy of my database but need an example of how to do this. The local databse is already built. I am trying to loop through the columns in each table in the dataset and insert. This is what I have so far.

try
            {
               foreach (DataColumn c in ds.Tables[0].Columns)
               {
                 string strSQL = "Select * from " + dsTables.Tables[0];
                 SqlCeDataAdapter daCe = new SqlCeDataAdapter(strSQL, strCEConnection);
                 SqlCommandBuilder daCEcmd = new SqlCommandBuilder(daCe);
               }
            }
            catch
            { }
            finally { }