Database

if @ModuleSettings is not NULL
BEGIN
set @param = @param + '[ModuleSettings]=''' + <code>@ModuleSettings</code> + ''',' 
END

if @ModuleSettings is not NULL
BEGIN
set @param = @param + '[ModuleSettings]=''' + <code>replace (@ModuleSettings,CHAR(39),char(39)+CHAR(39))</code> + ''',' 
End

using (SqlConnection connection = new SqlConnection(strConn))
{
    connection.Open();
 
    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
    {
        bulkCopy.DestinationTableName = strSQL_table_name;
        bulkCopy.BatchSize = GetBulkCopySize();
        bulkCopy.BulkCopyTimeout = 2000;
        bulkCopy.NotifyAfter = GetNotifyAfter();
        bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(OnSqlRowsCopied);
 
        try
        {
            bulkCopy.WriteToServer(results);
        }
        catch (Exception ex)
        {
            string error = ex.Message;
            MessageBox.Show("Error(CSV_To_SQL-a): " + ex.Message);
            return;
        }

adapter.FillSchema(table, SchemaType.Source);
table.Columns[2].DataType = typeof (Int32);
adapter.Fill(table);