«

Hi,
I am using a datagrid, with two columns(ID is the keyfield). Now
data in the grid is being sorted by this ID. How can I sort data on
the Name DataField.

<Columns>
<asp:BoundColumn DataField="ID" HeaderText="ID"></asp:BoundColumn>
<asp:BoundColumn DataField="Name" HeaderText="Name"></asp:BoundColumn>
</Columns>


Can someone help me out please.
Thanks in Advance

Hi Xarky,

If you are using DataSet or DataTable as data source of
your datagrid, you can sort by Name by following code:

DataView dv = Ds.Tables[0].DefaultView; // or
tbl.DefaultView
dv.Sort = "Name"; // or Desc: dv.Sort = "Name Desc"
Datagrid.DataSource = dv;
Daatagrid.DataBind();

And if you use DataReader as data source, you need change
sql query.

Select * from table_name Order By Name

HTH

Elton Wang



>-----Original Message-----
>Hi,
> I am using a datagrid, with two columns(ID is the
keyfield). Now
>data in the grid is being sorted by this ID. How can I
sort data on
>the Name DataField.
>
><Columns>
><asp:BoundColumn DataField="ID"
HeaderText="ID"></asp:BoundColumn>
><asp:BoundColumn DataField="Name"
HeaderText="Name"></asp:BoundColumn>
></Columns>
>
>
>Can someone help me out please.
>Thanks in Advance
>.
>

Hi,
I am using a DataSet. Thanks, that solved my problem.



*** Sent via Developersdex http://www.developersdex.com ***