Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Dynamically loading controls in .Net is a little confusing. I see four problems with what you're doing. </p> <ol> <li><p>You're trying to dynamically add the controls only on the initial HTTP GET (not on postbacks). You need to add the controls every time. You're not binding data here, you're adding controls to the Page control tree. Those controls need to be added every time the page runs.</p></li> <li><p>You're rendering controls to string. Don't do that, just add them to the page control tree and they'll render on their own during the page Render. </p></li> <li><p>Use Page.LoadControl() when creating controls. This will create the control and force it's events (page event lifecycle) to catch up with the rest of the page. </p></li> <li><p>You're adding controls a little late in the page event lifecycle. Try adding your controls in Page_Init.</p></li> </ol> <p>Here's a sample that pulls it all together. It dynamically creates a button and then adds it to a placeholder control.</p> <pre><code>protected void Page_Init(object sender, System.EventArgs e) { var button = LoadControl(typeof(Button), null) as Button; button.Click += clickHandler; myPlaceholder.Controls.Add(button); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PORender .net controls to string and get events to fire
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRudy Lacovara
    1. USRudy Lacovara
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORender .net controls to string and get events to fire
      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. COThank you for your detailed explanation, it all makes sense. I'm just not sure how 2. would do the trick for my requirements. As I have mentioned in my question, the layout of the page to be displayed comes from the database and I need the control to be placed exactly where the curly bracket in the content is. So I'm loading the control as I build a string to display as output, if I don't do the render as string how would the control get placed exactly where I want it?
      singulars
      1. PO
      1. USHiral Desai
    2. COYou can do what .net does. Put your HTML in a Literal control and add it to the control tree. When you come across a button or a text field, create controls for those and add them to the control tree. If you have more HTML after those controls then put that HTML in another Literal control and add that to the control tree. It's not a fun way to build a page but if you're doing something a little crazy like building a page based on a string you're pulling from a database then you're going to experience a bit of pain making that work.
      singulars
      1. PO
      1. USRudy Lacovara
    3. COHmm, that sounds challenging. The problem I'm having is reverse-engineering an existing classic ASP application in .Net. So the idea of HTML coming from database (done in classic ASP) cannot be changed because I need to make sure that the new application works exactly the same as the old one without having to make any changes. Also, the template is in a format like this "<table><row>{header_stuff}<row><row>{more_dynamic_stuff}<row><row>static html and other things<row><Some More Rows}</table>. So the curly bracket {more_dynamic_stuff} will have a bunch of controls.
      singulars
      1. PO
      1. USHiral Desai
 

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