private DataTable transposition(DataTable dt)
{
DataTable dtResult = new DataTable();
dtResult.Columns.Add("ItemText", typeof(string));
dtResult.Columns.Add("ItemValue", typeof(string));
foreach (DataColumn col in dt.Columns)
{
foreach (DataRow row in dt.Rows)
{
string value = String.Empty;
if (row[col] != null && !Convert.IsDBNull(row[col]) && row[col].ToString().ToLower() != "null")
{
value = row[col].ToString();
}
dtResult.Rows.Add(new string[] { col.ColumnName, value });
}
}
return dtResult;
}