tags:

views:

50

answers:

1
Q: 

Do I need all database columns in my DataTable for SqlBulkCopy WriteToServer?

I'm importing some data from a CSV, and it doesn't have all the fields my table does. I was making a DataTable with only the columns of my CSV, but I'm getting errors about converting from String to Boolean. None of the fields I'm adding are Boolean, so I'm assuming its a problem with the fields I left alone.

Do I need to have a 1-1 mapping in my DataTable?

A: 

Well, once I added all the columns, things started working, so I guess the answer is yes.

Tom  2009-09-24 01:40:45

related questions

Best way to get a comma delineated string into xml format?
Table NewRow() Causes Memory Leak
Querying DataColumnCollection with LINQ
Compare datatables
.NET DataTable skips rows on Load(DataReader)
OOP and DataTables for Rank Amateurs
"Endless scrolling" effect in a HTML table
How do you convert a DataTable into a generic list?
How do I display only certain columns from a data table?
Getting Count from Grouped DataTable in VB via Linq
DataTable + DataGrid Data Binding Performance Againsts Custom Data Source Object + Data Grid
.NET Fastest way to iterate through rows in a datatable?
Cast or convert when retrieving data from a database?
How can I make a globally accessible datatable in a Winforms application?
DataGridView's bound table only generates one RowChanged event on a double-click. How do I make it do two?
Abstracting storage data structures within XPath
Speed of DataSet row/column lookups?
How do I bind the result of DataTable.Select() to a ListBox control?
How many DataTable objects should I use in my C# app?
Trigger update on DataTable bound to DataGridView
DataTable to readable text string
.Net - Returning DataTables in WCF
Datatables, Dataviews and distincts! (ASP.Net/VB)
Datatable vs Dataset
Check for changes to a SQL table?