SharePoint

Display Data in Grid View

Hi Friends
In this article i will explain how to display data in grid view.
Step 1:
We created a database dotnetdb and with table name Employee.

USE [dotnetdb]
GO

/****** Object: Table [dbo].[Employee] Script Date: 01/03/2015 15:25:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Employee](
[EmpId] [nvarchar](50) NOT NULL,
[EmpName] [nvarchar](50) NOT NULL,
[EmpAddress] [nvarchar](50) NOT NULL,
[EmpDesignation] [nvarchar](50) NULL
) ON [PRIMARY]

GO

Step 2:

We created a empty web application with name GridView and selected a WebForm and renamed with name Displaydata.aspx.

UI Screen

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Displaydata.aspx.cs" Inherits="GridView.Displaydata" %>

<!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></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <asp:GridView ID="GridView1" runat="server">
    </asp:GridView>
    </div>
   
    </form>
</body>
</html>

Step:3

Businesslogic.

In Displaydata.aspx.cs write the business logic.

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

namespace GridView
{
    public partial class Displaydata : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection("Data Source = Chinnu;Initial Catalog = dotnetdb;uid = sa;password = password123;");
        protected void Page_Load(object sender, EventArgs e)
        {
            dataBindGrid();
        }

        public void dataBindGrid()
        { 
            SqlDataAdapter da = new SqlDataAdapter("select * from Employee",con);
            DataSet ds = new DataSet();
            da.Fill(ds); 
            GridView1.DataSource = ds;
            GridView1.DataBind(); 
        }
    }
}

Output:Finally Press F5 we can able to see the Output.

Display Data in Grid View

Labels