paging in gridview using asp.net?

Question

0.00/5 (No votes)

See more:

Dear All,
I created one web page and that page in i writed code like below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Gridpage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
LoadData();
BindGridView();
}
}
private void LoadData()
{
string constr = "Data Source=.;Database=abcClassifieds;user id=sa;password=123;";
string query = "SELECT ID, ContactPhoto, Title, Description, Price, City, DateAdded FROM productDetailsTable where categories='education'";

SqlDataAdapter da = new SqlDataAdapter(query, constr);
DataTable table = new DataTable();
da.Fill(table);
GridView1.DataSource = table;
GridView1.DataBind();
}
protected void BindGridView()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
SqlDataReader sdr = null;
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;

switch (DropDownList1.SelectedValue)
{
case "High To Low":
cmd.CommandText = "Select * From productDetailsTable where categories='education' order by price desc";
break;
case "Low To High":
cmd.CommandText = "select * from productDetailsTable where categories='education' order by price asc";
break;
case "Recently Ads":
cmd.CommandText = "select * from productDetailsTable where categories='education' order by id desc";
break;
default:
break;
}
try
{
sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
finally
{
GridView1.DataSource = sdr;
GridView1.DataBind();

if (!sdr.IsClosed)
{
sdr.Dispose();
sdr.Close();
}
con.Close();
con.Dispose();
}
}
protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{
BindGridView();
}
}

here got a small error like :The data source does not support server-side data paging.

how resolve this problem please reply me

Posted 26-Mar-14 23:03pm

member258

Add a Solution

Comments

Tom Marvolo Riddle 28-Mar-14 0:20am

May i know what's the reason for rejecting the accepted answer?

member258 28-Mar-14 1:15am

this page contain gridview and dropdownlist,
once selecteditem in dropdownlist high to low and low to high coming properly
but here in gridview with dropdownlist and paging is not coming properly output
thats am rejected please dont mind jas

member258 28-Mar-14 1:19am

Dear Jas dont mind please

Tom Marvolo Riddle 28-Mar-14 1:26am

Hi no worries,it's not an issue.Did u see my last comment yesterday?
The comment clearly shows that in selectedindexchanged event of dropdownlist according to the selected value gridview will be bind.

In paging bind the recent method().If you have any issues feel free to ask

I guess the answer is clear enough .Then it's upto you and cheers :)

member258 28-Mar-14 2:21am

Dear Jas please check this code here cmd error

public partial class Gridpage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
LoadData();
BindGridView();
}
}
private void LoadData()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString);

string query = "SELECT ID, ContactPhoto, Title, Description, Price, City, DateAdded FROM productDetailsTable where categories='education'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();

da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

protected void BindGridView()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString);

if (DropDownList1.SelectedItem.Text == "High To Low")
{
SqlCommand cmd = new SqlCommand("Select * From productDetailsTable where categories='education' order by price desc", con);
}
else if (DropDownList1.SelectedItem.Text == "Low To High")
{
SqlCommand cmd = new SqlCommand("select * from productDetailsTable where categories='education' order by price asc", con);
}
else if (DropDownList1.SelectedItem.Text == "Recently Ads")
{
SqlCommand cmd = new SqlCommand("select * from productDetailsTable where categories='education' order by id desc", con);
}

SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{
BindGridView();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindGridView();
}
}

member258 28-Mar-14 1:31am

once check this please yesteday comment:

protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["abcConnectionString"].ConnectionString);
string query = "SELECT ID, ContactPhoto, Title, Description, Price, City, DateAdded FROM productDetailsTable where categories='education'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

if (DropDownList1.SelectedItem.Text == "High To Low")
{
SqlCommand cmd1 = new SqlCommand("Select * From productDetailsTable where categories='education' order by price desc", con);
}
else if (DropDownList1.SelectedItem.Text == "Low To High")
{
SqlCommand cmd1 = new SqlCommand("select * from productDetailsTable where categories='education' order by price asc", con);
}
else if (DropDownList1.SelectedItem.Text == "Recently Ads")
{
SqlCommand cmd1 = new SqlCommand("select * from productDetailsTable where categories='education' order by id desc", con);
}
}

and here in gridview settings without allowpaging=true working fine but with allowpaging=true is not working

Tom Marvolo Riddle 28-Mar-14 1:54am

FYI.post comment in reply then only i get notification

Buddy again the logic is incorrect.Just change like this

protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{

BindPagingGrid();

}

private void BindPagingGrid()
{
if(DropDownList1.SelectedItem.Text == "High To Low")
{
SqlCommand cmd = new SqlCommand("High To Low Query", con);
}
else if//another condition
{
//another query
}
else if
{
//another query
}
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
}

and in pageindexchanging call this BindPagingGrid();

1 solution

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)

Tom Marvolo Riddle · Accepted Answer · 2014-03-26T23:11:00

Solution 2

C#

try
{
sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);//Use Dataset/Datatable 
}
finally
{
GridView1.DataSource = sdr;
GridView1.DataBind();
 }

Don't use datareader when binding with data controls.

Posted 26-Mar-14 23:11pm

Tom Marvolo Riddle

Comments

member258 27-Mar-14 5:20am

these line am already used please check my code reply me please

Tom Marvolo Riddle 27-Mar-14 5:23am

Do you see the comments in the code block?. You are using DataReader sdr. Get the values in DataSet or DataTable and bind it with gridview

member258 28-Mar-14 2:50am

Jas got output thank you jas thank you so much

member258 28-Mar-14 2:33am

the name cmd does not exist in the current context

this is the error

member258 27-Mar-14 5:23am

here how i can modify please reply me

member258 27-Mar-14 5:24am

please modify and reply me please jas

Tom Marvolo Riddle 27-Mar-14 5:26am

please wait...

member258 27-Mar-14 5:27am

ok sure am waiting.........

Tom Marvolo Riddle 27-Mar-14 5:30am

Try like this:
SqlCommand cmd = new SqlCommand("Your query", con);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

member258 27-Mar-14 5:41am

this code change after that same error

i changed in loaddata(); only

Tom Marvolo Riddle 27-Mar-14 5:45am

It won't work and nothing wrong with loaddata method.First understand the issue.In switchcase, you are getting the value in DataReader you should change that to Dataset/DataTable

member258 27-Mar-14 5:45am

and design part:

<body>
<form id="form1" runat="server">
<div>

<br />
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged1">
<asp:ListItem>Recently Ads
<asp:ListItem>High To Low
<asp:ListItem>Low To High

<asp:GridView ID="GridView1" runat="server"
HeaderStyle-HorizontalAlign="Justify" PageSize="10" AllowPaging="true"
GridLines="Horizontal" Width="100%" AutoGenerateColumns="False"
onpageindexchanging="GridView1_PageIndexChanging">
<columns>
<asp:CommandField ShowSelectButton="True" Visible="False" />
<asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True"
ControlStyle-Width="5%" SortExpression="Id" />
<asp:TemplateField HeaderText="Image" SortExpression="Image">
<edititemtemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ContactPhoto") %>'>

<itemtemplate>
<asp:Image ID="Image2" Height="100px" Width="100px" runat="server" ImageUrl='<%# Bind("ContactPhoto") %>'>

<asp:TemplateField HeaderText="Title" SortExpression="Title" ControlStyle-Width="10%">
<edititemtemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'>

<itemtemplate>
<asp:LinkButton ID="LinkButton2" runat="server" Text='<%# Bind("Title") %>'>

<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description"
ControlStyle-Width="10%" />
<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" DataFormatString="{0:C}"
ControlStyle-Width="15%" />
<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" ControlStyle-Width="15%" />
<asp:BoundField DataField="DateAdded" HeaderText="DateAdded" SortExpression="DateAdded"
ControlStyle-Width="10%" />

<PagerSettings FirstPageText="First" LastPageText="Last"
Mode="NumericFirstLast" />

</div>
</form>
</body>

member258 27-Mar-14 5:47am

ok jas

Tom Marvolo Riddle 27-Mar-14 5:48am

protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{
BindGridView(); //Remove this and try
}

Try it and let me know

member258 27-Mar-14 5:56am

thank you jas i got output

thank you so much and one thing generally no times i posted so many questions
in code project no.of questions resolved from your answers only not others and thanks for your replying

Tom Marvolo Riddle 27-Mar-14 5:57am

I'm glad it helped and You're welcome!

member258 27-Mar-14 5:59am

dear jas here drop downlist not working paging ok but dropdownlist i want low to high and high to low with pageindex

please check

Tom Marvolo Riddle 27-Mar-14 6:07am

Buddy just change the way.I'll show the format .Just try.

protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{
IF(DropDownList1.SelectedItem.Text == "High To Low")
{
SqlCommand cmd = new SqlCommand("High To Low Query", con);
}
else if//another condition
{
//another query
}
else if//another condition
{
//another query
}
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

}

Just try and let me know

member258 28-Mar-14 2:23am

SqlDataAdapter adap = new SqlDataAdapter(cmd);

here cmd error coming please modify and reply me

Tom Marvolo Riddle 28-Mar-14 2:28am

what's the error?always include the error

Tom Marvolo Riddle 28-Mar-14 2:35am

Click this reply button to reply message
SqlCommand cmd = new SqlCommand();

create this before pageload
and change this
SqlCommand cmd = new SqlCommand("High To Low Query", con);

to
cmd = new SqlCommand("High To Low Query", con);