Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>According to @BartoszKP advice, I wrote a custom <code>ExpressionBuilder</code> that takes into acount ApplicationContext and localization (base on a Bilal Haidar <a href="http://aspalliance.com/articleViewer.aspx?aId=1113&amp;pId=-1" rel="nofollow">article</a>):</p> <p>Web.config has to declare it :</p> <pre><code>&lt;system.web&gt; &lt;expressionBuilders&gt; &lt;add expressionPrefix="Contextual" type="SinsedrixLibrary.ContextualExpressionBuilder"/&gt; &lt;/expressionBuilders&gt; &lt;/system.web&gt; </code></pre> <p>And aspx page just have to request ressource with a prefix:</p> <pre><code>&lt;h1&gt;&lt;asp:Literal runat="server" Text='&lt;%$ Contextual: LitWelcome %&gt;'&gt;&lt;/asp:Literal&gt;&lt;/h1&gt; </code></pre> <p>Here is the <code>ExpressionBuilder</code>:</p> <pre><code>namespace SinsedrixLibrary { /// &lt;summary&gt; /// This source file includes the source code for the /// XmlSettingExpressionBuilder, which is used to handle /// declarative expressions based on an XML settings file. /// &lt;/summary&gt; public class ContextualExpressionBuilder : ExpressionBuilder { public ContextualExpressionBuilder() { } /// &lt;summary&gt; /// This method will be called during page execution /// to get the expression that is going to be executed /// to return the value of the declarative expression /// &lt;/summary&gt; /// &lt;param name="entry"&gt;&lt;/param&gt; /// &lt;param name="parsedData"&gt;&lt;/param&gt; /// &lt;param name="context"&gt;&lt;/param&gt; /// &lt;returns&gt;&lt;/returns&gt; public override CodeExpression GetCodeExpression(BoundPropertyEntry entry, object parsedData, ExpressionBuilderContext context) { // Get a reference to this class since we are going to // execute a method on this class that will evaluate // the required expression CodeTypeReferenceExpression thisType = new CodeTypeReferenceExpression(base.GetType()); // Create a new expression based on the KEY specified // in the declarative expression, this will be used // as an input to the method that will evaluate the // required expression CodePrimitiveExpression expression = new CodePrimitiveExpression(entry.Expression.Trim().ToString()); string l_resxPath = Path.GetDirectoryName(context.VirtualPath) + "\\App_LocalResources\\"+ Path.GetFileName(context.VirtualPath); CodePrimitiveExpression resxPath = new CodePrimitiveExpression(l_resxPath); // The static method name that will evaluate the // expression, by accessing the XML file and retreiving // the value that corresponds to the key specified string evaluationMethod = "GetContextResource"; // Finally, return the expression that will invoke the method // responsible for evaluating the expression // The CodeMethodInvokeExpression takes as input the type on which to execute the method specified, // the method name, and the array of CodeExpression, which represents the parameters of the method called return new CodeMethodInvokeExpression(thisType, evaluationMethod, new CodeExpression[] { expression, resxPath }); } /// &lt;summary&gt; /// Evaluates the expression by accessing the XMLSettings file /// and retrieve the value corresponding to the key specified in /// the input expression. /// &lt;/summary&gt; /// &lt;param name="expression"&gt;&lt;/param&gt; /// &lt;returns&gt;&lt;/returns&gt; public static string GetContextResource(string expression, string resxPath) { // Get the XML Setting file from the application cache if present CultureInfo ci = CultureInfo.CurrentCulture; string resxKey = resxPath + "." + ci.TwoLetterISOLanguageName; XmlDocument xmlSettingDoc = (XmlDocument)HostingEnvironment.Cache[resxKey]; // check if there was an already loaded document if (xmlSettingDoc == null) { // Define the document here xmlSettingDoc = new XmlDocument(); // Get the config file path using the HostingEnvironment // which gives information for application-specific string resxCultureFile = resxKey + ".resx"; string resxDefaultFile = resxPath + ".resx"; string resxFile = ""; try { resxFile = HostingEnvironment.MapPath(resxCultureFile); } catch(Exception) { resxFile = HostingEnvironment.MapPath(resxDefaultFile); } // Load the XML file into the XmlDocument xmlSettingDoc.Load(resxFile); // Create a new file dependency to be used when we add the XmlDocument // into the Cache, so that when the XmlSettings file change, the Cache will // be invalid. CacheDependency settingsDepend = new CacheDependency(resxFile); // Add the Xmldocument to the Cache HostingEnvironment.Cache.Insert(resxKey, xmlSettingDoc, settingsDepend); } string ctx = ConfigurationManager.AppSettings["ApplicativeContext"]; // XPATH key used to retrieve the record needed in the form of add[@key='keyvalue'] string getXPATHKey = String.Format("//data[@name='{0}_{1}']/value", ctx, expression); // Search for that record XmlNode wantedRecord = xmlSettingDoc.SelectSingleNode(getXPATHKey); // If the record exists, return the value property if (wantedRecord != null) return wantedRecord.InnerText; // return a message informing users that the expression failed to // evaluate to a real value return string.Format("Unable to Process Expression : '{0}'", expression); } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POOverriding default ResourceProvider
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USsinsedrix
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POOverriding default ResourceProvider
      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. This table or related slice is empty.
 

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