sqlbulkcopy
How to add gridview rows to a datatable?
I have a gridview which will contain some \'n\' number of rows.... Now i want to add all rows ofthe gridview to a datatable which will be used for bulkcopy operation...[详细]
2022-12-21 00:40 分类:问答incoherence in bcp command execution
I execute a bcp command in 2 computer. The first computer has windows xp and second 开发者_运维百科one has windows server 2003. when I execute command in first, the bcp run successfully but when I run[详细]
2022-12-20 16:10 分类:问答Get an IDataReader from a typed List
I have a List<MyObject> with a million elements. (It is act开发者_运维知识库ually a SubSonic Collection but it is not loaded from the database).[详细]
2022-12-20 06:09 分类:问答Rollback for bulk copy
I have an application开发者_如何学Go that make a copy from my database by bulk copy class in c#.[详细]
2022-12-19 22:36 分类:问答add column while copying data in sql
I\'m using SqlBulkCopy to bulk insert some records from one table into another table.The query is using a SqlDataReader to get the data.The one difference that matters (besides column order which is h[详细]
2022-12-19 07:52 分类:问答Processing a flat file in chunks using multiple threads using producer/consumer pattern and SqlBulkCopy into SQL Server DB
I hope you will bear with me. I wanted to provide as much information as I can. The main problem is how to create a structure (like a stack) that will be used by multiple threads that will pop a valu[详细]
2022-12-16 15:53 分类:问答SQL Server 2005: Improving performance for thousands or Insert requests. logout-login time= 120ms
Can somebody shed some lights on how SQL Server 2005 deals with may request issued by a client using ADO.NET 2.0. Below is the shortend output of SQL Trace. I can see that connection pooling is workin[详细]
2022-12-16 03:44 分类:问答Get SqlDateTime overflow in SqlBulkCopy.WriteToServer()
I insert data from a typed dataset into my MSSQL database by using SqlBuldCopy class: foreach (DataTable dt in ds.Tables)[详细]
2022-12-14 05:06 分类:问答SqlBulkCopy failing with String conversion issue
I have a view which generates a number of columns which I want to bulk load into another table which has identically named columns.[详细]
2022-12-13 16:03 分类:问答SqlBulkCopy problem
i use SqlBulkCopy to insert data from OleDbDataReader (contains data from xls) to mssql-2005 i have a cloumn on theOleDbDataReaderth开发者_如何学JAVAat contains number stored as text (in the xls)[详细]
2022-12-12 19:18 分类:问答
加载中,请稍侯......