Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can i select dataset 'data use sql statement?
Message
From
30/05/2011 05:19:51
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
How can i select dataset 'data use sql statement?
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01512237
Message ID:
01512237
Views:
93
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
Map
View

Click here to load this message in the networking platform