Wednesday, 25 March 2015

GridView Row Number Increment Automatically in Asp.Net C#

No comments    
categories: ,
GridView Row Number Increment Automatically

Gridview Row Number Increment Automatically  Run Time Without Using DataBase Table  but Add DataItemIndex  Automatically Add in Asp.Net C#.


                              DEMO


HTML CODING


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title> </title>
</head>
<body>
    <form id="form1" runat="server">
      <div>
      <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Search" />
      

<table><tr><td> </td><td>   <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
                 <AlternatingRowStyle BackColor="#9999FF" />
                 <Columns>
                     <asp:TemplateField HeaderText="SNO">

                     <ItemTemplate>
               <%# Container.DataItemIndex + 1 %>
         </ItemTemplate>

                     </asp:TemplateField>
                     <asp:BoundField DataField="name" HeaderText="Name" />
                     <asp:BoundField DataField="country" HeaderText="Country" />
                 </Columns>
                 <HeaderStyle BackColor="#FF3300" />

                             <RowStyle BackColor="#FF99FF" />           
            </asp:GridView>
             </td></tr></table>  
        </div>
    </form>
</body>
</html>


                      C# CODING

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


public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }  

    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con.Open();

        SqlCommand cmd = new SqlCommand("select * from country",con);           

        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();

    }
}






















0 comments:

Post a Comment