Create a new dataset from a dataview

[Li Pang]

Hi,

I created a dataview for filtering data from a datatable, I want to create a
new dataset from this dataview. Anybody can give a simple solution?

Thanks in advance

[Ken Tucker [MVP]]

Hi,

The dataview has a totable method. This method is new to vb 2005.

Imports System.Data.SqlClient

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim strConn As String = _
"Server = .\SQLEXPRESS;Database = NorthWind; Integrated Security
= SSPI;"
Dim conn As New SqlConnection(strConn)
Dim da As New SqlDataAdapter("Select * from Products", conn)
Dim dt As New DataTable

da.Fill(dt)
Dim dv As New DataView(dt)
dv.RowFilter = "UnitPrice>20"

Dim dt2 As DataTable = dv.ToTable
DataGridView1.DataSource = dt2
End Sub
Ken
--------------
"Li Pang" <Li****@discussions.microsoft.com> wrote in message
news:96**********************************@microsof t.com...

Hi,

I created a dataview for filtering data from a datatable, I want to create
a
new dataset from this dataview. Anybody can give a simple solution?

Thanks in advance