Click here to Skip to main content
15,914,258 members
Search within:


Home / Discussions / C#
   

C#

 
FirstPrevNext
GeneralRe: How To Write And Comsume An Async Method Pin
Kevin Marois12-Jun-20 9:54
professionalKevin Marois12-Jun-20 9:54 
GeneralRe: How To Write And Comsume An Async Method Pin
Richard Deeming14-Jun-20 23:44
mveRichard Deeming14-Jun-20 23:44 
GeneralRe: How To Write And Comsume An Async Method Pin
Kevin Marois15-Jun-20 7:31
professionalKevin Marois15-Jun-20 7:31 
GeneralRe: How To Write And Comsume An Async Method Pin
Richard Deeming15-Jun-20 7:38
mveRichard Deeming15-Jun-20 7:38 
GeneralRe: How To Write And Comsume An Async Method Pin
Kevin Marois15-Jun-20 7:41
professionalKevin Marois15-Jun-20 7:41 
GeneralRe: How To Write And Comsume An Async Method Pin
Richard Deeming15-Jun-20 7:50
mveRichard Deeming15-Jun-20 7:50 
GeneralRe: How To Write And Comsume An Async Method Pin
Kevin Marois15-Jun-20 9:01
professionalKevin Marois15-Jun-20 9:01 
QuestionRemoving a field from jSon String Pin
simpledeveloper11-Jun-20 8:00
simpledeveloper11-Jun-20 8:00 
AnswerRe: Removing a field from jSon String Pin
OriginalGriff11-Jun-20 22:44
mveOriginalGriff11-Jun-20 22:44 
GeneralRe: Removing a field from jSon String Pin
simpledeveloper12-Jun-20 9:05
simpledeveloper12-Jun-20 9:05 
GeneralRe: Removing a field from jSon String Pin
OriginalGriff12-Jun-20 9:06
mveOriginalGriff12-Jun-20 9:06 
AnswerRe: Removing a field from jSon String Pin
James Curran17-Jun-20 20:23
James Curran17-Jun-20 20:23 
QuestionIs there any good C# desktop library to implement Card liked UI dashboard? Pin
yccheok11-Jun-20 6:31
yccheok11-Jun-20 6:31 
AnswerRe: Is there any good C# desktop library to implement Card liked UI dashboard? Pin
Richard MacCutchan11-Jun-20 21:36
mveRichard MacCutchan11-Jun-20 21:36 
GeneralRe: Is there any good C# desktop library to implement Card liked UI dashboard? Pin
yccheok12-Jun-20 6:13
yccheok12-Jun-20 6:13 
GeneralRe: Is there any good C# desktop library to implement Card liked UI dashboard? Pin
Richard MacCutchan12-Jun-20 6:43
mveRichard MacCutchan12-Jun-20 6:43 
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 
Hello Everyone,

I'm currently trying to fetch data from 1 excel workbook, which is having multiple sheets

Please find my excel sheet: here

Please find my code to get the excel data

C#
<pre>public static T GetAllTestData<T>(string keyName)
        {
            using (var connection = new
                          OdbcConnection(TestDataFileConnection()))
            {
                connection.Open();
                System.Data.DataTable dt = null;
                dt = connection.GetSchema(OdbcMetaDataCollectionNames.Tables, null);
                String[] excelSheets = new String[dt.Rows.Count];
                var i = 0;
                // Add the sheet name to the string array.
                foreach (DataRow row in dt.Rows)
                {
                    excelSheets[i] = row["TABLE_NAME"].ToString();
                    i++;
                }
                T value = default(T);
                // Loop through all of the sheets if you want to...
                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();
                }
                //Console.Write(list1);
                connection.Close();
                return value;
            }
        }



Call to the function:

var param1 = AccessExcelData.GetAllTestData<TestDataModel>("Test1");


Issue:

I want to get all the values from all the sheets in excel which has TestName as "Test1" but in my method, variable value keep getting override which makes it tough for me to get all the values

Can someone look into this, or If I can have another approach for handling excel data test in c#
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 
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 
Last Visit: 31-Dec-99 18:00     Last Update: 9-Jun-24 2:12Refreshᐊ Prev1...207208209210211212213214215216 Next ᐅ

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.


Advertise
Privacy
Cookies
Terms of Use
Last Updated 8 Jun 2024
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web01 2.8:2024-05-30:1