Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not 100% sure over the MVC way of doing this but I have achieved something similar.</p> <p>In my Business Layer Class </p> <pre><code>Class BL public event doneUpdate(o as object, e as eventArgs) sub method doDBUpdate() 'do your stuff RaiseEvent doneUpdate(o,e) end sub End Class Class Form dim withEvents bl as BL sub g handles bl.doneUpdate(o as object , e as eventargs) 'rebind end sub End Class </code></pre> <p>Now in your Code Behind for the form you can handle this event with a Sub that rebinds your data grid. </p> <p>Incidentally I bubble the event to a controller which the UI acts on rather than the business layer directly. </p> <p>Hope this helps</p> <p>EDIT:</p> <p>Hi Mitch </p> <p>The parameters passed from the event to the handler can be anything although Microsoft Coding Convention says that you should pass the object and the event args back. </p> <p>If you declare your event like this</p> <pre><code>Public Event myEvent(dim updated as Boolean) </code></pre> <p>and then have the handles sub have the same signature</p> <pre><code>Public Sub handler(byval updated as Boolean) handles myClass.myEvent </code></pre> <p>you should then be able the value of updated (this is only an example) </p> <p>The only thing you might want to check is that you are instantiating your Business Class as with Events </p> <pre><code>Dim WithEvents myBL as new BusinessLayer </code></pre> <p>If this still fails to work (if this in WinForms rather asp.net) you may need to say something like</p> <pre><code>AddHandler myBl.myEvent AddressOf handler </code></pre> <p>Hope this helps</p>
    singulars
    1. This table or related slice is empty.
    1. POVB.net Raising Events ...confusion! MVC
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDean
    1. USDean
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POVB.net Raising Events ...confusion! MVC
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHi Dean, many thanks, this is the sort of code I was looking for. One thing I'm not clear about though, the "o As Object, e As EventArgs" part. I removed this as I wasn't sure what o and e were supposed to represent in this situation. However, the Handles Sub is never called and I think it's to do with me removing the "o as object , e as eventargs". If this is correct, what do I pass as the object and EventArgs? Apologies if this is a dumb question but many thanks for your help so far.
      singulars
      1. PO
      1. USMitch
    2. COSee above for more information
      singulars
      1. PO
      1. USDean
    3. COI feel we're almost there but still no joy. I've ensured that I'm using "ByVal Updated As Boolean" and altered my Business Class to include WithEvents but the Handles Sub is still not responding. The RaiseEvent is definitely being called but that's where the trail goes cold. My business layer is declared as Private Shared WithEvents _ClientDAL As New ClientDAL().
      singulars
      1. PO
      1. USMitch
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload