Create a new DataTable from the DataView | C#

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

Utilizing a DataView, developers can create various views of the data stored in a DataTable, a capability frequently employed in data-binding applications. Additionally, a DataView provides the functionality to create a new DataTable from the view. By using the ToTable method, all rows and columns, or a subset of the data, can be copied into a fresh DataTable, facilitating efficient data management and manipulation.

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 empowers developers to customize and explore different views of the data stored within a DataTable. Changes made to a DataView seamlessly propagate to the underlying DataTable, ensuring data consistency. Conversely, modifications to the underlying DataTable automatically update all associated DataView objects. By leveraging DataView, developers can create new DataTables based on the view, using the ToTable method to selectively copy data. These features contribute to efficient data handling in a variety of applications, particularly in the context of data-binding scenarios.






Related Topics
  1. How to create a DataView | C#
  2. How to Sort a DataView | C#
  3. How to Filter a DataView | C#
  4. How to Search in a DataView | C#
  1. How to add new row in a DataView | C#
  2. How to update row in a DataView | C#
  3. How to delete row in a DataView | C#