How do I insert records from dataset into database

See more:

C#

.NETCF

C#4.0

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 { }