How do I insert the correct ID field vs an auto-incremented number?

See more:

C#

.NETCF

C#4.0

In my dataset, I have a RecID field which is populated from query results. I am inserting the records to a local copy of the database using a data adapter. however, instead of the actual record number, the RecID field is starting at 1 and auto-incrementing. How do I get the correct RecID into my local database table?

This is the code I am using to insert the data from the dataset to the local database tables.

   private bool LoadRecs(DataTable tbl)
    {
        // this function inserts the records into the respective tables in the local db

        bool blnUploaded = false;

         if (tbl.Rows.Count == 0)
              return (blnUploaded);

        SqlCeDataAdapter daCe = new SqlCeDataAdapter("select * from " + tbl + " ", strCEConnection);
        DataSet dsCe = new DataSet();
        daCe.FillSchema(dsCe, SchemaType.Mapped, tbl.TableName);
        DataRow dr;

        for (int i = 0; i < tbl.Rows.Count; i++)
        {
            dr = dsCe.Tables[tbl.TableName].NewRow();
            for (int k = 0; k < tbl.Columns.Count; k++)
            {
                try
                {
                    dr[k] = tbl.Rows[i].ItemArray.GetValue(k).ToString().Trim();
                }
                catch
                {
                    dr[k] = System.DBNull.Value;
                }
            }
            dsCe.Tables[tbl.TableName].Rows.Add(dr);
        }

        SqlCeCommandBuilder cb = new SqlCeCommandBuilder(daCe);
        //seems this is needed to force the insert command to be assigned.
        daCe.InsertCommand = cb.GetInsertCommand();
        try
        {
            //call update to move all the data from sampletable DataTable into the database table
            daCe.Update(dsCe, tbl.TableName);
            daCe.Dispose();
            blnUploaded = true;
        }
        catch
        {
            blnUploaded = false;
            MessageBox.Show("Error");
        }
        return (blnUploaded);
    }
}