Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here you go, I provide an example for .cs and .vb but shouldn't be hard for you to adjust it to your other file type needs: <strong><em>Edited to recursively add header to sub-folders</em></strong></p> <pre><code>Sub IterateFiles() Dim solution As Solution = DTE.Solution For Each prj As Project In solution.Projects IterateProjectFiles(prj.ProjectItems) Next End Sub Private Sub IterateProjectFiles(ByVal prjItms As ProjectItems) For Each file As ProjectItem In prjItms If file.SubProject IsNot Nothing Then AddHeaderToItem(file) IterateProjectFiles(file.ProjectItems) ElseIf file.ProjectItems IsNot Nothing AndAlso file.ProjectItems.Count &gt; 0 Then AddHeaderToItem(file) IterateProjectFiles(file.ProjectItems) Else AddHeaderToItem(file) End If Next End Sub Private Sub AddHeaderToItem(ByVal file As ProjectItem) DTE.ExecuteCommand("View.SolutionExplorer") If file.Name.EndsWith(".cs") OrElse file.Name.EndsWith(".vb") Then file.Open() file.Document.Activate() AddHeader() file.Document.Save() file.Document.Close() End If End Sub Private Sub AddHeader() Dim cmtHeader As String = "{0} First Line" Dim cmtCopyright As String = "{0} Copyright 2008" Dim cmtFooter As String = "{0} Footer Line" Dim cmt As String Select Case DTE.ActiveDocument.Language Case "CSharp" cmt = "//" Case "Basic" cmt = "'" End Select DTE.UndoContext.Open("Header Comment") Dim ts As TextSelection = CType(DTE.ActiveDocument.Selection, TextSelection) ts.StartOfDocument() ts.Text = String.Format(cmtHeader, cmt) ts.NewLine() ts.Text = String.Format(cmtCopyright, cmt) ts.NewLine() ts.Text = String.Format(cmtFooter, cmt) ts.NewLine() DTE.UndoContext.Close() End Sub </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PONeed Visual Studio macro to add banner to all C# files
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBrian Schmitt
    1. USBrian Schmitt
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PONeed Visual Studio macro to add banner to all C# files
      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. VTAcceptedByOriginator
    1. COThanks, I'm gonna vote for this one instead of the one that has the link to the blog, because this shows how to enumerate the projects.
      singulars
      1. PO
      1. USDSO
    2. COHow well does this work for files that have designers, like WinForms?
      singulars
      1. PO
      1. USScott Lawrence
    3. COShould add it to any CS or VB file in the solution. Which would include the designer file - however as with any 'generated' file, the file could change and your comment may no longer be there.
      singulars
      1. PO
      1. USBrian Schmitt
 

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