Error is destinationtablename property must be set before calling this method in C#

Question

0.00/5 (No votes)

See more:

I want to excel copy to database table.But this line is error.

bulkCopy.WriteToServer(dt);

And error is DestinationTableName :
The DestinationTableName property must be set before calling this method.

I want copy this table:

MY DATABASE NAME:READTEST
TABLE NAME:Students

What I have tried:

public partial class Form1 : Form
    {

        public Form1()
        {
            InitializeComponent();
        }

Posted 7-Jun-19 14:46pm

Student_Engineer

Updated 9-Jun-19 17:57pm

v2

Add a Solution

Comments

[no name] 8-Jun-19 2:28am

copy.DestinationTableName = symbolName;

[no name] 8-Jun-19 4:52am

Thank you so much.I write bulkCopy.DestinationTableName = "Students"; and done

ZurdoDev 10-Jun-19 16:35pm

Please post as solution.

Richard MacCutchan 8-Jun-19 4:05am

Do what the message tells you and set the DestinationTableName to a valid table name.

#realJSOP 11-Jun-19 9:42am

I wonder why the SqlBulkCopy object doesn't automagically use the table name specified in the DataTable object... I recently implemented a generic BulkInsert method and tripped over the same problem. I just assumed that the SqlBulkCopy object would do what's right.

Richard MacCutchan 11-Jun-19 11:25am

Remarks
If DestinationTableName has not been set when WriteToServer is called, an ArgumentNullException is thrown.

If DestinationTableName is modified while a WriteToServer operation is running, the change does not affect the current operation. The new DestinationTableName value is used the next time a WriteToServer method is called.

DestinationTableName is a three-part name (<database>.<owningschema>.<name>). You can qualify the table name with its database and owning schema if you choose. However, if the table name uses an underscore ("_") or any other special characters, you must escape the name using surrounding brackets as in ([<database>.<owningschema>.<name_01>]). For more information, see Database Identifiers.

You can bulk-copy data to a temporary table by using a value such as tempdb..#table or tempdb.<owner>.#table for the DestinationTableName property.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)