Transfer Datatable data into SQLserver

See more:

C#

Dear all
I've been trying to copy datatable data into sqlserver existing table.I've tried different approaches I found on the web but none of them works for my case :(
Here is the latest approach i used for which I get "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data .dll" error.

Your help is much appreciated

string connectionString = "server=localhost;database=CPSdata;Trusted_Connection=True"; ;

            //Open a connection with destination database;
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                using (SqlBulkCopy bulkcopy = new SqlBulkCopy(connection))
                {

                    bulkcopy.DestinationTableName = "dbo.climateRawDataTable";

                    try
                    {
                        bulkcopy.WriteToServer(dt);
                    }
                    catch (Exception ex)
                    {
                    }

                    connection.Close();
                }
            }