Click here to Skip to main content
14,640,145 members
Home » Discussions » C#
   

C#

 
AnswerRe: index was out of bound of the array Pin
Richard MacCutchan10-Jul-20 3:16
mveRichard MacCutchan10-Jul-20 3:16 
AnswerRe: index was out of bound of the array Pin
Dave Kreskowiak10-Jul-20 3:22
mveDave Kreskowiak10-Jul-20 3:22 
AnswerRe: index was out of bound of the array Pin
Swapnita Dessai19-Jul-20 0:47
MemberSwapnita Dessai19-Jul-20 0:47 
QuestionHow to map excel column value to custom defined object class Pin
Member 148591514-Jul-20 6:56
MemberMember 148591514-Jul-20 6:56 
AnswerRe: How to map excel column value to custom defined object class Pin
Mycroft Holmes4-Jul-20 13:53
professionalMycroft Holmes4-Jul-20 13:53 
GeneralRe: How to map excel column value to custom defined object class Pin
Member 148591515-Jul-20 3:41
MemberMember 148591515-Jul-20 3:41 
GeneralRe: How to map excel column value to custom defined object class Pin
Mycroft Holmes5-Jul-20 12:33
professionalMycroft Holmes5-Jul-20 12:33 
GeneralRe: How to map excel column value to custom defined object class Pin
Member 148591516-Jul-20 1:46
MemberMember 148591516-Jul-20 1:46 
Here is the function:

public static IList<TestDataModel> GetAllTestData(string keyName)
        {
            DataSet ds = new DataSet();
            DataNamesMapper<TestDataModel> mapper = new DataNamesMapper<TestDataModel>();
            DataTable dataTableALL = new DataTable();
            List<TestDataModel> testData = new List<TestDataModel>();
            using (var connection = new
                          OdbcConnection(TestDataFileConnection()))
            {
                connection.Open();
                OdbcCommand cmd = new OdbcCommand();
                cmd.Connection = connection;

                System.Data.DataTable dtSheet = null;
                dtSheet = connection.GetSchema(OdbcMetaDataCollectionNames.Tables, null);
                foreach (DataRow row in dtSheet.Rows)
                {
                    string sheetName = row["TABLE_NAME"].ToString();

                    if (!sheetName.EndsWith("$"))
                        continue;

                    // Query each excel sheet.
                    var query = string.Format("select * from [{0}] where TestName = '{1}'", sheetName, keyName);
                    cmd.CommandText = query;

                    DataTable dt = new DataTable();
                    dt.TableName = sheetName;

                    OdbcDataAdapter da = new OdbcDataAdapter(cmd);
                    da.Fill(dt);
                    ds.Tables.Add(dt);
                }
                cmd = null;
                connection.Close();
            }
            DataTable data= JoinExcelDatatoOneRow(ds);
            testData = mapper.Map(data).ToList();
            return testData.ToList();
        
        }

AnswerRe: How to map excel column value to custom defined object class Pin
Mycroft Holmes6-Jul-20 12:49
professionalMycroft Holmes6-Jul-20 12:49 
QuestionHow to get the actual, GENERATED source code from my site? Pin
Member 139493623-Jul-20 10:05
MemberMember 139493623-Jul-20 10:05 
AnswerRe: How to get the actual, GENERATED source code from my site? Pin
Mycroft Holmes3-Jul-20 12:30
professionalMycroft Holmes3-Jul-20 12:30 
AnswerRe: How to get the actual, GENERATED source code from my site? Pin
F-ES Sitecore5-Jul-20 5:31
mveF-ES Sitecore5-Jul-20 5:31 
QuestionTask.Run.Wait Pin
Bernhard Hiller3-Jul-20 0:16
MemberBernhard Hiller3-Jul-20 0:16 
AnswerRe: Task.Run.Wait Pin
OriginalGriff3-Jul-20 0:49
mveOriginalGriff3-Jul-20 0:49 
GeneralRe: Task.Run.Wait Pin
Bernhard Hiller3-Jul-20 2:18
MemberBernhard Hiller3-Jul-20 2:18 
GeneralRe: Task.Run.Wait Pin
OriginalGriff3-Jul-20 4:00
mveOriginalGriff3-Jul-20 4:00 
AnswerRe: Task.Run.Wait Pin
jsc423-Jul-20 6:31
professionaljsc423-Jul-20 6:31 
QuestionStrange characters in JSON RPC server response Pin
pkfox1-Jul-20 3:37
professionalpkfox1-Jul-20 3:37 
AnswerRe: Strange characters in JSON RPC server response Pin
Luc Pattyn1-Jul-20 5:33
sitebuilderLuc Pattyn1-Jul-20 5:33 
GeneralRe: Strange characters in JSON RPC server response Pin
pkfox1-Jul-20 6:23
professionalpkfox1-Jul-20 6:23 
GeneralRe: Strange characters in JSON RPC server response Pin
pkfox1-Jul-20 6:46
professionalpkfox1-Jul-20 6:46 
GeneralRe: Strange characters in JSON RPC server response Pin
Luc Pattyn1-Jul-20 9:36
sitebuilderLuc Pattyn1-Jul-20 9:36 
GeneralRe: Strange characters in JSON RPC server response Pin
pkfox1-Jul-20 10:40
professionalpkfox1-Jul-20 10:40 
GeneralRe: Strange characters in JSON RPC server response Pin
Luc Pattyn5-Jul-20 3:27
sitebuilderLuc Pattyn5-Jul-20 3:27 
GeneralRe: Strange characters in JSON RPC server response Pin
pkfox5-Jul-20 5:45
professionalpkfox5-Jul-20 5:45 

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.