Find Column Name according to values

Question

How to find columns name according to values in SQL ? Suppose that i have 5 columns in table . In every columns values is store. Now how can be find 5 value is store in which columns?

Priya Singh · Answer

helo Upendra Pratap Shahi hame sql query ke through findout krna hai c# nhi use krna hai

Upendra Pratap Shahi · Answer

DataTable DT = new DataTable (); foreach ( DataColumn column in DT.Columns) { Console .Write( Item:  ); Console .Write(column.ColumnName); Console .Write(   ); Console .WriteLine(row[column]); }