What is basic use of Data View

Question

hi, What is basic use of Data View?

Satyapriya Nayak · Answer

Normal 0 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

Vulpes · Answer

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.