I suppose Quantum wanted to auto generate Table structure also , but the above solution would require the user to define the structure himself.
Can you please give insight on this.
Thanks for you tip，and in fact I suggest him creating a database with a specific table with the same structures like what's defined in the DataTable's columns' types（for types in SQL to types in .NET，he can refer：http://msdn.microsoft.com/en-us/library/4e5xt97a(v=vs.71).aspx）
When finishing them and use SqlBulkCopy，it will read line-by-line data contents from DataTable or DataReader so quickly to fill into the same structure of DataTable。
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: import xml files to "auto generated" db tabl
Apr 17, 2012 01:18 AM|LINK
Thanks for you tip，and in fact I suggest him creating a database with a specific table with the same structures like what's defined in the DataTable's columns' types（for types in SQL to types in .NET，he can refer：http://msdn.microsoft.com/en-us/library/4e5xt97a(v=vs.71).aspx）
When finishing them and use SqlBulkCopy，it will read line-by-line data contents from DataTable or DataReader so quickly to fill into the same structure of DataTable。