that is what I did to solve your problem:

full connectionstring: Driver={SQL Server};description=love;server=GIFTFROMABOV-PC\SQLEXPRESS_DECK;trusted_connection=Yes;app=Microsoft® Visual Studio® 2008;wsid=GIFTFROMABOV-PC;database=First_SQL

Imports

 

System

Imports

 

System.Data.Odbc

Public

 

Class Form1

 

Dim cnn As String = My.Settings.First_SQLConnectionString

 

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

 

Using conn As New OdbcConnection(cnn)

 

Dim apater As New OdbcCommand("Select * from dbo.banco", conn)

conn.Open()

 

Dim dataReader As OdbcDataReader = apater.ExecuteReader

 

Dim LinkMe As New BindingSource

LinkMe.DataSource = dataReader

 

Me.DataGridView1.DataSource = LinkMe

 

 

 

 

End Using

 

End Sub

End

 

Class

all the best for you

---

Don't judge me, just Upgrade me. Thanks!

what type of error throws? can u post here please?

I saw your code and there nothing wrong with your code...

may be you need drives for u to access your novelserv....

also try to use bindingsource

Private Sub GridOphalen()

Dim mijnDataAdapter As SqlDataAdapter
Dim mijnDataSet As New DataSet

Dim connectionString As String = My.Settings.HulpstoffenConnectionString()
Dim SQLString As String = "Select * From Hulpstof"
mijnDataAdapter = New SqlDataAdapter(SQLString, connectionString)

mijnDataSet.Tables.Add(

"From Hulpstof")

dataAdapter1.Fill(mijnDataSet.Tables(

"From Hulpstof"))

 

Me.BindingSource1.DataSource = (mijnDataSet.Tables("From Hulpstof"))

 

Me.DataGridView1.DataSource = Me.BindingSource1

End Sub

this should solve your problem...

---

Don't judge me, just Upgrade me. Thanks!

Thank you,

tomorrow evening, i post the error. and test your code.

gr. Fred

what type of error throws? can u post here please?

I saw your code and there nothing wrong with your code...

may be you need drives for u to access your novelserv....

also try to use bindingsource

Private Sub GridOphalen()

Dim mijnDataAdapter As SqlDataAdapter
Dim mijnDataSet As New DataSet

Dim connectionString As String = My.Settings.HulpstoffenConnectionString()
Dim SQLString As String = "Select * From Hulpstof"
mijnDataAdapter = New SqlDataAdapter(SQLString, connectionString)

mijnDataSet.Tables.Add(

"From Hulpstof")

dataAdapter1.Fill(mijnDataSet.Tables(

 

"From Hulpstof"))

 

 

Me.BindingSource1.DataSource = (mijnDataSet.Tables("From Hulpstof"))

 

 

Me.DataGridView1.DataSource = Me.BindingSource1

End Sub

this should solve your problem...

---

Don't judge me, just Upgrade me. Thanks!

The error is dutch language,in englische someting like thise.

Error,

optie 1 - database already exist
optie 2 - cane not make contact with database
optie 3 - it is a unc share

And  i have problem with your code,

-- name dataAdapter1 is not declared
-- BindingSource1 is not a member of Calculeren.hul Bereken.

Maby its possible i need a ODBC connection, maby somebody cane help with this.
The server load ODBC drivers
olso most in the code i think, a IPX/SPX protocol code,
this is for novell netware


Gr Fred

that is what I did to solve your problem:

full connectionstring: Driver={SQL Server};description=love;server=GIFTFROMABOV-PC\SQLEXPRESS_DECK;trusted_connection=Yes;app=Microsoft® Visual Studio® 2008;wsid=GIFTFROMABOV-PC;database=First_SQL

Imports

 

System

Imports

 

System.Data.Odbc

Public

 

Class Form1

 

Dim cnn As String = My.Settings.First_SQLConnectionString

 

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

 

Using conn As New OdbcConnection(cnn)

 

Dim apater As New OdbcCommand("Select * from dbo.banco", conn)

conn.Open()

 

Dim dataReader As OdbcDataReader = apater.ExecuteReader

 

Dim LinkMe As New BindingSource

LinkMe.DataSource = dataReader

 

Me.DataGridView1.DataSource = LinkMe

 

 

 

 

End Using

 

End Sub

End

 

Class

all the best for you

---

Don't judge me, just Upgrade me. Thanks!

thanks i try tomoro.

gr Fred

Hi,

I have one problem, with de code Where most i put this?

i use microsoft visal basic 2005 express

gr Fred

Hi,

I have one problem, with de code

full connectionstring: Driver={SQL Server};description=love;server=GIFTFROMABOV-PC\SQLEXPRESS_DECK;trusted_connection=Yes;app=Microsoft® Visual Studio® 2008;wsid=GIFTFROMABOV-PC;database=First_SQL

Where most i put this?

i use microsoft visal basic 2005 express

gr Fred

Dim Cnn as String="Driver={SQL Server};description=love;server=GIFTFROMABOV-PC\SQLEXPRESS_DECK;trusted_connection=Yes;app=Microsoft® Visual Studio® 2008;wsid=GIFTFROMABOV-PC;database=First_SQL"

---

Don't judge me, just Upgrade me. Thanks!