Browse by Tags

SQL Bulk insert and ADO .NET SQLBulkCopy
Tuesday, April 15, 2008 6:39 PM

--SQL Procedure to insert data from a comma delimited text file use MyDatabase --- Create a temp table to hold the data CREATE TABLE TmpStList ( username varchar (100) NOT NULL, userpassword varchar (100) NOT NULL, ) go --bulk insert from a text file BULK INSERT tmpStList FROM 'C:\temp.txt' WITH (FIELDTERMINATOR = ',') go -- insert into a destination... Read More...

by xxXd | with no comments

Filed under: sql, ADO .NET

Comb the tangled SQL server 2005 connection string and deploy the database to remote SQL server
Wednesday, February 20, 2008 12:48 AM

No matter how many ADO .net application I did and will write in the past and future, near and far, there is no way I can remember the long connection strings in indecipherable machine language. Normally I would do a quick search and grab whatever turns up on the first spot and stuff it in my web.config file. Normally I use access, normally it would work. Occasionally... Read More...

by xxXd

Filed under: database, SQL server 2005, ADO .NET