Create a new DataTable from the DataView | C#

By: Rajesh P.S.

The DataView functionality offers diverse perspectives on the data stored in a DataTable, allowing for customizable views tailored to specific requirements. Modifying a DataView automatically updates the underlying DataTable, and any changes made to the DataTable automatically affect all DataView objects viewing it. It's important to note that when creating a DataView using a constructor without arguments, the DataView cannot be utilized until the Table property is set.

DataTable from the DataView

With the help of a DataView, the required points of view of the data in the DataTable can be generated easily. This feature is used in most data binding operations. Also, you can work with DataView to build an extra DataTable from it. With the help of the ToTable method, you can easily transfer all the rows and columns or a subset of the data from a data table into a fresh data table allowing built-in flexibility to manage the data more efficiently.

Full Source C#

using System; using System.Data; using System.Data.SqlClient; using System.Windows.Forms; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string connetionString = null; SqlConnection connection ; SqlCommand command ; SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); DataView dv ; string sql = null; connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"; sql = "Select * from product"; connection = new SqlConnection(connetionString); try { connection.Open(); command = new SqlCommand(sql, connection); adapter.SelectCommand = command; adapter.Fill(ds, "Copy to DataTable"); adapter.Dispose(); command.Dispose(); connection.Close(); dv = new DataView(ds.Tables[0], "Product_Price <= 2000", "Product_ID", DataViewRowState.CurrentRows); DataTable dTable ; dTable = dv.ToTable(); dataGridView1.DataSource = dTable; } catch (Exception ex) { MessageBox.Show (ex.ToString()); } } } }

Conclusion

DataView allows the developers the customization of many different data visualization techniques such as different views of the data contained within the DataTable. Such modifications made to a DataView propagate naturally to the DataTable that is the source underneath without the need to requiring to refresh the DataView. In contrast, the DataView classes can be modified by changing the source DataTable, all the referencing DataView objects will be also changed. Developers can achieve this goal by using DataView, which enables them to create all the brand-new DataTables rellying on the view, and they can achieve this using the ToTable method. The features of Elastic Secondary Indexes along with point-in-time recovery and query performance facilitate data management in a wide range of use cases, in particular for data binding situations.

Next > C# DataTable copy

Related Topics

More Related Topics.....