i have written a code:
Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & My.Application.Info.DirectoryPath & "\DATABASE\medicaldb.mdb" & ";")
dim strquery as string
strquery = "SELECT * FROM bilpass NATURAL INNER JOIN advance"
Dim cmd As New OleDbCommand(strquery, cn)
Dim da As New OleDbDataAdapter(cmd)
Dim ds As New DataSet
DataGrid1.DataSource = ds.Tables(0)
'bilpass' and 'advance' are access database tables. i have to perform natural inner join on the 2 tables. but
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
error crops up.
i have to display the result of query on datagrid.
what is the problem and how can it be solved?
thanks.Monday, April 30, 2007 7:23 AM