Click here to Skip to main content
15,885,366 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Create Folder Pin
Dave Kreskowiak5-Apr-08 13:45
mveDave Kreskowiak5-Apr-08 13:45 
QuestionMicrosoft.DirectX.Direct3DX Pin
Joy Anne4-Apr-08 21:54
Joy Anne4-Apr-08 21:54 
GeneralRe: Microsoft.DirectX.Direct3DX Pin
Dave Kreskowiak5-Apr-08 13:43
mveDave Kreskowiak5-Apr-08 13:43 
GeneralUnable to show data in datagridview Pin
hisuman1004-Apr-08 20:21
hisuman1004-Apr-08 20:21 
GeneralRe: Unable to show data in datagridview Pin
Rupesh Kumar Swami4-Apr-08 20:53
Rupesh Kumar Swami4-Apr-08 20:53 
GeneralRe: Unable to show data in datagridview Pin
hisuman1004-Apr-08 21:30
hisuman1004-Apr-08 21:30 
GeneralRe: Unable to show data in datagridview Pin
Rupesh Kumar Swami4-Apr-08 22:17
Rupesh Kumar Swami4-Apr-08 22:17 
AnswerRe: Unable to show data in datagridview Pin
MBCDC4-Apr-08 23:00
MBCDC4-Apr-08 23:00 
Good Morning fellows,

I always use the following procedure to receive Data from
the Jet-Engine or even from the MS-SQL-Server

Imports System.Data.OleDb
...
Dim oOleDbConnection As OleDbConnection
Dim DBAdapt As OleDbDataAdapter
Dim DT As New DataTable
DIM SQLT as String
Dim DBPath as String
'***Don't forget to specify the correct databasepath
DBPath="C:\mypath\nwind.mdb"
Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DBPath & ";" & _
"User ID=Admin;" & _
"Password="
oOleDbConnection = New OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
'***check if the Connection had opened correct. If not
'***you receive a first tip where the probleme might be

If oOleDbConnection.State = ConnectionState.Open Then
'***Set the SQL-Statement
SQLT="Select * from Customer;"
'***Create a new Adapter-Object
Dim DBAdapt As New OleDbDataAdapter(SQLT, oOleDbConnection)
'***Because of the fact that we only select Data from one Table
'***it is enough to use a DataTable Object instead of a DataSet
'***And now lets fill it!

OleDbDataAdapter.Fill(DT)
'***we don't need the connection to be open longer, so lets close it.
oOleDbConnection.Close()
'***it will be better to give a Name to the DataTable....
DT.TableName="Customer"
'***lets bind the DataTable to a DataGridView
DGV.DataSource=DT
'***Thats all! This should work!
Else
Call MsGBox("Connection not open!")
End If
GeneralPop Up Form Pin
Socheat.Net4-Apr-08 18:52
Socheat.Net4-Apr-08 18:52 
GeneralRe: Pop Up Form Pin
Rupesh Kumar Swami4-Apr-08 20:49
Rupesh Kumar Swami4-Apr-08 20:49 
AnswerRe: Pop Up Form Pin
Rajesh Anuhya4-Apr-08 23:36
professionalRajesh Anuhya4-Apr-08 23:36 
GeneralRe: Pop Up Form Pin
Dave Kreskowiak5-Apr-08 13:37
mveDave Kreskowiak5-Apr-08 13:37 
GeneralRe: Pop Up Form Pin
Mycroft Holmes5-Apr-08 17:53
professionalMycroft Holmes5-Apr-08 17:53 
QuestionHow to design dataTables or DataSets for forms on different panels Pin
AAGTHosting4-Apr-08 16:23
AAGTHosting4-Apr-08 16:23 
AnswerRe: How to design dataTables or DataSets for forms on different panels Pin
Ashish Sehajpal4-Apr-08 23:48
Ashish Sehajpal4-Apr-08 23:48 
GeneralRe: How to design dataTables or DataSets for forms on different panels Pin
Mycroft Holmes5-Apr-08 17:50
professionalMycroft Holmes5-Apr-08 17:50 
QuestionHow Can i start? Pin
hassandot4-Apr-08 9:17
hassandot4-Apr-08 9:17 
AnswerRe: How Can i start? Pin
Dave Kreskowiak4-Apr-08 9:39
mveDave Kreskowiak4-Apr-08 9:39 
GeneralRe: How Can i start? Pin
hassanasp4-Apr-08 10:45
hassanasp4-Apr-08 10:45 
GeneralRe: How Can i start? Pin
Luc Pattyn4-Apr-08 12:07
sitebuilderLuc Pattyn4-Apr-08 12:07 
GeneralSaving Data Pin
tibmark4-Apr-08 7:23
tibmark4-Apr-08 7:23 
GeneralRe: Saving Data Pin
Dave Kreskowiak4-Apr-08 8:12
mveDave Kreskowiak4-Apr-08 8:12 
GeneralRe: Saving Data Pin
tibmark4-Apr-08 8:19
tibmark4-Apr-08 8:19 
GeneralRe: Saving Data Pin
Dave Kreskowiak4-Apr-08 9:36
mveDave Kreskowiak4-Apr-08 9:36 
GeneralRe: Saving Data Pin
jzonthemtn4-Apr-08 8:33
jzonthemtn4-Apr-08 8:33 

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.