Skip to main content

Posts

Showing posts from April, 2010

Gridview Sorting Problem

When you bind a List to a Gridview, you can not sort it, because your data source is not a Dataset, Dataview or DataTable. So you should convert your data source (List) to a Dataset for example.


You can do it such as following code:


 1publicstatic DataSet dsSearch()     2 {     3     4     DataTable dtTelcoCenter = new DataTable();     5     dtTelcoCenter.Columns.Add("Id", typeof(int));     6     dtTelcoCenter.Columns.Add("City", typeof(string));     7     dtTelcoCenter.Columns.Add("Capacity", typeof(int));     8     9     IList<Telco> telcoCenter = Search(centerName, Prefix);// Search method return a list    10    11    12foreach (Telco telco in telcoCenter)    13     {    14         DataRow rowTelcoCenter = dtTelcoCenter.NewRow();    15         rowTelcoCenter["Id"] = telco.Id;    16         rowTelcoCenter["City"] = telco.City;    17         rowTelcoCenter["Capacity"] = telco.Capacity;    18         dtTelcoCenter.Rows.Add(rowTelcoCenter)…

Rows to single column in Sql

Sample table as Cities in rows is convert to single column

declare @retstr varchar(8000) select Top 5 @retstr = COALESCE(@retstr + ';','') + City from State print @retstr