[RESOLVED] [2005]help With Simple Problem..

[edgarbenilde]

iT'S VERY SIMPLE PROBLEM I CAN'T FIND WHAT IS WRONG WITH MY CODE..

CAN SOMEONE HELP HERE...

I TRIED IT MANY TIMES....

 connArrival1 = New OleDbConnection
                    connArrival1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Rsodb.mdb;User Id=admin;Password=;"
                    ' Create the OleDbDataAdapter.
                    daArrival1 = New OleDbDataAdapter("Select ReservationNum, RSONO, ITEMCODE, ITEMDESCRIPTION, SOURCE, MOQ, QuantityRequired, Remarks, HagInvoiceNO from FinalItemRSO order by RSONO DESC where ConfirmArrivalBy is null", connArrival1)
                    ' Map Table to Contacts.
                    daArrival1.TableMappings.Add("Table", "FinalItemRSO")
                    ' Fill the DataSet.
                    dsArrival1 = New DataSet()
                    daArrival1.Fill(dsArrival1)

                    ' Make a DataView for the data.
                    DataViewpurchaseDisplay = New DataView(dsArrival1.Tables("FinalItemRSO"))

                    ' Bind the DataGrid control to the DataView.
                    DataGridView2.DataSource = DataViewpurchaseDisplay
                    connArrival1.Close()

[cameron2]

Can you actually state what the error is that way people will not be deterred by having to try out your code but help you based on the error information you give.

[cameron2]

Looks like you need to declare everything e.g.
Dim connArrival1 = New (OleDbConnection-wateva this is but it needs declaration too!)

[edgarbenilde]

The was syntax error in ORDER BY clause...

[edgarbenilde]

connArrival1 was declare as private....

[edgarbenilde]

Anyway, thank you very much PEEPS for the help... i got my problem solve...

[cameron2]

It's great that your problem is solved

[edgarbenilde]

yes, because i found the error with my own risk..h why cameron2?
i forgot something missing in the database field name..

[stanav]

Anyway, thank you very much PEEPS for the help... i got my problem solve...

Would you be kind to mark the thread as resolved?

[edgarbenilde]

thanks peeps... for your assistance, sorry i missed something here... and my error also is only my database field is my error...