Problem in gridview at dropdown list select event

Question

0.00/5 (No votes)

See more:

Following is the code that I have written:-

C#

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
  {
      SqlCommand com1 = new SqlCommand("quot;select sno,adv,city from adv1 where categry=@b",con);
      com1.Parameters.AddWithValue("@b", DropDownList1.Text);
      con.Open();
      GridView1.DataSource = com1.ExecuteReader();
      con.Close();
      GridView1.DataBind();
}

And under grid view I have the following:

C#

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.AllowPaging = true;
    }

It gives this error: "The data source does not support server-side data paging."
anyone can help?

Posted 16-Feb-11 3:01am

vikas_3000

Updated 16-Feb-11 3:46am

Henry Minute

v4

Add a Solution

3 solutions

Solution 2

Take your error message (the part between the quotes) and paste it into the search box of your favourite internet search engine then hit return.

You will find almost all the possible solutions in the hits that you get.

Have a read until you find one that works for your situation.

Posted 16-Feb-11 3:50am

Henry Minute

Solution 3

You can try as bellow:

C#

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
  {
      SqlCommand com1 = new SqlCommand("select sno,adv,city from adv1 where categry=@b",con);
      com1.Parameters.AddWithValue("@b", DropDownList1.Text);
      con.Open();

      SqlDataAdapter da=new SqlDataAdapter(com1); 
      DataSet ds=new DataSet();
      da.Fill(ds);
      GridView1.DataSource = ds.Tables[0];
      GridView1.DataBind();
      con.Close();
}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        //GridView1.PageIndex = e.NewPageIndex; //with or without
        GridView1.AllowPaging = true;
    }

Thanks,
Mamun

Posted 16-Feb-11 3:55am

Abdul Quader Mamun

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)

Sandeep Mewara · Accepted Answer · 2011-02-16T03:50:00

Solution 1

In order to have paging you need to use DataAdapter. ExecuteReader is forward only, connected data form. Thus you won't be able to have server side pagin.

UPDATE:
Similar discussions: Link 1[^], Link 2[^]

Try something like:

DataTable dt = new DataTable();       
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

Posted 16-Feb-11 3:50am

Sandeep Mewara

Updated 16-Feb-11 3:54am

v2

Comments

vikas_3000 16-Feb-11 10:50am

thank you
i try dataset earlier but that also not works but this is working thanks again