Click here to Skip to main content
15,900,378 members
Home / Discussions / C#
   

C#

 
AnswerRe: late binding Pin
dan!sh 15-May-08 2:07
professional dan!sh 15-May-08 2:07 
AnswerRe: late binding Pin
CPallini15-May-08 2:10
mveCPallini15-May-08 2:10 
QuestionRe: late binding Pin
Pankaj Garg15-May-08 2:54
Pankaj Garg15-May-08 2:54 
AnswerRe: late binding Pin
CPallini15-May-08 3:11
mveCPallini15-May-08 3:11 
AnswerRe: late binding Pin
Guffa15-May-08 7:29
Guffa15-May-08 7:29 
Questioncould anyone tell me Pin
prasadbuddhika15-May-08 1:18
prasadbuddhika15-May-08 1:18 
AnswerRe: could anyone tell me Pin
Ashfield15-May-08 3:08
Ashfield15-May-08 3:08 
QuestionBest way to insert DataSet to database table Pin
cokelite15-May-08 0:44
cokelite15-May-08 0:44 
Using .NET v. 1.1. Trying to implement a method that would insert rows from DataSet.Table[0] to an exsisting, empty database table which has identical structure. In my case the data of DataSet is fetched from SqlServer and inserted to SolidServer. With the following code the job gets done, but i'm wondering whether there is a more efficient way to do it?

With the code listed below, inserting e.g. 10 000 rows takes about 30 seconds and that's too slow for my purposes.

public void UpdateData(OdbcConnection connConnection, DataSet dsTmp, string strTable) {
OdbcCommandBuilder CommandBuilder = null;
OdbcDataAdapter daAdapter = null;
OdbcTransaction trans = null;
try {
trans = connConnection.BeginTransaction(IsolationLevel.Serializable);
daAdapter = new OdbcDataAdapter();
daAdapter.SelectCommand = new OdbcCommand("SELECT * FROM " + strTable, connConnection, trans);
CommandBuilder = new OdbcCommandBuilder(daAdapter);
daAdapter.UpdateCommand = CommandBuilder.GetInsertCommand();
daAdapter.Update(dsTmp);
trans.Commit();
}
catch (System.Exception ex) {
throw ex;
}
}
AnswerRe: Best way to insert DataSet to database table Pin
Bert delaVega15-May-08 7:16
Bert delaVega15-May-08 7:16 
QuestionImplement ListView Itemplate - for dynamically building a listview itemtemplaet Pin
harleydk15-May-08 0:42
harleydk15-May-08 0:42 
QuestionHow to preserve Master page data whenever conten page is loaded? Pin
.NetRams15-May-08 0:10
.NetRams15-May-08 0:10 
AnswerRe: How to preserve Master page data whenever conten page is loaded? Pin
harleydk15-May-08 0:39
harleydk15-May-08 0:39 
QuestionHow do I create a PropertyGrid with dynamic Properties? Pin
Megidolaon14-May-08 23:51
Megidolaon14-May-08 23:51 
AnswerRe: How do I create a PropertyGrid with dynamic Properties? Pin
Gareth H14-May-08 23:57
Gareth H14-May-08 23:57 
GeneralRe: How do I create a PropertyGrid with dynamic Properties? Pin
Megidolaon15-May-08 0:23
Megidolaon15-May-08 0:23 
GeneralRe: How do I create a PropertyGrid with dynamic Properties? Pin
visualhint22-May-08 9:37
visualhint22-May-08 9:37 
Questionproblem in Range selection Pin
sailesh_gupta14-May-08 23:37
sailesh_gupta14-May-08 23:37 
AnswerRe: problem in Range selection Pin
Christian Graus14-May-08 23:53
protectorChristian Graus14-May-08 23:53 
QuestionRe: problem in Range selection Pin
sailesh_gupta14-May-08 23:59
sailesh_gupta14-May-08 23:59 
AnswerRe: problem in Range selection Pin
Christian Graus15-May-08 0:41
protectorChristian Graus15-May-08 0:41 
GeneralRe: problem in Range selection Pin
sailesh_gupta15-May-08 0:52
sailesh_gupta15-May-08 0:52 
QuestionRe: problem in Range selection Pin
CPallini15-May-08 0:56
mveCPallini15-May-08 0:56 
AnswerRe: problem in Range selection Pin
sailesh_gupta15-May-08 1:06
sailesh_gupta15-May-08 1:06 
GeneralRe: problem in Range selection Pin
CPallini15-May-08 2:02
mveCPallini15-May-08 2:02 
GeneralRe: problem in Range selection Pin
sailesh_gupta15-May-08 2:09
sailesh_gupta15-May-08 2:09 

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.