DataView Component of Ado.Net

Question

What is dataview component of ado.net.

Satyapriya Nayak · Answer

Hi Sharad, A DataView object allows you work with data of DataTable of DataSet object. It is associated with a DataTable and sits on the top of DataTable. It is used to filter and sort data. Data sorting is accomplished by setting the Sort property and data filter by setting the RowFilter property. Ex:- using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace DataView_RowFilter { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void btndisplayall_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select * from student"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "student"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "student"; con.Close(); } private void btndisplay_Click(object sender, EventArgs e) { DataTable dt; dt = ds.Tables["student"]; DataView dv = new DataView(dt); dv.RowFilter = "sname='" + textBox1.Text + "'"; dataGridView1.DataSource = dv; } } } Thanks If this post helps you mark it as answer

DataView Component of Ado.Net

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)