Bulk copy in Sql using C#

Dinesh Santhalingam

I have a data table .I want to push it to the sql table using Sqlbulkcopy .

Data table dt=new datatable();some data were loaded
Push this data to sql table.
string connectionstring = @"Data Source";
using (SqlConnection destinationConnection = new SqlConnection(connectionstring))
{
destinationConnection.Open();
using (SqlBulkCopy bulkCopy =new SqlBulkCopy(destinationConnection.ConnectionString)) {
bulkCopy.DestinationTableName = "studentmanagement";
bulkCopy.ColumnMappings.Add("Name", "Name");
bulkCopy.ColumnMappings.Add("Subjectname", "Subjectname");
bulkCopy.ColumnMappings.Add("Marks", "Marks");
bulkCopy.WriteToServer(dt);
}
destinationConnection.Close();
}

Error populating Cannot access the destination table.

Its not working.please anyone help me to solve this?

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago

Hi,
I think you are doing good ,but you need to change some little bit of code,
use breakpoint check code is working properly or not.
Dinesh Santhalingam9y ago
I got it .Thanks for everyone who responded my post
Amit Kumar9y ago
Hi Dear,
Please follow the below link.

http://www.c-sharpcorner.com/blogs/bulk-copy-in-sql-server-using-c-sharpnet1

http://www.aspsnippets.com/Articles/SqlBulkCopy-Bulk-Copy-data-from-DataTable-DataSet-to-SQL-Server-Table-using-C-and-VBNet.aspx
Nitin Sontakke9y ago
Also, check answer on this thread:

http://stackoverflow.com/questions/32717387/connecting-to-mdf-database-with-web-config-asp-net

Notice that the connection string is different.
Nitin Sontakke9y ago
I don't think it is required to create a connection separately. So "destinationConnection" in your case is not required. Just pass connectionstring variable to SqlBulkCopy constructor.

Have you already looked into this thread?
http://stackoverflow.com/questions/8894071/sqlbulkcopy-cannot-access-table

Is there a way to know if your windows user has permissions on that data base / table?
Dinesh Santhalingam9y ago
1. string connectionstring=
2. @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents\tstdoc.mdf;
3. Integrated Security=True;Connect Timeout=30;User Instance=True";
This is my connection string.@
Nitin Sontakke

Your connection string doesn't look good to me. Should you not have server name, database name, etc in it?

There is a Error :Cannot access the destination table; I don't know how the error raised.because the table is Already there.

saber shaikh

http://www.aspsnippets.com/Articles/SqlBulkCopy-Bulk-Copy-data-from-DataTable-DataSet-to-SQL-Server-Table-using-C-and-VBNet.aspx