Click here to Skip to main content
15,898,371 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to Create UI AUTOMATION for OUTLOOK 2007 using C# .Net 3.0 (using System.Windows.Automation;) Pin
Phil J Pearson21-Jan-10 2:22
Phil J Pearson21-Jan-10 2:22 
GeneralRe: How to Create UI AUTOMATION for OUTLOOK 2007 using C# .Net 3.0 (using System.Windows.Automation;) Pin
bruze21-Jan-10 2:24
bruze21-Jan-10 2:24 
QuestionManagement Scope in connection options Pin
vinothkumar_Dhakshinamoorthy21-Jan-10 1:40
vinothkumar_Dhakshinamoorthy21-Jan-10 1:40 
QuestionTutorial on developing custom\user control in c# Pin
matixsc21-Jan-10 1:08
professionalmatixsc21-Jan-10 1:08 
AnswerRe: Tutorial on developing custom\user control in c# Pin
N a v a n e e t h21-Jan-10 1:32
N a v a n e e t h21-Jan-10 1:32 
AnswerRe: Tutorial on developing custom\user control in c# Pin
Eddy Vluggen21-Jan-10 1:44
professionalEddy Vluggen21-Jan-10 1:44 
GeneralRe: Tutorial on developing custom\user control in c# Pin
matixsc21-Jan-10 2:22
professionalmatixsc21-Jan-10 2:22 
QuestionBatch update in SQL Server Database Pin
sirtimid21-Jan-10 0:32
sirtimid21-Jan-10 0:32 
Hello all,
I have a windows application which updates multiple rows (using a stored procedure in the db) in a SQL Server database, but this updates run many times sequentially in a for loop.
For the update methos I have tried the following methods:
- The SqlCommand object running my stored procedure as a text commnand and executing it with the ExecuteNonQuery method.
- An SqlDataAdapter using its UpdateCommand attribute and executing using the ExecuteNonQuery method.

In both ways the running time is really slow.
Can anyone suggest me an other way to do the updates. It would be good if I could save my updates n a dataset or a datatable and after save it to the db.

Thanks in Advance

Dimitris
AnswerRe: Batch update in SQL Server Database Pin
Rob Philpott21-Jan-10 3:11
Rob Philpott21-Jan-10 3:11 
GeneralRe: Batch update in SQL Server Database Pin
sirtimid21-Jan-10 3:20
sirtimid21-Jan-10 3:20 
GeneralRe: Batch update in SQL Server Database Pin
Rob Philpott21-Jan-10 3:39
Rob Philpott21-Jan-10 3:39 
GeneralRe: Batch update in SQL Server Database Pin
sirtimid21-Jan-10 4:00
sirtimid21-Jan-10 4:00 
AnswerRe: Batch update in SQL Server Database Pin
PIEBALDconsult21-Jan-10 3:26
mvePIEBALDconsult21-Jan-10 3:26 
QuestionSelection in ListBox Pin
Anu_Bala21-Jan-10 0:21
Anu_Bala21-Jan-10 0:21 
AnswerRe: Selection in ListBox Pin
Luc Pattyn21-Jan-10 1:18
sitebuilderLuc Pattyn21-Jan-10 1:18 
AnswerRe: Selection in ListBox Pin
freakyit21-Jan-10 3:49
freakyit21-Jan-10 3:49 
GeneralRe: Selection in ListBox Pin
Anu_Bala24-Jan-10 16:41
Anu_Bala24-Jan-10 16:41 
QuestionHow to get shared folder sharing permission for certain user name or group? Pin
cyn820-Jan-10 22:43
cyn820-Jan-10 22:43 
AnswerRe: How to get shared folder sharing permission for certain user name or group? Pin
dan!sh 20-Jan-10 23:08
professional dan!sh 20-Jan-10 23:08 
QuestionParallel lines & rounded line Pin
AlexB4720-Jan-10 22:25
AlexB4720-Jan-10 22:25 
AnswerRe: Parallel lines & rounded line Pin
Anurag Gandhi20-Jan-10 23:02
professionalAnurag Gandhi20-Jan-10 23:02 
GeneralRe: Parallel lines & rounded line Pin
AlexB4720-Jan-10 23:39
AlexB4720-Jan-10 23:39 
AnswerRe: Parallel lines & rounded line Pin
dan!sh 20-Jan-10 23:03
professional dan!sh 20-Jan-10 23:03 
GeneralRe: Parallel lines & rounded line Pin
AlexB4720-Jan-10 23:11
AlexB4720-Jan-10 23:11 
GeneralRe: Parallel lines & rounded line Pin
Rob Philpott20-Jan-10 23:34
Rob Philpott20-Jan-10 23:34 

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.