Click here to Skip to main content
15,913,722 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Open/View file in VB.NET Pin
Dave Kreskowiak12-Oct-04 5:28
mveDave Kreskowiak12-Oct-04 5:28 
GeneralRe: Open/View file in VB.NET Pin
Mekong River12-Oct-04 15:39
Mekong River12-Oct-04 15:39 
GeneralRe: Open/View file in VB.NET Pin
Dave Kreskowiak12-Oct-04 18:05
mveDave Kreskowiak12-Oct-04 18:05 
GeneralRe: Open/View file in VB.NET Pin
Mekong River13-Oct-04 0:01
Mekong River13-Oct-04 0:01 
GeneralRe: Open/View file in VB.NET Pin
Dave Kreskowiak13-Oct-04 3:11
mveDave Kreskowiak13-Oct-04 3:11 
GeneralRe: Open/View file in VB.NET Pin
Mekong River13-Oct-04 4:03
Mekong River13-Oct-04 4:03 
GeneralSample code for sample database form Pin
Mekong River9-Oct-04 4:17
Mekong River9-Oct-04 4:17 
GeneralRe: Sample code for sample database form Pin
HarryBo9-Oct-04 9:50
HarryBo9-Oct-04 9:50 
Imports System.data.oledb

Private sub ExtractData()
'connection
Dim oConn As New OleDbConnection
'command
Dim oCmd As New OleDbCommand
'dataset
Dim oDS As New DataSet

'dataadapter with command assigned
Dim oDA As New OleDbDataAdapter(oCmd)

'set connection string, you'll have to fill that bit in though
'should be easy to find if you don't know how to form it

oConn.ConnectionString = "Provider...."

oCmd.CommandType = CommandType.Text
oCmd.Connection = oConn
oCmd.CommandText = "SELECT * FROM Table1"

oDA.Fill(oDS)

'You then have a dataset to work with.

If you know SQL then you should be able to adapt that to perform all actions

Many Thanks

Harry
GeneralRe: Sample code for sample database form Pin
Mekong River9-Oct-04 15:45
Mekong River9-Oct-04 15:45 
GeneralRe: Sample code for sample database form Pin
gthompson200510-Oct-04 16:54
gthompson200510-Oct-04 16:54 
GeneralRe: Sample code for sample database form Pin
Mekong River10-Oct-04 18:50
Mekong River10-Oct-04 18:50 
GeneralRe: Sample code for sample database form Pin
EdbertP11-Oct-04 21:00
EdbertP11-Oct-04 21:00 
GeneralRe: Sample code for sample database form Pin
Mekong River11-Oct-04 23:49
Mekong River11-Oct-04 23:49 
Generalcheck subnodes of treeview clicking parent node Pin
himubiswas9-Oct-04 3:38
himubiswas9-Oct-04 3:38 
GeneralRe: check subnodes of treeview clicking parent node Pin
Anonymous10-Oct-04 21:33
Anonymous10-Oct-04 21:33 
GeneralLimit user input in a Textbox in VB.NET Pin
Mekong River9-Oct-04 3:23
Mekong River9-Oct-04 3:23 
GeneralRe: Limit user input in a Textbox in VB.NET Pin
MohammadAmiry9-Oct-04 6:33
MohammadAmiry9-Oct-04 6:33 
GeneralRe: Limit user input in a Textbox in VB.NET Pin
Mekong River9-Oct-04 15:42
Mekong River9-Oct-04 15:42 
GeneralRe: Limit user input in a Textbox in VB.NET Pin
Dileep Devapal9-Oct-04 13:06
Dileep Devapal9-Oct-04 13:06 
GeneralRe: Limit user input in a Textbox in VB.NET Pin
Mekong River9-Oct-04 15:40
Mekong River9-Oct-04 15:40 
QuestionHow to get a class form a dll Pin
SveFro9-Oct-04 0:43
SveFro9-Oct-04 0:43 
AnswerRe: How to get a class form a dll Pin
MohammadAmiry9-Oct-04 6:17
MohammadAmiry9-Oct-04 6:17 
GeneralRe: How to get a class form a dll Pin
11-Oct-04 5:50
suss11-Oct-04 5:50 
GeneralSecuring a user input form Pin
Bob Murray9-Oct-04 0:09
Bob Murray9-Oct-04 0:09 
GeneralRe: Securing a user input form Pin
Dave Kreskowiak11-Oct-04 5:04
mveDave Kreskowiak11-Oct-04 5:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.