News
* IBM to offer mobile security as a service IBM will start delivering mobile security-as-a-service (MaaS) through its own cloud infrastructure in India, a move that is expected to better address in-country data requirements... IBM Spectrum Computing: IBM has enlarged its portfolio of software-defined infrastructure solutions with cognitive features for workload management.  * LiFi internet technology has been introduced, the new type of wireless internet connection that gives 100 times faster than traditional WiFi -- Invented by Professor Harald Haas from the University of Edinburgh. * Sci. Rachid Yazami has developed a smart chip that charges smartphones in less than 10 minutes. BenQ has launched BlueCore projector - Consumer electronics major BenQ has launched its first BlueCore laser light source projector. For those unaware, devices with BlueCore laser technology have a high contrast output of 80000:1 with an extended lamp life and efficiency. *** 
  Jan 25 2015 9:41AM     Michael Ryan
  0 Comments    4860 Views  
Here Michael Ryan provided a short tutorial with example, how to bind Gridview with autogenerate serial number column
Database
For binding the gridview, First have to create a table in Microsoft SQL Server Database as shown below.
Creating a table
When creating a table make Identity Specification as true for column 'ID'.

Set the table name as shown below.
Adding a GridView to the Page
Firstly you need to add a GridView control to the ASP.Net Web Page from the Visual Studio ToolBox as shown below.

HTML
Below is the sample HTML code,

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h2>
            Employee Details</h2>
        How to populate DropDownList in GridView in ASP.Net
        <br >
        <asp:GridView ID="GridEmployee" runat="server" AutoGenerateColumns="false" 
 CellPadding="5" Style="background-color: rgb(241, 241, 241); width: 50%;">

            <Columns>

                <asp:TemplateField HeaderText="S.No">
                    <ItemTemplate>
                        <%#Container.DataItemIndex+1 %>
                    </ItemTemplate>
                </asp:TemplateField>

<asp:BoundField HeaderText="EmployeeID" DataField="ID" />
                <asp:BoundField HeaderText="Name" DataField="EmployeeName" />
                <asp:BoundField HeaderText="Age" DataField="EmployeeAge" />
<asp:BoundField HeaderText="Age" DataField="EmployeeDesc" />                
                <asp:BoundField HeaderText="Experience" DataField="EmployeeExperience" />
            </Columns>
 <HeaderStyle BackColor="#81B441" Font-Bold="true" ForeColor="White" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>

XML
Below is the sample Web.config file Code,

<configuration>
  <connectionStrings>
    <add name="ConnectionString" connectionString="server=SERVER-NAME;database=DATABASE-NAME;uid=USER-ID;password=PASSWORD;"/>   
  </connectionStrings>

Namespaces
You will need to import the following namespace.
C#

using System.Data.SqlClient;
using System.Data;

VB

Imports System.Data.SqlClient
Imports System.Data

Binding Gridview with AutoGenerate Serial Number
Below is the sample code for Binding Gridview with AutoGenerate Serial Number in C#/VB.
C#

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                GridEmployee.DataSource = GetData("SELECT EmployeeName, EmployeeAge, EmployeeDesc, EmployeeExperience FROM Employee");
                GridEmployee.DataBind();
            }
        }

        private DataSet GetData(string query)
        {
            string conString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            SqlCommand cmd = new SqlCommand(query);
            using (SqlConnection con = new SqlConnection(conString))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataSet ds = new DataSet())
                    {
                        sda.Fill(ds);
                        return ds;
                    }
                }
            }
        }

VB

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

        If Not IsPostBack Then
            GridEmployee.DataSource = GetData("SELECT EmployeeName, EmployeeAge, EmployeeDesc, EmployeeExperience FROM Employee")
            GridEmployee.DataBind()
        End If

    End Sub
    
    Private Function GetData(ByVal query As String) As DataSet

        Dim conString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
        Dim cmd As SqlCommand = New SqlCommand(query)
        Dim con As SqlConnection = New SqlConnection(conString)
        Dim sda As SqlDataAdapter = New SqlDataAdapter()
        cmd.Connection = con
        sda.SelectCommand = cmd
        Dim ds As DataSet = New DataSet()
        sda.Fill(ds)
        Return ds

    End Function

Result
I hope this page will helps to create GridView with AutoGenerate Serial Number in ASP.Net application. Thanks.
BackToTop
Comments



 
Search
Recent Posts
Create Amazon ElasticCache Using Memcached in CSharp
Oct 29 2018 12:09PM Posted By Amose
Get Google Map Lat Lng (Geo Point) By Pincode in C#
Oct 28 2018 12:09PM Posted By Pranav
Google URL Shortener in C#
Oct 20 2018 12:09PM Posted By Sanjay
Bind Gridview from CSV file in Asp.Net C#
Oct 5 2018 12:09PM Posted By Michael
Call WebService method from jQuery in every 1 minute
Sep 26 2018 12:09PM Posted By John
Gridview custom CSS in ASP.Net
Sep 14 2018 12:09PM Posted By Micheal Ryan
Read excel file and bind to Gridview in C#
Sep 10 2018 12:09PM Posted By Micheal
Tags
Follow us on Facebook
Follow us on Google +
Recent post in your Email inbox.
Enter your email address: