Click here to Skip to main content
15,888,454 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# and Excel Pin
su_penguin16-Mar-09 8:15
su_penguin16-Mar-09 8:15 
GeneralRe: C# and Excel Pin
Jimmanuel16-Mar-09 8:49
Jimmanuel16-Mar-09 8:49 
Questionc# class editor Pin
MikiR16-Mar-09 6:24
MikiR16-Mar-09 6:24 
AnswerRe: c# class editor Pin
led mike16-Mar-09 6:59
led mike16-Mar-09 6:59 
GeneralRe: c# class editor Pin
MikiR16-Mar-09 7:10
MikiR16-Mar-09 7:10 
QuestionAccessing a Web.config from a windows app [modified] Pin
dptalt16-Mar-09 5:28
dptalt16-Mar-09 5:28 
AnswerRe: Accessing a Web.config from a windows app Pin
led mike16-Mar-09 5:42
led mike16-Mar-09 5:42 
QuestionOpen SQL connection via C# Pin
Ido16-Mar-09 4:44
Ido16-Mar-09 4:44 
Hi,
I am working under C# 2008 and SQL 2005 express edition.

To connect to database I used with Typed Dataset and all insert command I used with same object. I had over million rows.

At this object I implement Insert command. I glance in “TypedDataset.Designer.cs” file under my Typed Dataset at Insert command and see that Adapter open and close the connection after each insert execution.

My questions are:Confused | :confused:

1. This is necessary to open and close the connection all the time?

2. We cannot to leave the connection open?

3. What about performance?

4. There is another way to insert large quantities of rows to database?


Thanks,
Ido

AnswerRe: Open SQL connection via C# Pin
led mike16-Mar-09 5:39
led mike16-Mar-09 5:39 
GeneralRe: Open SQL connection via C# Pin
Ido16-Mar-09 6:36
Ido16-Mar-09 6:36 
GeneralRe: Open SQL connection via C# Pin
led mike16-Mar-09 6:57
led mike16-Mar-09 6:57 
GeneralRe: Open SQL connection via C# Pin
Ido16-Mar-09 7:28
Ido16-Mar-09 7:28 
GeneralRe: Open SQL connection via C# Pin
led mike16-Mar-09 7:51
led mike16-Mar-09 7:51 
AnswerRe: Open SQL connection via C# Pin
fly90416-Mar-09 7:37
fly90416-Mar-09 7:37 
QuestionCustom properties for inherited button control Pin
akamper16-Mar-09 3:56
akamper16-Mar-09 3:56 
AnswerRe: Custom properties for inherited button control Pin
DaveyM6916-Mar-09 4:57
professionalDaveyM6916-Mar-09 4:57 
GeneralRe: Custom properties for inherited button control Pin
akamper16-Mar-09 21:33
akamper16-Mar-09 21:33 
GeneralRe: Custom properties for inherited button control Pin
DaveyM6917-Mar-09 2:37
professionalDaveyM6917-Mar-09 2:37 
QuestionJava vs .NET - Open Source Pin
dataminers16-Mar-09 3:43
dataminers16-Mar-09 3:43 
RantRe: Java vs .NET - Open Source Pin
Eddy Vluggen16-Mar-09 3:48
professionalEddy Vluggen16-Mar-09 3:48 
GeneralRe: Java vs .NET - Open Source Pin
#realJSOP16-Mar-09 5:23
mve#realJSOP16-Mar-09 5:23 
GeneralRe: Java vs .NET - Open Source Pin
led mike16-Mar-09 5:49
led mike16-Mar-09 5:49 
GeneralRe: Java vs .NET - Open Source Pin
Eddy Vluggen16-Mar-09 6:04
professionalEddy Vluggen16-Mar-09 6:04 
GeneralRe: Java vs .NET - Open Source Pin
led mike16-Mar-09 6:46
led mike16-Mar-09 6:46 
GeneralRe: Java vs .NET - Open Source [modified] Pin
Eddy Vluggen16-Mar-09 10:17
professionalEddy Vluggen16-Mar-09 10:17 

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.