Click here to Skip to main content
15,908,634 members
Home / Discussions / C#
   

C#

 
QuestionHow to handle excel - multiple sheets integration with ODBC Driver connection in C# Pin
Member 1485915110-Jun-20 3:10
Member 1485915110-Jun-20 3:10 
AnswerRe: How to handle excel - multiple sheets integration with ODBC Driver connection in C# Pin
jsc423-Jul-20 6:43
professionaljsc423-Jul-20 6:43 
Your problem is in the following loop ...
C#
for (int j = 0; j < excelSheets.Length; j++)
{
    // Query each excel sheet.
    var query = string.Format("select * from [{0}] where TestName = '{1}'", excelSheets[j], keyName);
    value = connection.Query<T>(query).FirstOrDefault();
}
As soon as you have got a value in the value field, you move on to the next sheet. You need to either do something with the value before going round the next iteration of the loop or store the values (one per sheet) e.g. in an array, and then process them all together after completing the loop.
QuestionSystem.Timers.Timer() called method doesn't run all code Pin
jsmjsm10-Jun-20 1:09
jsmjsm10-Jun-20 1:09 
AnswerRe: System.Timers.Timer() called method doesn't run all code Pin
Richard Deeming10-Jun-20 1:30
mveRichard Deeming10-Jun-20 1:30 
AnswerRe: System.Timers.Timer() called method doesn't run all code Pin
Luc Pattyn10-Jun-20 1:31
sitebuilderLuc Pattyn10-Jun-20 1:31 
QuestionUnable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395810-Jun-20 0:30
Member 1483395810-Jun-20 0:30 
AnswerRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
OriginalGriff10-Jun-20 0:40
mveOriginalGriff10-Jun-20 0:40 
AnswerRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Dave Kreskowiak10-Jun-20 2:14
mveDave Kreskowiak10-Jun-20 2:14 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395810-Jun-20 5:33
Member 1483395810-Jun-20 5:33 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Dave Kreskowiak10-Jun-20 19:17
mveDave Kreskowiak10-Jun-20 19:17 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395811-Jun-20 3:00
Member 1483395811-Jun-20 3:00 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Dave Kreskowiak11-Jun-20 3:21
mveDave Kreskowiak11-Jun-20 3:21 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395811-Jun-20 3:47
Member 1483395811-Jun-20 3:47 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Dave Kreskowiak11-Jun-20 3:50
mveDave Kreskowiak11-Jun-20 3:50 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395811-Jun-20 6:31
Member 1483395811-Jun-20 6:31 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Dave Kreskowiak11-Jun-20 7:55
mveDave Kreskowiak11-Jun-20 7:55 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Jörgen Andersson11-Jun-20 8:34
professionalJörgen Andersson11-Jun-20 8:34 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395811-Jun-20 21:24
Member 1483395811-Jun-20 21:24 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Jörgen Andersson11-Jun-20 22:31
professionalJörgen Andersson11-Jun-20 22:31 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395812-Jun-20 3:11
Member 1483395812-Jun-20 3:11 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Jörgen Andersson12-Jun-20 3:20
professionalJörgen Andersson12-Jun-20 3:20 
GeneralRe: Unable to load file or assembly 'Oracle.DataAccess' Pin
Member 1483395812-Jun-20 3:12
Member 1483395812-Jun-20 3:12 
QuestionI Want to be able to give more than one output until mobhp = 0? How do i do that? Pin
Ultra9609-Jun-20 3:20
Ultra9609-Jun-20 3:20 
AnswerRe: I Want to be able to give more than one output until mobhp = 0? How do i do that? Pin
jsc429-Jun-20 3:40
professionaljsc429-Jun-20 3:40 
Question[C#] Diffirent between thread and timer Pin
namnv97-Jun-20 15:55
professionalnamnv97-Jun-20 15:55 

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.