Sorting the Gridview Columns via Code behind

[sivagururaja]

Hi All,

How can i sorting the Gridview Columns via the code behind.
When i tried to sorting the column it doesn't work.

SqlConnection con = new SqlConnection(" Connection
string");
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter( cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataS ource = ds;
GridView1.DataB ind();

Im using the AllowSorting=Tr ue and SortExperssion.
What's the mistake did i made?

Regards,
Raja.

[Bruno Piovan]

You need to handle the Sorting event of the GridView control, in this event
you are responsible for sorting the data and binding it back to the gridview
control.

something like:

DataView dv = myDataTable.Def aultView;
dv.Sort = e.SortDirection ;
gridView.DataSo urce = dv;
gridView.DataBi nd();

Bruno

<si**********@g mail.comwrote in message
news:11******** **************@ e65g2000hsc.goo glegroups.com.. .

Hi All,

How can i sorting the Gridview Columns via the code behind.
When i tried to sorting the column it doesn't work.

SqlConnection con = new SqlConnection(" Connection
string");
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter( cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataS ource = ds;
GridView1.DataB ind();

Im using the AllowSorting=Tr ue and SortExperssion.
What's the mistake did i made?

Regards,
Raja.

[mark4asp]

On 26 Mar, 14:56, sivagurur...@gm ail.com wrote:

Hi All,

How can i sorting the Gridview Columns via the code behind.
When i tried to sorting the column it doesn't work.

SqlConnection con = new SqlConnection(" Connection
string");
con.Open();
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter( cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataS ource = ds;
GridView1.DataB ind();

Im using the AllowSorting=Tr ue and SortExperssion.
What's the mistake did i made?

Regards,
Raja.

Have a look at Ryan Olson's code here.

<http://forums.asp.net/thread/1254336.aspx>
<http://community.strongcoders.com/content/
CSGridViewSorti ngPaging.aspx>

To sort the gridview remember that you must:

get the data to which the gridview will be bound.

get that data as a DataView.

sort it on a field name (from your datasource) either as ascending or
descending.