-- Create the test table with a CLOB column CREATE a table with name - "SampleXmlCLOB" along with following columns ID INTEGER PRIMARY KEY, Subject VARCHAR(256), XML_CLOB_STRING CLOB Table created.
SELECT XmlType(SampleXmlCLOB .XML_CLOB_STRING).EXTRACT('//DATAMATRIX/FSDATAMATRIX[1]/FIELD1/text()').GETSTRINGVAL() FROM
SampleXmlCLOB WHERE SampleXmlCLOB .ID = 100
Benedict Alphonse Monday, December 7, 2009 0 comments
Microsoft implemented conditional comments in their browser, which allow you to link a stylesheet that will be interpreted by a browser alone.
You can also target only a certain version of IE:
.class {
width:200px; /* All browsers */
*width:250px; /* IE */
_width:300px; /* IE6 */
.width:200px; /* IE7 */
}
Since this technique is not W3C compliant,conditional comments is best option.
For more details please refer Microsoft official documentation -
CSS Benedict Alphonse 0 comments
Web browsers define different default styling for html elements, the first thing to do is to always include a CSS reset in your stylesheet. By using this code, you're already eliminating lots of future headaches.
html,body,div,ul,ol,li,dl,dt,dd,h1,h2,h3,h4,h5,h6,pre,form,p,blockquote,fieldset,input,hr {margin:0; padding:0;}
h1,h2,h3,h4,h5,h6,pre,code,address,caption,cite,code,em,strong,th {font-size:1em; font-weight:normal; font-style:normal;}
ul,ol {list-style:none;}
fieldset,img,hr {border:none;}
caption,th {text-align:left;}
table {border-collapse:collapse; border-spacing:0;}
td {vertical-align:top;}
CSS Benedict Alphonse 0 comments
Adding the Macro:
1. Click “Tools” menu
2. Click “Macros” menu item
3. Click “Macros IDE…” menu choice
4. Right click on “My Macros”
5. Click “Add” menu item
6. Choose “Add Module…” (a module is a VB term for a static C# class with all static members)
7. Enter the name of “FileHeader” (or whatever you want to name your module)
8. Paste the code below and update any variables to match your organization or name
Imports System
Imports EnvDTE
Imports EnvDTE80
Imports EnvDTE90
Imports System.Diagnostics
Public Module FileHeader
Sub FileHeader()
Dim doc As Document
Dim docName As String
Dim companyName As String = "My Company"
Dim authorName As String = "Benedict Alphonse"
Dim copyrightText As String = "© 2009 My Company. All rights reserved"
Dim Email As String = "benedictkmu@gmail.com"
Dim Summary As String
' Get the name of this object from the file name
doc = DTE.ActiveDocument
' Get the name of the current document
docName = doc.Name
' Set selection to top of document
DTE.ActiveDocument.Selection.StartOfDocument()
DTE.ActiveDocument.Selection.NewLine()
' Write first line
DTE.ActiveDocument.Selection.LineUp()
DTE.ActiveDocument.Selection.Text = "#region File Header"
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// ******************************************************************************************************************"
DTE.ActiveDocument.Selection.NewLine()
' Write copyright tag
DTE.ActiveDocument.Selection.Text = "// "
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// " + copyrightText
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// "
' Write author name tag (optional)
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// " + authorName + " "
DTE.ActiveDocument.Selection.NewLine()
' Write email tag (optional)
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// " + Email + " "
DTE.ActiveDocument.Selection.NewLine()
' Write email tag (optional)
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// " + docName + " "
DTE.ActiveDocument.Selection.NewLine()
' Write email tag (optional)
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "//------------------------------Revision History---------------------------------------------------------------------"
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// Date Author Change Log Comments"
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "//" + DateTime.Now.ToString("MMM/dd/yyyy") + " " + authorName + " " + "Newly Created" + " "
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// "
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "// "
DTE.ActiveDocument.Selection.NewLine()
' Write last line
DTE.ActiveDocument.Selection.Text = "// ******************************************************************************************************************"
DTE.ActiveDocument.Selection.NewLine()
DTE.ActiveDocument.Selection.Text = "#endregion"
End Sub
End Module
Macro Results
This creates the following text inserted into the top of the source code document:
#region File Header // ****************************************************************************************************************** //Adding Macro to Toolbar: To add this to a toolbar in your IDE:// © 2009 My Company. All rights reserved // //Benedict Alphonse //benedictkmu@gmail.com //ReportUtils.cs //------------------------------Revision History--------------------------------------------------------------------- // Date Author Change Log Comments //Dec/01/2009 Benedict Alphonse Newly Created // // // ****************************************************************************************************************** #endregion
Development Benedict Alphonse Tuesday, December 1, 2009 0 comments
All about Microsoft Technologies.
Posts
