Sorting gridview using code behind

Question

0.00/5 (No votes)

See more:

Dear all,

I am writing to seek help in creating 'sorting' feature on my gridview using code behind method. This is what i have so far and currently, its not sorting anything on the client-side. I am also getting the following error (Cannot implicitly convert type 'void' to 'System.Data.DataTable'), on the following line:

C#

DataTable table = BindGridview();

Any I missing any additional information? Any help would be very much appreciated.

ASP.NET

<asp:GridView ID="GridView1" runat="server" AllowSorting="True" >
    </asp:GridView>

C#

protected void SortRecords(object sender, GridViewSortEventArgs e)
{
    string sortExpression = e.SortExpression;
    string direction = string.Empty;

    if (SortDirection == SortDirection.Ascending)
    {
        SortDirection = SortDirection.Descending;
        direction = " DESC";
    }
    else
    {
        SortDirection = SortDirection.Ascending;
        direction = " ASC";
    }
   DataTable table = BindGridview();
   table.DefaultView.Sort = sortExpression + direction;
   GridView1.DataSource = table;
   GridView1.DataBind();
}

public SortDirection SortDirection
{
    get
    {
        if (ViewState["SortDirection"] == null)
        {
            ViewState["SortDirection"] = SortDirection.Ascending;
        }
        return (SortDirection)ViewState["SortDirection"];
    }
    set
    {
        ViewState["SortDirection"] = value;

    }

}

Further functional methods:

C#

protected void BindGridview()
     //public DataSet BindGridView()
    {

        string query = "select top 100 [Name], CUSIP, ISINs, [Size (m)],[Current size],priceTalk, [Decimal price], Cover, Type, UploadDate  from [dbo].[database_BWICs]";
        DataSet dt = GetData(query);
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

    private static DataSet GetData(string query)
    {
        DataSet dt = new DataSet();
        SqlCommand cmd = new SqlCommand(query);
        String constr = ConfigurationManager.ConnectionStrings["####"].ConnectionString;
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter();
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;
        sda.SelectCommand = cmd;
        sda.Fill(dt);
        return dt;
    }

Posted 15-Jan-14 5:14am

miss786

Updated 15-Jan-14 6:05am

v4

Add a Solution

Comments

Karthik_Mahalingam 15-Jan-14 12:01pm

post your full code..
something is missing out in the code..

miss786 15-Jan-14 12:08pm

Hi, Thank you for your response. I have updated my post with entire code I am currently using. If I am missing a method or something to make this functionality work, please do let me know. Thank you for your time and help.

2 solutions

Solution 1

Quote:

C#
DataTable table = this.BindGridView();
does not contain a definition for 'BindGridView' and no extension method 'BindGridView' accepting a first argument

The Exception is quite clear. There is no method like that.

I guess you should do like...

C#

DataTable table = BindGridView();

Else post the function code.

Posted 15-Jan-14 5:29am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

miss786 15-Jan-14 12:03pm

Hi, Thank you so much for your suggestion. I tired updating my code using your suggestion and now I am experiencing a new error (Cannot implicitly convert type 'void' to 'System.Data.DataTable'). I tried changing the 'DataTable table' function to 'Dataset' but that again gave me bunch of more errors. I have updated my post with additional methods as requested. Any suggestion would be most welcome. Thank you.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 15-Jan-14 12:19pm

That is because the return type of that function is void, but you are assigning it to a DataTable.
You should do like below... You should call GetData method.

DataSet table = GetData();
table.DefaultView.Sort = sortExpression + direction;
GridView1.DataSource = table;
GridView1.DataBind();

Karthik_Mahalingam 15-Jan-14 13:11pm

given 5!!! because i know you would ve given right solution, if OP posted full code at the begining..
since i got the right comment from OP, my solution was right..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 16-Jan-14 4:16am

Thanks a lot bro. :)

Karthik_Mahalingam 16-Jan-14 4:23am

welcome TD :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2014-01-15T06:10:00

do like this..

C#

protected  DataTable GetDataTable () // new method
     
    {

        string query = "select top 100 [Name], CUSIP, ISINs, [Size (m)],[Current size],priceTalk, [Decimal price], Cover, Type, UploadDate  from [dbo].[database_BWICs]";
        DataSet dt = GetData(query);
       

return dt.Tables[0];
 
    }

C#

protected void BindGridview()  // modify this method
     //public DataSet BindGridView()
    {
 
        var dt = GetDataTable( );
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

C#

protected void SortRecords(object sender, GridViewSortEventArgs e)
    {
        string sortExpression = e.SortExpression;
        string direction = string.Empty;

        if (SortDirection == SortDirection.Ascending)
        {
            SortDirection = SortDirection.Descending;
            direction = " DESC";
        }
        else
        {
            SortDirection = SortDirection.Ascending;
            direction = " ASC";
        }
       DataTable table = GetDataTable();
       table.DefaultView.Sort = sortExpression + direction;
       GridView1.DataSource = table;
       GridView1.DataBind();
    }

    public SortDirection SortDirection
    {
        get
        {
            if (ViewState["SortDirection"] == null)
            {
                ViewState["SortDirection"] = SortDirection.Ascending;
            }
            return (SortDirection)ViewState["SortDirection"];
        }
        set
        {
            ViewState["SortDirection"] = value;

        }

    }