checking excel row values and return column header in c# win

Hi, I currently have program that checks a date that is selected in MonthCalendar and uses it to search through the first column [date] for a matching value before performing a function. This function is to check the rest of the columns among the same row for a certain Value and then returning the column headers that have that Value. How do I do this?

private void button1_Click(object sender, EventArgs e)
{
string date = monthCalendar1.SelectionRange.Start.ToShortDateString();
string CSVFilePathName = @"pathname.csv";
string[] Lines = File.ReadAllLines(CSVFilePathName);
string[] Fields;
Fields = Lines[0].Split(new char[] { ',' });
int Cols = Fields.GetLength(0);
DataTable dt5 = new DataTable();
for (int i = 0; i < Cols; i++)
dt5.Columns.Add(Fields[i].ToLower(), typeof(string));
DataRow Row;
for (int i = 1; i < Lines.GetLength(0); i++)
{
Fields = Lines[i].Split(new char[] { ',' });
Row = dt5.NewRow();
for (int f = 0; f < Cols; f++)
Row[f] = Fields[f];
dt5.Rows.Add(Row);
}
for (int i = 0; i < 29; i++)
{
Object o = dt5.Rows[i]["date"];
if (o.ToString() == date)
{
(INSERT CODE HERE TO CHECK REST OF COLUMNS ON SAME ROW AND RETURN COLUMN HEADER)
}
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Daniel Koh8y ago
1. private void button1_Click(object sender, EventArgs e)
2. {
3. string date = monthCalendar1.SelectionRange.Start.ToShortDateString();
5. string CSVFilePathName = @"pathname.csv";
6. string[] Lines = File.ReadAllLines(CSVFilePathName);
7. string[] Fields;
8. Fields = Lines[0].Split(new char[] { ',' });
9. int Cols = Fields.GetLength(0);
10. DataTable dt5 = new DataTable();
11. for (int i = 0; i < Cols; i++)
12. dt5.Columns.Add(Fields[i].ToLower(), typeof(string));
13. DataRow Row;
14. for (int i = 1; i < Lines.GetLength(0); i++)
15. {
16. Fields = Lines[i].Split(new char[] { ',' });
17. Row = dt5.NewRow();
18. for (int f = 0; f < Cols; f++)
19. Row[f] = Fields[f];
20. dt5.Rows.Add(Row);
21. }
23. for (int i = 0; i < 29; i++)
24. {
25. Object o = dt5.Rows[i]["date"];
26. if (o.ToString() == date)
27. {
28. (INSERT CODE HERE TO CHECK REST OF COLUMNS ON SAME ROW AND RETURN COLUMN HEADER)
29. }
30. }
31. }