Click here to Skip to main content
15,897,101 members
Home / Discussions / C#
   

C#

 
Questionc# Pin
sutapa das29-Jul-12 20:30
sutapa das29-Jul-12 20:30 
AnswerRe: c# Pin
Abhinav S29-Jul-12 20:46
Abhinav S29-Jul-12 20:46 
Questionhow to create monthly calander in c#? Pin
sutapa das29-Jul-12 20:27
sutapa das29-Jul-12 20:27 
AnswerRe: how to create monthly calander in c#? Pin
Midnight Ahri29-Jul-12 20:40
Midnight Ahri29-Jul-12 20:40 
GeneralRe: how to create monthly calander in c#? Pin
Richard MacCutchan29-Jul-12 21:54
mveRichard MacCutchan29-Jul-12 21:54 
AnswerRe: how to create monthly calander in c#? Pin
Dave Kreskowiak30-Jul-12 2:19
mveDave Kreskowiak30-Jul-12 2:19 
QuestionApplication Level Key Shortcut Pin
Jassim Rahma29-Jul-12 11:54
Jassim Rahma29-Jul-12 11:54 
AnswerRe: Application Level Key Shortcut Pin
Richard Andrew x6429-Jul-12 12:19
professionalRichard Andrew x6429-Jul-12 12:19 
GeneralRe: Application Level Key Shortcut Pin
Trak4Net29-Jul-12 20:30
Trak4Net29-Jul-12 20:30 
AnswerRe: Application Level Key Shortcut Pin
BobJanova29-Jul-12 23:23
BobJanova29-Jul-12 23:23 
AnswerRe: Application Level Key Shortcut Pin
Andrei Straut30-Jul-12 0:59
Andrei Straut30-Jul-12 0:59 
AnswerRe: Application Level Key Shortcut Pin
Shameel30-Jul-12 2:47
professionalShameel30-Jul-12 2:47 
QuestionDifference Between BeginGetResponse and GetResponse Pin
baranils29-Jul-12 9:48
baranils29-Jul-12 9:48 
AnswerRe: Difference Between BeginGetResponse and GetResponse Pin
Richard Andrew x6429-Jul-12 11:17
professionalRichard Andrew x6429-Jul-12 11:17 
AnswerRe: Difference Between BeginGetResponse and GetResponse Pin
Trak4Net29-Jul-12 12:01
Trak4Net29-Jul-12 12:01 
GeneralRe: Difference Between BeginGetResponse and GetResponse Pin
baranils29-Jul-12 19:02
baranils29-Jul-12 19:02 
GeneralRe: Difference Between BeginGetResponse and GetResponse Pin
Trak4Net29-Jul-12 20:28
Trak4Net29-Jul-12 20:28 
GeneralRe: Difference Between BeginGetResponse and GetResponse Pin
baranils29-Jul-12 20:38
baranils29-Jul-12 20:38 
GeneralRe: Difference Between BeginGetResponse and GetResponse Pin
Trak4Net29-Jul-12 21:11
Trak4Net29-Jul-12 21:11 
QuestionDynamically Insert single record into MS access from SQL server Pin
Member 928738129-Jul-12 6:39
Member 928738129-Jul-12 6:39 
AnswerRe: Dynamically Insert single record into MS access from SQL server Pin
Trak4Net29-Jul-12 12:09
Trak4Net29-Jul-12 12:09 
AnswerRe: Dynamically Insert single record into MS access from SQL server Pin
BobJanova29-Jul-12 23:31
BobJanova29-Jul-12 23:31 
GeneralRe: Dynamically Insert single record into MS access from SQL server Pin
PIEBALDconsult30-Jul-12 3:47
mvePIEBALDconsult30-Jul-12 3:47 
You have no reason to have all the data in memory at once so use a DataReader, not a DataSet.

0) ExecuteReader on the SELECT command
1) Iterate the DataReader's columns to create the INSERT command and its parameters
2) Read from the DataReader
3) Set the INSERT command's parameter values
4) ExecuteNonQuery
5) Repeat from 2 as necessary


You should also use a try/catch and a transaction.

modified 30-Jul-12 11:39am.

Questiondata transfer Pin
rizaaltinok29-Jul-12 0:20
rizaaltinok29-Jul-12 0:20 
GeneralRe: data transfer Pin
Abhinav S29-Jul-12 0:27
Abhinav S29-Jul-12 0:27 

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.