How to sort data into GridView

DataView DV = DT.DefaultView;

DV.Sort = "FullName";

by writing these two lines you can sort the data into dataview sorting data into dataview is fast and easer

Re: How to sort data into GridView

hi,

Reload teh dataview by sorting the dataset/Datatable with the clicked value.

or change teh view to Grid and again reload at every time with the sorting colum header/adn default column header .

Re: How to sort data into GridView

public DataTable GetTable()
    {
        string connectionString = "...Northwind...";
        DataTable customers = new DataTable("Customers");

        using (SqlConnection connection =
                      new SqlConnection(connectionString))
        {
            SqlCommand selectAllCustomers =
                               connection.CreateCommand();
            selectAllCustomers.CommandText =
                              "SELECT * FROM [Customers]";

            connection.Open();
            customers.Load(selectAllCustomers.ExecuteReader
                        (CommandBehavior.CloseConnection));
        }

        return customers;

private void Form1_Load(object sender, EventArgs e)
    {
        dataGridView1.DataSource = GetTable().DefaultView;

	dv.Sort = "Name ASC";
        dataGridView1.DataSource = dv;
    }

-------------------

I hope this will help you

Re: How to sort data into GridView

Please note, your sorting will be effective only if you select the PrimaryKey Item in your query string.

KBN Sarma

Re: How to sort data into GridView

Sorting can be performed quite well even if you do not select the PrimaryKey Item in your query string.

Any of the data columns can be effectively sorted on.

Re: How to sort data into GridView

Thank you for your information. Earlier I tried, but it gave some problems.

Regards, KBN Sarma

Re: How to sort data into GridView

using

System;

using

System.Data;

using

System.Configuration;

using

System.Collections;

using

System.Web;

using

System.Web.Security;

using

System.Web.UI;

using

System.Web.UI.WebControls;

using

System.Web.UI.WebControls.WebParts;

using

System.Web.UI.HtmlControls;

using

System.Data.SqlClient;

public

partial class treenrepeater : System.Web.UI.Page

{

SqlConnection con = new SqlConnection (ConfigurationManager.AppSettings["conn"]);

SqlDataAdapter da;

DataSet ds;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

tree();

rep();

int a = 9;

Response.Write(a);

grd();

}

static void Main(string[] args)

{ }

public void tree()

{

string s = "select * from category";

da =

new SqlDataAdapter(s, con);

ds =

new DataSet();

da.Fill(ds,

"s");

//TreeView1.Parent = "f";

foreach (DataRow dr in ds.Tables[ "s"].Rows)

{

TreeNode tr = new TreeNode(dr[ "category_name"].ToString());

TreeView1.Nodes.Add(tr);

//string str="select sub_cat_name from sub_category where cat_id=(select cat_id from category where category_name='"+TreeView1.SelectedNode.Value+"')";

string str = "select * from sub_category where cat_id='" + dr[ "cat_id"].ToString() + "'";

da =

new SqlDataAdapter(str, con);

ds =

new DataSet();

da.Fill(ds,

"aa");

foreach (DataRow dd in ds.Tables[ "aa"].Rows)

{

TreeNode t1 = new TreeNode(dd[ "sub_cat_name"].ToString());

tr.ChildNodes.Add(t1);

string ss = "select * from product where sub_cat_id='" + dd[ "sub_cat_id"] + "'";

da =

new SqlDataAdapter(ss, con);

ds =

new DataSet();

da.Fill(ds,

"as");

foreach (DataRow df in ds.Tables[ "as"].Rows)

{

TreeNode t2 = new TreeNode(df[ "product_name"].ToString());

t1.ChildNodes.Add(t2);

}

//TreeView1.DataSource = ds.Tables["s"];

//TreeView1.DataBind();

}

public void rep()

{

string s = "select * from category";

da =

new SqlDataAdapter(s, con);

ds =

new DataSet();

da.Fill(ds,

"s");

Repeater1.DataSource = ds.Tables[

"s"];

Repeater1.DataBind();

//string st = "select * from sub_category where cat_id='"+Repeater1";

//da = new SqlDataAdapter(st, con);

//ds = new DataSet();

//da.Fill(ds, "s");

}

protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)

{

if (TextBox1.Text == "anish")

{

args.IsValid =

true;

Response.Write(

"abc");

}

else

args.IsValid =

false;

}

protected void Button1_Click(object sender, EventArgs e)

{

//Response.Write(TextBox1.Text);

}

protected void Button1_Click1(object sender, EventArgs e)

{

Response.Redirect(

"default.aspx?a="+TextBox1.Text);

}

public void grd()

{

string s = "select * from product";

da =

new SqlDataAdapter(s, con);

ds =

new DataSet();

da.Fill(ds,

"s");

GridView1.DataSource = ds.Tables[

"s"];

GridView1.DataBind();

}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

{

//string s = GridView1.SortExpression;

//e.SortExpression = s;

SqlDataAdapter da1 = new SqlDataAdapter ("Select * from product",con);

DataTable dt = new DataTable();

da1.Fill(dt);

DataView dv = new DataView(dt);

//dv.Sort

// GridView1.DataSource = dv.Sort;

//GridView1.DataBind();

dv.Sort = e.SortExpression +

" " + "ASC";

GridView1.DataSource = dv;

GridView1.DataBind();

//string s = GridView1.SortExpression;

//string r = e.SortExpression;

//if (s.IndexOf(r) < 0)

//{

// if (r.Length > 0)

// {

// e.SortExpression = r + "," + s;

// }

// else

// {

// e.SortExpression = r;

// }

//}

//else

//{

// e.SortExpression = s;

//}

}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)

{

}

Re: How to sort data into GridView

Hi,

You can enable the sorting to true in design mode of gridview. Also for each boundfield, provide a sort expression. Now depending on the sorting expression you can query the database.

Re: How to sort data into GridView

To Sort the Items in asp.net data grid double click on the title tag. It will be get sorted.

Re: How to sort data into GridView

Is it so much difficult to implement sorting in GridView? Anyways, I think you can just use "sorting=True" in the properties of the gridview.

Sorry if my understanding is wrong on this query....

Re: How to sort data into GridView

While fetching ur data from data base try to add OrderBy Asceding or descending clause with ur select sattement.

hope this helps

sam

Re: How to sort data into GridView

how to sort data when the columns are dynamically generated at runtime .sorting when done to . its possible to sort in one direction but suppose we hav made it ascending how do we make it descending on the next click on header. please give a full working example .as i have tried many options but somehow it's not working fine. also sorting direction and criteria should be maintained across all pages of the data gridview. take a gridview data of simple 3 columns and therir headers are not harcoded but rather dynamically created. Please give a working solution. i'm stuck