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

Question

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?

Daniel Koh · Answer

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 dt5.Columns.Add(Fields[i].ToLower() typeof ( string )); DataRow Row; for ( int i = 1; i { Fields = Lines[i].Split( new char [] { '' }); Row = dt5.NewRow(); for ( int f = 0; f Row[f] = Fields[f]; dt5.Rows.Add(Row); } for ( int i = 0; 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) } } }

Ramesh Palanivel · Answer

Hi daniel your question is not that much clear for us to provide solution. Please add some sample code and screen shots.