DataTable to an SDF File

See more:

C#

SQL

Visual-Studio

VS2010

Hello,

I have got an application that reads an Excel Spreadsheet into a DataTable. I am now struggling to take the data from that DataTable and add it into my local SDF file.

I am using C#

Any help would be much appreciated :)

private bool WriteOutDataAsSdf(ref string sdfOutputFile, ref DataTable dataTable)
        {
            SqlCommand commandRowCount = new SqlCommand("SELECT COUNT(*) FROM " + "sdf.PLU Codes;", connection);

            long countStart = Convert.ToInt32(commandRowCount.ExecuteScalar());

            MessageBox.Show("Starting row count = " + countStart);

            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
            {
                bulkCopy.DestinationTableName = "sdf.PLU Codes";
                try
                {
                    // Write from the source to the destination.
                    bulkCopy.WriteToServer(dt);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
            }
        }

Cheers Glen.