What is basic use of Data View

Vulpes has explained it beautifully

Here is a sample program of dataview.

Imports System.Data
Imports System.Data.OleDb
Public Class Form1
    Dim ConnectionString As String = System.Configuration.ConfigurationSettings.AppSettings("dsn")
    Dim con As OleDbConnection = New OleDbConnection(ConnectionString)
    Dim com As OleDbCommand
    Dim oledbda As OleDbDataAdapter
    Dim ds As DataSet
    Dim dt As DataTable
    Dim str As String
    Private Sub btnfilterdata_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnfilterdata.Click
        Try
            con.Open()
            str = "select * from student"
            com = New OleDbCommand(str, con)
            oledbda = New OleDbDataAdapter(com)
            ds = New DataSet
            oledbda.Fill(ds, "student")
            Dim dv As DataView = New DataView(ds.Tables("student"))
            dv.RowFilter = "smarks>70"
            dv.Sort = "smarks asc"
            ListBox1.DataSource = dv
            ListBox1.DisplayMember = "smarks"
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        con.Close()
    End Sub
End Class

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak15y ago
Accepted answer

Vulpes has explained it beautifully
Here is a sample program of dataview.

Imports System.Data
Imports System.Data.OleDb
Public Class Form1
    Dim ConnectionString As String = System.Configuration.ConfigurationSettings.AppSettings("dsn")
    Dim con As OleDbConnection = New OleDbConnection(ConnectionString)
    Dim com As OleDbCommand
    Dim oledbda As OleDbDataAdapter
    Dim ds As DataSet
    Dim dt As DataTable
    Dim str As String
    Private Sub btnfilterdata_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnfilterdata.Click
        Try
            con.Open()
            str = "select * from student"
            com = New OleDbCommand(str, con)
            oledbda = New OleDbDataAdapter(com)
            ds = New DataSet
            oledbda.Fill(ds, "student")
            Dim dv As DataView = New DataView(ds.Tables("student"))
            dv.RowFilter = "smarks>70"
            dv.Sort = "smarks asc"
            ListBox1.DataSource = dv
            ListBox1.DisplayMember = "smarks"
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        con.Close()
    End Sub
End Class
0
Vulpes15y ago
A DataView is typically used to sort or filter a DataTable without affecting the DataTable itself.

The DataView can then bound to controls which display the results.

The DataView is dynamic in that it automatically reflects any changes made to the DataTable.

It's also possible to edit a DataView by adding, updating or deleting rows which, once committed, do affect the DataTable.
0