My code below gives me "SQL: Column 'BTN' is not found."
It will work if I use an inner join or just join but those two joins
don't return all the rows. BTN has 5 rows, but arcust01 has only has
matching records for 2 of them. I need the other 3 returned with nulls
in the fields from arcust01.
How can I do this?
Imports System.Data.Ole Db
Public Class Form1
Dim myOleDbConnecti on As OleDbConnection
Dim myOleDbCommand As OleDbCommand
Dim myOleDbDataAdap ter As OleDbDataAdapte r
Dim dt As New DataTable
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
myOleDbConnecti on = New
OleDbConnection ("Provider=vfpo ledb.1;Data Source=c:\;Coll ating
Sequence=genera l")
myOleDbCommand = New OleDbCommand
myOleDbDataAdap ter = New OleDbDataAdapte r
Dim fields As String = "select btn.btn, arcust01.lastpa y,
arcust01.balanc e "
Dim from As String = "from btn outer join f:\chris\arcust 01
arcust01 on btn.btn = arcust01.custno "
myOleDbCommand. CommandText = fields & from
'myOleDbCommand .CommandText = "select btn.btn from btn"
myOleDbCommand. Connection = myOleDbConnecti on
myOleDbDataAdap ter.SelectComma nd = myOleDbCommand
myOleDbDataAdap ter.Fill(dt)
DataGridView1.D ataSource = dt
MessageBox.Show ("done!")
End Sub
End Class