In this blog we will know how to show data in Gridview using
dataset, datatable and data reader.
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Default.aspx.cs"
Inherits="_Default"
%>
<!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>Untitled Page</title>
</head>
<body>
<form
id="form1"
runat="server">
<div>
</div>
<asp:GridView ID="GridView1"
runat="server">
</asp:GridView>
<asp:Button ID="Button1"
runat="server"
onclick="Button1_Click"
Text="Using
Dataset" />
<asp:Button ID="Button2"
runat="server"
onclick="Button2_Click"
Text="Using
Datatable" />
<asp:Button ID="Button3"
runat="server"
onclick="Button3_Click"
Text="Using
Datareader" />
</form>
</body>
</html>
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OleDb;
public partial
class _Default
: System.Web.UI.Page
{
OleDbConnection con;
OleDbCommand com;
OleDbDataAdapter oda;
DataSet ds;
DataTable dataTable;
protected void Button1_Click(object
sender, EventArgs e)
{
con = new OleDbConnection("Provider
= Microsoft.Jet.OLEDB.4.0; Data Source = D:\\mydb.mdb");
com = new OleDbCommand("Select
* from emp", con);
con.Open();
oda = new OleDbDataAdapter(com);
ds = new DataSet();
oda.Fill(ds, "emp");
con.Close();
GridView1.DataMember = "emp";
GridView1.DataSource = ds;
GridView1.DataBind();
}
protected void Button2_Click(object
sender, EventArgs e)
{
con = new OleDbConnection("Provider
= Microsoft.Jet.OLEDB.4.0; Data Source = D:\\mydb.mdb");
dataTable = new DataTable();
com = new OleDbCommand();
com.Connection = con;
con.Open();
com.CommandText = "Select
* from emp";
oda = new OleDbDataAdapter(com);
oda.Fill(dataTable);
con.Close();
GridView1.DataSource = dataTable;
GridView1.DataMember = "emp";
GridView1.DataBind();
}
protected void Button3_Click(object
sender, EventArgs e)
{
con = new OleDbConnection("Provider
= Microsoft.Jet.OLEDB.4.0; Data Source = D:\\mydb.mdb");
com = new OleDbCommand("Select
* from emp", con);
con.Open();
OleDbDataReader reader;
reader = com.ExecuteReader();
GridView1.DataMember = "emp";
GridView1.DataSource = reader;
GridView1.DataBind();
reader.Close();
con.Close();
}
}