This may be to general of a question, and I apologize if it is. I'm trying to ad开发者_JAVA技巧d data from an array to a SQL CE database. The array is 30 columns by up to 360 rows. I've found samples of different ways to do it, but are all inefficient on an array of the size I'm working with as they require each element of the array to be added individually. It seems logical to assume the is a wasy to add a full row of a the array as a row in the database, however I haven't found one yet. Does anyone have any input on how to do this?
Can you add it to the SQL Server database instead of the CE database?
I'm assuming your CE database doesn't stand alone.
Try to adapt this sample: http://sqlcebulkcopy.codeplex.com
精彩评论