Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Agree with @sliderhouserules, the way you are using MVC framework is awful. You must forgot all your "old school" techniques. You should never use SqlCommands, SqlReaders, etc. in the code of the pages. You should pass to the view only a model (e.g. View(bar)) and it will be better if you avoid usage of</p> <pre><code>ViewData["some magic string"] = bar </code></pre> <p>Every time when you will use "old school" technique 2 mans and 2 cats will be killed :).<br> Also it's better to use some ORM (Object-Relational Mapper) like Linq2sql, NHibernate, SubSonic, etc.<br> If you need in samples of good application design please look at <a href="http://code.google.com/p/sharp-architecture/" rel="nofollow noreferrer">SharpArchitecture</a>. It has a very good architecture and implementation and may help a lot. It has one sample (with Northwind db) and one more sample will be added soon.<br> Also look at <a href="http://code.google.com/p/codecampserver/" rel="nofollow noreferrer">CodeCampServer</a>. It has very good architecture too.<br> It's better to look at the code of these projects instead of looking videos because existing videos can't demonstrate good sample of architecture, just a simple usage of functionality.<br> About server controls, you may use them if they can be used without 'runat="server"', like PlaceHolder. And you may create them too, but you shouldn't load any data in them directly. If you don't want to copy-paste html you should review your code and you should refactor it. Every duplicated code should be moved to MasterPages of UserControls (ascx ones).<br> And once more, please spend some time to look at these samples. You'll save your nerves and time in the future when you'll need to update the app or fix something. At the first look they can be hard to understand but this is only at the first look. Hope this helps.</p>
    singulars
    1. This table or related slice is empty.
    1. POASP.NET web forms as ASP.NET MVC
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USzihotki
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI thought that I will make a confusion mentioning MVC. All I wrote was about web forms. I just mentioned MVC as a better tool for me then web forms since you have to construct your tables by your self. Sorry for the confusion and thanks for the reply.
      singulars
      1. PO
      1. USlopkiju
    2. CONo problem :) And mvc is not better tool, it's just another tool. It has a lot of advantages but has disadvantages too. It's better to use webforms when you need to create site fast and it will be data-driven (a lot of grids, etc). But I prefer MVC, it's very powerful and comfortable for me :)
      singulars
      1. PO
      1. USzihotki
    3. COI like the idea of MVC. Anyway, the point of my long post was the proper use of controls in ASP.NET web forms. I don't know how to display a data when the func that communicate with the db is in separate file (without DataBinding) so what I did was string append and call the function where needed.
      singulars
      1. PO
      1. USlopkiju
 

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