Community discussion forum

Banking Database

• • Reply

  8 months ago

  by CFQüeb

  César F. Qüeb Montejo

  Mérida, Mexico

  Joined 1 year ago

  Why not use a filtered query?

  Dim objSqlStr As String = "SELECT * FROM CustomerAccount WHERE CustomerId =" + YourTextBox.Text + "'"

  You are using the Find statement...of course that the error is not the use of a key?

  Attempt to Use the Load statement or ImportRow() statement to filter the record and copy only this line into a cloned datatable?. On this way.. only the record that you need wil be available.

  To share info in crossed forms, please review the following therad (in C#, but.. very similar in VB.NET):

  http://www.developerfusion.co.uk/forums/t/52181/

  On this way.. you only will be pass the customer id to the frmBalance constructor.

  Regards

  Report abuse