
Hi Friends,
In these tutorials you see the concept of creating a dynamic DataTable, retrieve Data from Database and store in DataTable, Binding DataTable Data to Gridview Controls.
Create Database
USE [master] GO /****** Object: Table [dbo].[Book] Script Date: 05/11/2015 15:04:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Book]( [Book_Id] [nvarchar](5) NULL, [Book_name] [nvarchar](50) NULL, [Book_author] [nvarchar](30) NULL, [Book_Publisher_name] [nvarchar](50) NULL, [Book_Published_date] [nvarchar](30) NULL ) ON [PRIMARY] GO INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'bk', N'sfjskj', N'jfdskfj', N'fjdksjfk', N'4/4/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'bk8', N'kk', N'kk', N'kk', N'4/8/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk1', N'ASP.NET', N'Krishna', N'MyHome Publisher', N'3/30/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk2', N'C#.NET', N'Arvind', N'James Street Publishers', N'3/30/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk3', N'SQL SERVER', N'James', N'Hi-Tech Publishers', N'3/30/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk4', N'JAVA', N'JAVA RAM', N'MyHome Publisher', N'3/30/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk5', N'HTML', N'HTML Raghu', N'James Street Publishers', N'3/30/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk6', N'CSS', N'CSS Chandra', N'Hi-Tech Publishers', N'3/30/2015 12:00:00 AM') INSERT [dbo].[Book] ([Book_Id], [Book_name], [Book_author], [Book_Publisher_name], [Book_Published_date]) VALUES (N'Bk7', N'JAVASCRIPT', N'JAVA RAM', N'MyHome Publishers', N'3/30/2015 12:00:00 AM')
HTML Markup : Add Gridview to ASP.NET Page
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication1.Gridviews.WebForm1" %> <!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"> <!--- ADD CSS Code Here ----> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" HeaderStyle-CssClass="HeaderStyle" </asp:GridView> </div> </form> </body> </html>
C# Coding
C# Coding : Namespace
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; using System.Configuration;
C# Coding : Page Load
public partial class Add_ListofDealer : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillGridview1(); } } }
C# Coding : Bind Gridview
public void FillGridview() { try { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcon"].ConnectionString); string sqlquery = "Select * from Book"; SqlDataAdapter da = new SqlDataAdapter(sqlquery, con); DataSet ds_grd = new DataSet(); da.Fill(ds_grd); DataTable dt = new DataTable(); DataColumn dc; DataRow dw; DataView dv; dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Book ID"; dt.Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Book Name"; dt.Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Book Author"; dt.Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Book Publisher Name"; dt.Columns.Add(dc); dc = new DataColumn(); dc.DataType = System.Type.GetType("System.String"); dc.ColumnName = "Book Published Date"; dt.Columns.Add(dc); if (ds_grd.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds_grd.Tables[0].Rows.Count; i++) { dw = dt.NewRow(); dw["Book ID"] = ds_grd.Tables[0].Rows[i]["Book_Id"].ToString(); dw["Book Name"] = ds_grd.Tables[0].Rows[i]["Book_name"].ToString(); dw["Book Author"] = ds_grd.Tables[0].Rows[i]["Book_author"].ToString(); dw["Book Publisher Name"] = ds_grd.Tables[0].Rows[i]["Book_Publisher_name"].ToString(); dw["Book Published Date"] = ds_grd.Tables[0].Rows[i]["Book_Published_date"].ToString(); dt.Rows.Add(dw); } dv = new DataView(dt); GridView1.DataSource = dv; GridView1.DataBind(); } } catch { throw; } } }
CSS Code :
<style type="text/css"> #GridView1 { background:#fafafa; } #GridView1 .HeaderStyle { background:#0066cc; color:#ffffff; padding:7px 10px 7px 10px; } #GridView1 th { padding:10px 15px 10px 15px; } #GridView1 td { padding:5px 10px 5px 10px; text-align:left; } </style>
0 Komentar untuk "Retrieve Data from DB and Bind Gridview through DataTable Class"