iT'S VERY SIMPLE PROBLEM I CAN'T FIND WHAT IS WRONG WITH MY CODE..
CAN SOMEONE HELP HERE...
I TRIED IT MANY TIMES....
Code: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()




Reply With Quote