By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,934 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,934 IT Pros & Developers. It's quick & easy.

First Record is not correct

P: n/a
While performing a fill() method, the first record NEVER shows the correct
price of database item. The 2nd record and every record that has a price
will show the correct price. If I open the Access DB through Access, the
price is shown correctly in the table. I have double checked my
DataBindings but it always shows $0.00 in the UnitPriceTextBox.
Private Sub FormProducts_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Try
Me.Cursor = Cursors.AppStarting
Me.CategoriesTableAdapter.Fill(Me.Inventory_manage ment_databaseDataSet.Categories)
Me.Inventory_TransactionsTableAdapter.FillByTransa ctionDate(Me.Inventory_management_databaseDataSet. Inventory_Transactions)
Me.ProductsTableAdapter.Fill(Me.Inventory_manageme nt_databaseDataSet.Products)

Me.UnitPriceMaskedTextBox.Text =
Format(Val(Me.UnitPriceTextBox.Text), "C2") 'Update text box with
currency format
Catch ex As System.Exception
MessageBox.Show(ex.Message, "Error Loading Records")
Me.Cursor = Cursors.Default
Finally
Me.Cursor = Cursors.Default
End Try

End Sub
Tony K

Aug 14 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.