Advertisement
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
In Displaydata.aspx.cs write the business logic.
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
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:3Businesslogic.
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.
Advertisements
9F71B53FCF
ReplyDeletehacker kirala
hacker kirala
tütün dünyası
hacker bul
hacker kiralama
7780E735DF
ReplyDeleteTakipçi Satın Al
Whiteout Survival Hediye Kodu
Para Kazandıran Oyunlar
Razer Gold Promosyon Kodu
Pubg Hassasiyet Kodu (Sekmeyen Hassasiyet Kodu)