Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Not sure I understand the question. But there's two toolboxes suitable for writing generic code. It's generics, and it's reflection - typically in combination. </p> <p>I don't think I really understand what you're trying to do, but a method using relfection to identify all the properties of an object might look like this:</p> <pre><code>using System.Reflection; (...) public void VisitProperties(object subject) { Type subjectType = subject.GetType(); foreach (PropertyInfo info in subjectType.GetProperties() { object value = info.GetValue(subject, null); Console.WriteLine("The name of the property is " + info.Name); Console.WriteLine("The value is " + value.ToString()); } } </code></pre> <p>You can also check out an entry on my blog where I discuss using attributes on objects in conjunction with reflection. It's actually discussing how this can be utilized to write generic UI. Not exactly what you want, but at least the same principles could be used. </p> <p><a href="http://codepatrol.wordpress.com/2011/08/19/129/" rel="nofollow">http://codepatrol.wordpress.com/2011/08/19/129/</a></p> <p>This means that you could create your own custom attributes, or use those that already exists within the .NET framework already, to describe your types. Attributes to specify rules for validation, field label, even field placement could be used. </p> <pre><code>public class Person { [FieldLabel("First name")] [ValidationRules(Rules.NotEmpty | Rules.OnlyCharacters)] [FormColumn(1)] [FormRow(1)] public string FirstName{get;set;} [FieldLabel("Last name")] [ValidationRules(Rules.NotEmpty | Rules.OnlyCharacters)] [FormColumn(2)] [FormRow(1)] public string LastName{get;set;} } </code></pre> <p>Then you'd use the method described in my blog to identify these attributes and take the apropriate action - e.g. placing them in the proper row, giving the correct label, and so forth. I won't propose how to solve these things, but at least reflection is a great and simple tool to get descriptive information about an unknown type.</p>
    singulars
    1. This table or related slice is empty.
    1. PODynamic form with no real OOP or objects?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UShavardhu
    1. UShavardhu
    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. VTDownMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHmm - yeah, not sure I explained the issue correctly - The object that you have drawn up towards the end is actually configured in the DB. I really cannot bring it out of the DB at this time... and in the DB, there is no definition of a 'person' - its just a list of fields... so my question is more in relation to how can change this so that there IS a definition, and what changes in the architecture needs to be done. Also, with it the issues of deploying to many clients, and individual customizations..
      singulars
      1. PO
      1. USM.R.
 

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