.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

Display Data In Gridview using Dataview class

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

Display Data In Gridview using Dataview class
 

Display records from database to a gridview using dataview class.

Default.aspx code

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" 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" BackColor="#FF9999">

    <HeaderStyle BackColor="#FFCC99" />

    </asp:GridView>

    </form>

</body>

</html>

 

Default.aspx.vb code

Imports System.Data.SqlClient

Imports System.Data

Partial Class _Default

    Inherits System.Web.UI.Page

    Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings.Item("ConnectionString").ToString()

    Dim con As New SqlConnection(strConnString)

    Dim ds As DataSet

    Dim com As SqlCommand

    Dim str As String

    Dim sqlda As SqlDataAdapter



    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        If Not IsPostBack Then

            GridView1.DataSource = getdata()

            GridView1.DataBind()

        End If



    End Sub

    Function getdata() As DataView



        Dim dv As DataView

        dv = Cache("student")



        con.Open()

        str = "select * from student"

        com = New SqlCommand(str, con)

        ds = New DataSet

        sqlda = New SqlDataAdapter(com)

        sqlda.Fill(ds, "student")

        con.Close()

        dv = ds.Tables("student").DefaultView

        Cache("student") = dv

        Return dv



    End Function



End Class

     

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