Create .aspx page like this.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Listview_Demo.aspx.cs"Inherits="listview.Listview_Demo" %>
<!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 id="Head1" runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListView ID="ListView1" runat="server">
<LayoutTemplate>
<table>
<tr>
<th>
ID
</th>
<th>
Sir Name
</th>
<th>
| Name
</th>
<th>
City
</th>
</tr>
<tr id="itemPlaceholder" runat="server"></tr>
</table>
</LayoutTemplate>
<ItemTemplate>
<tr>
<td>
<asp:Label ID="lblid" runat="server"><%#Eval("id")%></asp:Label>
</td>
<td>
<asp:Label ID="lblsname" runat="server"><%#Eval("SName")%></asp:Label>
</td>
<td>
<asp:Label ID="lblname" runat="server"><%#Eval("Name")%></asp:Label>
</td>
<td>
<asp:Label ID="lcity" runat="server"><%#Eval("City")%></asp:Label>
</td>
</tr>
</ItemTemplate
</asp:ListView>
</div>
</form>
</body>
</html>
Setp 2:
Your .cs file code like this.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace listview
{
public partial class Listview_Demo : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindListView();
}
}
private void BindListView()
{
using (DataClasses1DataContext dt = new DataClasses1DataContext())
{
var info = from emp in dt.EmpInfos
select emp;
if (info != null)
{
if (info.Count() > 0)
{
ListView1.DataSource = info;
ListView1.DataBind();
}
}
}
}
}
}
Now Creating ListViewDemo Database. Run the following create table query.
USE [ListViewDemo]
GO
/****** Object: Table [dbo].[EmpInfo] Script Date: 02/19/2012 01:07:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EmpInfo](
[id] [int] IDENTITY(1,1) NOT NULL,
[SName] [nvarchar](50) NULL,
[Name] [nvarchar](50) NULL,
[City] [nvarchar](50) NULL,
CONSTRAINT [PK_EmpInfo] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
I take linq to SQL as a Datasource so create .dbml file and add some dummy data in to Table.
Run this application. The output looks like this.