.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Code Snippets >> ASP.NET Controls >> Post New Resource Bookmark and Share   

 Subscribe to Code Snippets

Show data in Gridview using dataset, datatable and data reader.

Posted By:satyapriyanayak       Posted Date: May 25, 2013    Points: 40    Category: ASP.NET Controls    URL: http://www.dotnetspark.com  

Here we will know how to show data in Gridview using dataset, datatable and data reader.
 

Here 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();
    }
}


     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More code samples in C#, ASP.Net, Vb.Net and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend