Click here to Skip to main content
15,891,423 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to get the final program? Pin
Dan Neely18-Dec-08 3:26
Dan Neely18-Dec-08 3:26 
GeneralRe: How to get the final program? Pin
Luc Pattyn18-Dec-08 3:44
sitebuilderLuc Pattyn18-Dec-08 3:44 
Questionadding stuff to labels from textboxes but creating new labels to populate as we go? Pin
Davey8518-Dec-08 0:54
Davey8518-Dec-08 0:54 
AnswerRe: adding stuff to labels from textboxes but creating new labels to populate as we go? Pin
Expert Coming18-Dec-08 0:59
Expert Coming18-Dec-08 0:59 
GeneralRe: adding stuff to labels from textboxes but creating new labels to populate as we go? Pin
Davey8518-Dec-08 2:09
Davey8518-Dec-08 2:09 
AnswerRe: adding stuff to labels from textboxes but creating new labels to populate as we go? Pin
benjymous18-Dec-08 1:32
benjymous18-Dec-08 1:32 
AnswerRe: adding stuff to labels from textboxes but creating new labels to populate as we go? Pin
Brij18-Dec-08 1:59
mentorBrij18-Dec-08 1:59 
QuestionRegular Expression for Date Validator not working? Pin
Dinker Batra18-Dec-08 0:29
Dinker Batra18-Dec-08 0:29 
AnswerRe: Regular Expression for Date Validator not working? Pin
Dinker Batra18-Dec-08 0:32
Dinker Batra18-Dec-08 0:32 
GeneralRe: Regular Expression for Date Validator not working? Pin
Guffa18-Dec-08 0:39
Guffa18-Dec-08 0:39 
GeneralRe: Regular Expression for Date Validator not working? Pin
Dinker Batra18-Dec-08 0:48
Dinker Batra18-Dec-08 0:48 
GeneralRe: Regular Expression for Date Validator not working? Pin
Guffa18-Dec-08 1:47
Guffa18-Dec-08 1:47 
GeneralRe: Regular Expression for Date Validator not working? Pin
Dinker Batra18-Dec-08 1:57
Dinker Batra18-Dec-08 1:57 
GeneralRe: Regular Expression for Date Validator not working? Pin
Gideon Engelberth18-Dec-08 3:33
Gideon Engelberth18-Dec-08 3:33 
AnswerRe: Regular Expression for Date Validator not working? Pin
PIEBALDconsult18-Dec-08 12:16
mvePIEBALDconsult18-Dec-08 12:16 
QuestionPost-build event command line error Pin
Reddy Prakash18-Dec-08 0:13
Reddy Prakash18-Dec-08 0:13 
AnswerRe: Post-build event command line error Pin
benjymous18-Dec-08 0:16
benjymous18-Dec-08 0:16 
GeneralRe: Post-build event command line error Pin
Reddy Prakash18-Dec-08 0:23
Reddy Prakash18-Dec-08 0:23 
GeneralRe: Post-build event command line error Pin
moon_stick18-Dec-08 0:55
moon_stick18-Dec-08 0:55 
GeneralRe: Post-build event command line error Pin
benjymous18-Dec-08 1:31
benjymous18-Dec-08 1:31 
QuestionText rotation Pin
kk.tvm17-Dec-08 23:10
kk.tvm17-Dec-08 23:10 
AnswerRe: Text rotation Pin
#realJSOP17-Dec-08 23:27
mve#realJSOP17-Dec-08 23:27 
AnswerRe: Text rotation Pin
benjymous17-Dec-08 23:27
benjymous17-Dec-08 23:27 
AnswerRe: Text rotation Pin
dan!sh 17-Dec-08 23:43
professional dan!sh 17-Dec-08 23:43 
QuestionSqlBulkCopy Pin
Expert Coming17-Dec-08 23:00
Expert Coming17-Dec-08 23:00 
Not sure if it is a Sql issue or a syntax error of sorts so here it is.

I have a DataTable with a single column Player Name. It is filled with some 20,000 rows. I need to insert this into a Sql database.

I have a Sql database setup with a table called Unknown, it has 2 columns, an Indentity column ID, and a varchar(50) column Player Name.

I copied the data over one-by-one and it took like 15-30 minutes to do, not I am using SqlBulkCopy. The problem is, it simply isn't working. No error, no warnings, no nothing. I have SQL Profiler open and don't see it even hitting the database. Code is attached, what am I doing wrong?

SqlConnection connection = new SqlConnection(Properties.Settings.Default.TibiaSQLConnection);

            connection.Open();

            SqlBulkCopy copier = new SqlBulkCopy(connection);
            copier.BatchSize = 500;
            copier.NotifyAfter = 1000;
            copier.SqlRowsCopied += new SqlRowsCopiedEventHandler(copier_SqlRowsCopied);
            copier.DestinationTableName = "Unknown";
            copier.WriteToServer(dtUnknowns);

            copier.Close();
            connection.Close();


The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.