Sorting

[musnet2007]

i am using the below sample code for sort in repeater, it is sorting only in asc order, now i want to sort both direction, i am using defaultview.sort, using the same function can anyone help me Thankz connection open() strSql = "select fiel1,fie2 from tablename order by columname or (Request.QueryString("val"))" Dim da As New OleDbDataAdapter(strSql, connection) Dim ds As New DataSet da.Fill(ds) If Request.QueryString("val") = "" Then repeater.DataSource = ds.Tables(0) Else ds.Tables(0).DefaultView.Sort = Request.QueryString("val") repeater.DataSource = ds.Tables(0).DefaultView repeater.DataBind() End If connectionclose()

[Ajai Chaudhary]

Use your sql query in the followign manner it will sort the records in desecding order.

order by columname desc

The desc keyword followed by the column will arange the data into desecding order with regards Yogesh Agarwal

[eggsovereasy]

ds.Tables[0].DefaultView.Sort = Request.QueryString("val") + "desc"; But you will probably want to add someway to toggle between asc and desc.