SqlBulkCopy Instance Via SQLEXPRESS-ADO.NET 2.0-Visual C# Express: Security Was Unhandled?

Hi all,

I copied the following set of C# code statement from a website to learn the SqlBulkCopy instance via SQLEXPRESS-ADO.NET 2.0-Visual C# Express:

/////////////////////----Main.cs---//////////////////////

sing System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace SqlBulkCopySample

{

public partial class frmMain : Form

{

public frmMain()

{

InitializeComponent();

}

private void btnStart_Click(object sender, EventArgs e)

{

String sourceConnectionString =

"Data Source=.SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True";

String destinationConnectionString =

"Data Source=.SQLEXPRESS;Initial Catalog=SqlBulkCopySample;Integrated Security=True";



DataTable data = SelectDataFromSource(sourceConnectionString);

CopyDataToDestination(destinationConnectionString, data);

}

private DataTable SelectDataFromSource(String connectionString)

{

DataTable data = new DataTable();

using (SqlConnection connection = new SqlConnection(connectionString))

{

SqlCommand command = new SqlCommand("SelectOrders", connection);

command.CommandType = CommandType.StoredProcedure;

connection.Open();

SqlDataReader reader = command.ExecuteReader();

data.Load(reader);

}

return data;

}

private void CopyDataToDestination(String connectionString, DataTable table)

{

SqlBulkCopyColumnMapping mapping1 =

new SqlBulkCopyColumnMapping("OrderID", "ID");

SqlBulkCopyColumnMapping mapping2 =

new SqlBulkCopyColumnMapping("ShipName", "Name");

SqlBulkCopyColumnMapping mapping3 =

new SqlBulkCopyColumnMapping("ShipAddress", "Address");

SqlBulkCopyColumnMapping mapping4 =

new SqlBulkCopyColumnMapping("ShipCity", "City");

SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString);

bulkCopy.BatchSize = 100;

bulkCopy.BulkCopyTimeout = 5;

bulkCopy.ColumnMappings.Add(mapping1);

bulkCopy.ColumnMappings.Add(mapping2);

bulkCopy.ColumnMappings.Add(mapping3);

bulkCopy.ColumnMappings.Add(mapping4);

bulkCopy.DestinationTableName = "DataMySqlBC1";

bulkCopy.SqlRowsCopied +=

new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);

bulkCopy.NotifyAfter = 200;

bulkCopy.WriteToServer(table);

}

void bulkCopy_SqlRowsCopied(object sender, SqlRowsCopiedEventArgs e)

{

MessageBox.Show

(String.Format("{0} Rows have been copied.", e.RowsCopied.ToString()));

}

}

}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////
I executed the above project in my local PC (with Adiministrator previlidge/use) that is in our LAN/Network system and I got an error: SecurityException was unhandled - Request for permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'failed. First, I have a question: is this problem related to the remote connection to SQLEXPRESS? Second, I do not know how to solve this problem. Please help and answer my first question and tell me how to solve this problem.

Thanks in advance,
Scott Chang