Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It sounds like you are not creating distinct layers in your application. If your main form has 1,000 lines of code, you are probably putting business logic or even data access code in the form itself. You really need to separate out your layers (at least presentation layer, business logic layer, and data access layer). This will help you better follow good OO principles. In relation to VB.NET specifically, here are a few articles that might help:</p> <p><a href="http://www.asp.net/data-access/tutorials/creating-a-business-logic-layer-vb" rel="noreferrer">http://www.asp.net/data-access/tutorials/creating-a-business-logic-layer-vb</a></p> <p><a href="http://www.vbdotnetheaven.com/UploadFile/akrao/PracticesofCodingInVB11162005001109AM/PracticesofCodingInVB.aspx" rel="noreferrer">http://www.vbdotnetheaven.com/UploadFile/akrao/PracticesofCodingInVB11162005001109AM/PracticesofCodingInVB.aspx</a></p> <p><a href="http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx" rel="noreferrer">http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx</a></p> <p>These will help you with layers and how to implement them in VB.NET. The ASP.NET article will work fine because the actual ASP.NET is the Presentation Layer, which you would replace with Winforms.</p> <p>If you want to watch videos on OO design principles, here is a good site to do so (it isn't free but it is very cheap):</p> <p><a href="http://www.learnvisualstudio.net/content/series/Visual_Basic_201_Object_Oriented_Programming_and_Design_Patterns.aspx" rel="noreferrer">http://www.learnvisualstudio.net/content/series/Visual_Basic_201_Object_Oriented_Programming_and_Design_Patterns.aspx</a></p> <p>A great book for helping you understand OO design is <a href="http://headfirstlabs.com/books/hfooad/" rel="noreferrer">Head First Object-Oriented Analysis &amp; Design</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POVB.NET best practices and designing classes
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIAmTimCorey
    1. USIAmTimCorey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POVB.NET best practices and designing classes
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYeah, as the code in my main form got longer I knew I was doing something wrong. Thanks, I'll take a look at the links
      singulars
      1. PO
      1. USJohan
    2. CO+1 for the Head First and tier references... :-)
      singulars
      1. PO
      1. USklabranche
    3. CO@Johan - yeah, good call. Basically, you want to think about the future. If you decide to move to WPF, will you break your entire application? If you decide to change from a SQL backend (for example) to an XML backend, would it break your entire application? You want these types of changes to have as limited an impact on your application as possible. That way, when the boss decides that new tech is the way to go, you aren't re-inventing the wheel by redoing the 1,000+ lines of code.
      singulars
      1. PO
      1. USIAmTimCorey
 

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