Tuesday 21 February 2017

Shorting Data Table in C#


dtViewState.DefaultView.Sort = "Column_Name Desc/Asc"
dtViewState = dtViewState.DefaultView.ToTable();

SQL Table : Change Row As Column and Group Them... ( Setting column values as column names in the SQL query result )

Setting column values as column names in the SQL query result Problem Statement : id col1 col2 1 Pending 30 1 Resolved 48 ...