.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Paging with Dropdownlist

Posted By:satyapriyanayak       Posted Date: July 26, 2013    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

We will know paging with dropdownlist. Here in runtime numbers will be shown in the dropdown list when we choose any number that number of records will be shown in the gridview. Here paging facilities are also provided to the Gridview.
 

Default.aspx code


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Paging_with_dropdownlist._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:GridView id="g1" Runat="Server"
        AllowPaging="True"
        AutoGenerateColumns="true" onpageindexchanging="g1_PageIndexChanging" PagerStyle-Visible = "False" HeaderStyle-BackColor="Red"
     HeaderStyle-ForeColor="White" BackColor="#FFCC66">

<HeaderStyle BackColor="Red" ForeColor="White"></HeaderStyle>
        <AlternatingRowStyle BackColor="#FFFFCC" />

       
</asp:GridView>
        <asp:Label ID="Label1" runat="server" Text="Choose No." Font-Bold="True"
            ForeColor="#CC3300"></asp:Label>
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true"  onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem Text="5" Value="5"></asp:ListItem>
        <asp:ListItem Text="10" Value="10"></asp:ListItem>
        <asp:ListItem Text="15" Value="15"></asp:ListItem>
        <asp:ListItem Text="20" Value="20"></asp:ListItem>
        </asp:DropDownList>
    </div>
    </form>
</body>
</html>


Default.aspx.cs code

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Paging_with_dropdownlist
{
    public partial class _Default : System.Web.UI.Page
    {
        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;
        SqlDataAdapter sqlda;
        DataSet ds;
        string str;
        int size = 0;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DropDownList1.Items.Insert(0, ("Select"));
            }
        }
        void bindgrid()
        {
            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            str = "select * from employee";
            com = new SqlCommand(str, con);
            sqlda = new SqlDataAdapter(com);
            ds = new DataSet();
            sqlda.Fill(ds, "employee");
            g1.DataMember = "employee";
            g1.DataSource = ds;
            g1.DataBind();
            con.Close();
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {

            if (DropDownList1.SelectedItem.Text != "0")
            {
                size = int.Parse(DropDownList1.SelectedItem.Value.ToString());
                g1.PageSize = size;
                bindgrid();

            }
        }

        protected void g1_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            g1.PageIndex = e.NewPageIndex;
            bindgrid();
        }
    }
}



     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend