General information
Category:
Coding, syntax and commands
Title:
How can i select dataset 'data use sql statement?
Hi all ,
i use vb.net and already fill dataset.table in form load. If i want to use sql statement to filter dataset's data using sql statement ,
select distinct[sysname] from funclib left outer join syslib on funclib.sysid = syslib.sysid , i know select database data in dataset , but
i don't know select dataset data and using sql statement to do something , how can i do, thank you ?
Private Sub FuncLib_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.SyslibTableAdapter.Fill(Me.WilsonDataSet.syslib)
Me.FunclibTableAdapter.Fill(Me.WilsonDataSet.funclib)
End Sub
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only