Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
same columns for different tables using sqlbulkcopy
User77
Oct 27 2016 9:25 AM
275
Reply
Hi in my web application, I have 4 Data base tables and 3 tables are have same column names and how can i take in sqlbulkcopy method. Can anyone please tell me
objbulk.DestinationTableName = "Adjustments";
objbulk.DestinationTableName = "Payments";
objbulk.DestinationTableName = "Charges";
objbulk.ColumnMappings.Add("ID", "ID");
objbulk.ColumnMappings.Add("Description", "Description");
objbulk.ColumnMappings.Add("Credits", "Credits");
objbulk.ColumnMappings.Add("QTY%", "QTYInPercentage");
objbulk.ColumnMappings.Add("Amount", "Amount");
objbulk.ColumnMappings.Add("Amount %", "AmountInPercentage");
objbulk.ColumnMappings.Add("Client", "Client");
con.Open();
objbulk.WriteToServer(dt);
con.Close();
Thank you
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
how to insert ddl value in database by using sqlbulkcopy
Convert utf-8 text file to PDF