Search results for query: *

  • Users: afh
  • Content: Threads
  • Order by date
  1. A

    Retrieve parent row from child row event

    How can I use "e" parameter to get relevant parent row so that I can get values from parent row. Private Sub myAdapter_RowUpdated(ByVal sender As Object, ByVal e As OracleRowUpdatedEventArgs) ...... End If
  2. A

    Master-Detail form - PK Columns

    I'm trying to build a master-detail form using two DataGridView's based on Oracle 11g Database in VB.net (Enterprise 2015). It is a setup form to define categories (category_id, title, status) and sub categories (sub_cat_id, category_id, title, status). I've followed this example to build the...
  3. A

    Foreign Key Constraint error on a parent-child DataGridView.FillBy method

    I've two related DataGridViews for prod_category & prod_sub_category tables. I've used a text box to run FillBy method on prod_category table adapter to search records. But when I press any key in the search text box I get "Cannot clear table prod_category because ForeignKeyConstraint...
  4. A

    Question Auto-increment PK columns in master-detail form based on two Datagridviews

    I've a setup form where master as well as detail block are displayed as datagridviews. I'm getting following error message when I enter a record in master block and corresponding records in detail block and then press save button. I think this message is displayed due to negative values in...
  5. A

    Changing DatSource of a combo box column of DataGridView dynamically

    I've a DataGridView based on PROD_PACKING table. The type of PARENT_PACK_ID column is changed to Combo Box. To populate its values I defined a custom query getPackings(product_id) inside the prod_packingTableAdapter that returns PACK_ID, PACK_TYPE based on PRODUCT_ID parameter. PACK_ID...
  6. A

    Question How to get application's Connection for general query/DML purpose

    I am developing a Sales application with MS Access Database. I've added Data Source through wizard and created forms with Data Set. It is sometimes required to do some other query/dml inside the form code. Is it possible to use the same Connection as my application is using or I've to open a...
Back
Top