basic use of Data View

Question

What is basic use of Data View?

Satyapriya Nayak · Answer

Hi Sharad, Filter a dataset using dataview RowFilter. App.xml file 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

Dorababu Meka · Answer

Data View represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in data table.

basic use of Data View

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)