Click here to Skip to main content
15,885,546 members
Articles / Desktop Programming / MFC

QASharp V1.3 [Query Analyzer like tool for MSDE database]

Rate me:
Please Sign up or sign in to vote.
4.67/5 (16 votes)
11 Oct 2004CPOL1 min read 125.6K   2.6K   53  
This project is meant to provide a tool similar to query analyzer which can be used to execute queries, create tables, and do all other common database activities.
  • qasharpv13.zip
    • QASharpV1.3
      • app.config
      • AssemblyInfo.cs
      • bin
        • images
          • _Progress.gif
          • _splash_Screen.gif
          • checkbox.gif
          • close.gif
          • close_over.gif
          • drop.gif
          • Icon_SqlServer.gif
          • iconCritical.gif
          • IconInformation.gif
          • IconOpenFile.gif
          • Icons_Database.gif
          • Icons_Defaults.gif
          • Icons_Diagrams.gif
          • Icons_FullTextCatalogs.gif
          • Icons_Roles.gif
          • Icons_Rules.gif
          • Icons_StoredProcudures.gif
          • Icons_Tables.gif
          • Icons_UserDefinedDataTypes.gif
          • Icons_UserDefinedFunctions.gif
          • Icons_Users.gif
          • Icons_Views.gif
          • iconSecurity.gif
          • IconWarning.gif
          • key.gif
          • Large_Icons_Databases.gif
          • large_Icons_Defaults.gif
          • large_Icons_Login.gif
          • large_Icons_Query.gif
          • Large_Icons_ServerRoles.gif
          • Large_Icons_StoredProcedure.gif
          • Large_Icons_TableProps.gif
          • large_Icons_Users.gif
          • large_Icons_Views.gif
          • navBar_Background.gif
          • navBar_button_Back.gif
          • navBar_button_Back_over.gif
          • navBar_button_Forward.gif
          • navBar_button_Forward_over.gif
          • navbar_button_Insert.gif
          • navBar_button_Logout.gif
          • navBar_button_Logout_over.gif
          • navbar_button_NewDB.gif
          • navbar_button_NewDB_over.gif
          • navBar_button_NewLogin.gif
          • navBar_button_NewLogin_over.gif
          • navbar_button_Properties.gif
          • navbar_button_Properties_ov.gif
          • navBar_button_Query.gif
          • navBar_button_Query_over.gif
          • navBar_button_Refresh.gif
          • navBar_button_Refresh_over.gif
          • navBar_button_ToDo.gif
          • navBar_button_ToDo_over.gif
          • Process_background.gif
          • Process_runnable.gif
          • Process_sleeping.gif
          • right.ico
          • small_Icons_Defaults.gif
          • small_Icons_Diagrams.gif
          • small_Icons_Folder.gif
          • small_Icons_Full_Text_Catal.gif
          • small_Icons_Logins.gif
          • small_Icons_ProcessInfo.gif
          • small_Icons_Roles.gif
          • small_Icons_Rules.gif
          • small_Icons_ServerRoles.gif
          • small_Icons_Stored_Procedur.gif
          • small_Icons_Tables.gif
          • small_Icons_User_Defined_Fu.gif
          • small_Icons_User_Defined_Ty.gif
          • small_Icons_Users.gif
          • small_Icons_Views.gif
          • smallIcon_Database.gif
          • smallIcon_Table.gif
          • spacer.gif
          • system_icon.gif
          • TellAFriend.gif
          • windows
            • Border_Bottom.gif
            • Border_BottomLeft.gif
            • Border_BottomRight.gif
            • Border_Left.gif
            • Border_Right.gif
            • icon_ASPEntMan.gif
            • TitleBar_Background.gif
            • TitleBar_CloseButton.gif
            • TitleBar_CloseButtonOver.gif
            • TitleBar_Left.gif
            • TitleBar_Right.gif
        • Release
      • Common
      • DBControls
      • DBLayer
      • frmConnect.cs
      • frmConnect.resx
      • frmPrintPreview.cs
      • frmPrintPreview.resx
      • frmQASharp.cs
      • frmQASharp.resx
      • frmQueryWriter.cs
      • frmQueryWriter.resx
      • frmTestControl.cs
      • frmTestControl.resx
      • Images
        • App.ico
        • Icon_SqlServer.gif
        • Icons_StoredProcudures.gif
        • Icons_Tables.gif
        • Icons_Views.gif
        • large_Icons_Views.gif
        • smallIcon_Database.gif
        • smallIcon_Table.gif
      • Persist.cs
      • QASharp.csproj
      • QASharp.csproj.user
      • QASharp.csproj.vspscc
      • QASharp.sln
  • qasharp12_src.zip
    • QASharp121.jpg
    • QASharp122.jpg
    • QASharpV1.2
      • app.config
      • AssemblyInfo.cs
      • bin
        • images
          • _Progress.gif
          • _splash_Screen.gif
          • checkbox.gif
          • close.gif
          • close_over.gif
          • drop.gif
          • Icon_SqlServer.gif
          • iconCritical.gif
          • IconInformation.gif
          • IconOpenFile.gif
          • Icons_Database.gif
          • Icons_Defaults.gif
          • Icons_Diagrams.gif
          • Icons_FullTextCatalogs.gif
          • Icons_Roles.gif
          • Icons_Rules.gif
          • Icons_StoredProcudures.gif
          • Icons_Tables.gif
          • Icons_UserDefinedDataTypes.gif
          • Icons_UserDefinedFunctions.gif
          • Icons_Users.gif
          • Icons_Views.gif
          • iconSecurity.gif
          • IconWarning.gif
          • key.gif
          • Large_Icons_Databases.gif
          • large_Icons_Defaults.gif
          • large_Icons_Login.gif
          • large_Icons_Query.gif
          • Large_Icons_ServerRoles.gif
          • Large_Icons_StoredProcedure.gif
          • Large_Icons_TableProps.gif
          • large_Icons_Users.gif
          • large_Icons_Views.gif
          • navBar_Background.gif
          • navBar_button_Back.gif
          • navBar_button_Back_over.gif
          • navBar_button_Forward.gif
          • navBar_button_Forward_over.gif
          • navbar_button_Insert.gif
          • navBar_button_Logout.gif
          • navBar_button_Logout_over.gif
          • navbar_button_NewDB.gif
          • navbar_button_NewDB_over.gif
          • navBar_button_NewLogin.gif
          • navBar_button_NewLogin_over.gif
          • navbar_button_Properties.gif
          • navbar_button_Properties_ov.gif
          • navBar_button_Query.gif
          • navBar_button_Query_over.gif
          • navBar_button_Refresh.gif
          • navBar_button_Refresh_over.gif
          • navBar_button_ToDo.gif
          • navBar_button_ToDo_over.gif
          • Process_background.gif
          • Process_runnable.gif
          • Process_sleeping.gif
          • right.ico
          • small_Icons_Defaults.gif
          • small_Icons_Diagrams.gif
          • small_Icons_Folder.gif
          • small_Icons_Full_Text_Catal.gif
          • small_Icons_Logins.gif
          • small_Icons_ProcessInfo.gif
          • small_Icons_Roles.gif
          • small_Icons_Rules.gif
          • small_Icons_ServerRoles.gif
          • small_Icons_Stored_Procedur.gif
          • small_Icons_Tables.gif
          • small_Icons_User_Defined_Fu.gif
          • small_Icons_User_Defined_Ty.gif
          • small_Icons_Users.gif
          • small_Icons_Views.gif
          • smallIcon_Database.gif
          • smallIcon_Table.gif
          • spacer.gif
          • system_icon.gif
          • TellAFriend.gif
          • windows
            • Border_Bottom.gif
            • Border_BottomLeft.gif
            • Border_BottomRight.gif
            • Border_Left.gif
            • Border_Right.gif
            • icon_ASPEntMan.gif
            • TitleBar_Background.gif
            • TitleBar_CloseButton.gif
            • TitleBar_CloseButtonOver.gif
            • TitleBar_Left.gif
            • TitleBar_Right.gif
        • Release
      • Common
      • DBControls
      • DBLayer
      • frmConnect.cs
      • frmConnect.resx
      • frmQASharp.cs
      • frmQASharp.resx
      • frmQueryWriter.cs
      • frmQueryWriter.resx
      • frmTestControl.cs
      • frmTestControl.resx
      • Images
        • App.ico
        • Icon_SqlServer.gif
        • Icons_StoredProcudures.gif
        • Icons_Tables.gif
        • Icons_Views.gif
        • large_Icons_Views.gif
        • smallIcon_Database.gif
        • smallIcon_Table.gif
      • obj
        • Release
          • temp
          • TempPE
      • QASharp.csproj
      • QASharp.csproj.user
      • QASharp.csproj.vspscc
      • QASharp.sln
<?xml version="1.0" encoding="utf-8"?>
<root>
  <!-- 
            Microsoft ResX Schema 
        
            Version 1.3
                
            The primary goals of this format is to allow a simple XML format 
            that is mostly human readable. The generation and parsing of the 
            various data types are done through the TypeConverter classes 
            associated with the data types.
        
            Example:
        
                ... ado.net/XML headers & schema ...
                <resheader name="resmimetype">text/microsoft-resx</resheader>
                <resheader name="version">1.3</resheader>
                <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
                <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
                <data name="Name1">this is my long string</data>
                <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
                <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
                    [base64 mime encoded serialized .NET Framework object]
                </data>
                <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
                    [base64 mime encoded string representing a byte array form of the .NET Framework object]
                </data>
        
            There are any number of "resheader" rows that contain simple 
            name/value pairs.
            
            Each data row contains a name, and value. The row also contains a 
            type or mimetype. Type corresponds to a .NET class that support 
            text/value conversion through the TypeConverter architecture. 
            Classes that don't support this are serialized and stored with the 
            mimetype set.
                     
            The mimetype is used for serialized objects, and tells the 
            ResXResourceReader how to depersist the object. This is currently not 
            extensible. For a given mimetype the value must be set accordingly:
        
            Note - application/x-microsoft.net.object.binary.base64 is the format 
                   that the ResXResourceWriter will generate, however the reader can 
                   read any of the formats listed below.
        
            mimetype: application/x-microsoft.net.object.binary.base64
            value   : The object must be serialized with 
                    : System.Serialization.Formatters.Binary.BinaryFormatter
                    : and then encoded with base64 encoding.
        
            mimetype: application/x-microsoft.net.object.soap.base64
            value   : The object must be serialized with 
                    : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
                    : and then encoded with base64 encoding.
            mimetype: application/x-microsoft.net.object.bytearray.base64
            value   : The object must be serialized into a byte array 
                    : using a System.ComponentModel.TypeConverter
                    : and then encoded with base64 encoding.
        -->
  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xsd:element name="root" msdata:IsDataSet="true">
      <xsd:complexType>
        <xsd:choice maxOccurs="unbounded">
          <xsd:element name="data">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" msdata:Ordinal="1" />
              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="resheader">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" />
            </xsd:complexType>
          </xsd:element>
        </xsd:choice>
      </xsd:complexType>
    </xsd:element>
  </xsd:schema>
  <resheader name="resmimetype">
    <value>text/microsoft-resx</value>
  </resheader>
  <resheader name="version">
    <value>1.3</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <data name="ctxAction.Location" type="System.Drawing.Point, System.Drawing, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>17, 17</value>
  </data>
  <data name="imlTree.Location" type="System.Drawing.Point, System.Drawing, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>114, 17</value>
  </data>
  <data name="imlTree.ImageStream" mimetype="application/x-microsoft.net.object.binary.base64">
    <value>
        AAEAAAD/////AQAAAAAAAAAMAgAAAFpTeXN0ZW0uV2luZG93cy5Gb3JtcywgVmVyc2lvbj0xLjAuMzMw
        MC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODkFAQAAACZT
        eXN0ZW0uV2luZG93cy5Gb3Jtcy5JbWFnZUxpc3RTdHJlYW1lcgEAAAAERGF0YQcCAgAAAAkDAAAADwMA
        AADiCwAAAk1TRnQBSQFMAgEBBQEAAQkBAAEEAQABEAEAARABAAT/AQkBAAj/AUIBTQE2AQQGAAE2AQQC
        AAEoAwABQAMAATADAAEBAQABCAYAAQwYAAGAAgABgAMAAoABAAGAAwABgAEAAYABAAKAAgADwAEAAcAB
        3AHAAQAB8AHKAaYBAAEzBQABMwEAATMBAAEzAQACMwIAAxYBAAMcAQADIgEAAykBAANVAQADTQEAA0IB
        AAM5AQABgAF8Af8BAAJQAf8BAAGTAQAB1gEAAf8B7AHMAQABxgHWAe8BAAHWAucBAAGQAakBrQIAAf8B
        MwMAAWYDAAGZAwABzAIAATMDAAIzAgABMwFmAgABMwGZAgABMwHMAgABMwH/AgABZgMAAWYBMwIAAmYC
        AAFmAZkCAAFmAcwCAAFmAf8CAAGZAwABmQEzAgABmQFmAgACmQIAAZkBzAIAAZkB/wIAAcwDAAHMATMC
        AAHMAWYCAAHMAZkCAALMAgABzAH/AgAB/wFmAgAB/wGZAgAB/wHMAQABMwH/AgAB/wEAATMBAAEzAQAB
        ZgEAATMBAAGZAQABMwEAAcwBAAEzAQAB/wEAAf8BMwIAAzMBAAIzAWYBAAIzAZkBAAIzAcwBAAIzAf8B
        AAEzAWYCAAEzAWYBMwEAATMCZgEAATMBZgGZAQABMwFmAcwBAAEzAWYB/wEAATMBmQIAATMBmQEzAQAB
        MwGZAWYBAAEzApkBAAEzAZkBzAEAATMBmQH/AQABMwHMAgABMwHMATMBAAEzAcwBZgEAATMBzAGZAQAB
        MwLMAQABMwHMAf8BAAEzAf8BMwEAATMB/wFmAQABMwH/AZkBAAEzAf8BzAEAATMC/wEAAWYDAAFmAQAB
        MwEAAWYBAAFmAQABZgEAAZkBAAFmAQABzAEAAWYBAAH/AQABZgEzAgABZgIzAQABZgEzAWYBAAFmATMB
        mQEAAWYBMwHMAQABZgEzAf8BAAJmAgACZgEzAQADZgEAAmYBmQEAAmYBzAEAAWYBmQIAAWYBmQEzAQAB
        ZgGZAWYBAAFmApkBAAFmAZkBzAEAAWYBmQH/AQABZgHMAgABZgHMATMBAAFmAcwBmQEAAWYCzAEAAWYB
        zAH/AQABZgH/AgABZgH/ATMBAAFmAf8BmQEAAWYB/wHMAQABzAEAAf8BAAH/AQABzAEAApkCAAGZATMB
        mQEAAZkBAAGZAQABmQEAAcwBAAGZAwABmQIzAQABmQEAAWYBAAGZATMBzAEAAZkBAAH/AQABmQFmAgAB
        mQFmATMBAAGZATMBZgEAAZkBZgGZAQABmQFmAcwBAAGZATMB/wEAApkBMwEAApkBZgEAA5kBAAKZAcwB
        AAKZAf8BAAGZAcwCAAGZAcwBMwEAAWYBzAFmAQABmQHMAZkBAAGZAswBAAGZAcwB/wEAAZkB/wIAAZkB
        /wEzAQABmQHMAWYBAAGZAf8BmQEAAZkB/wHMAQABmQL/AQABzAMAAZkBAAEzAQABzAEAAWYBAAHMAQAB
        mQEAAcwBAAHMAQABmQEzAgABzAIzAQABzAEzAWYBAAHMATMBmQEAAcwBMwHMAQABzAEzAf8BAAHMAWYC
        AAHMAWYBMwEAAZkCZgEAAcwBZgGZAQABzAFmAcwBAAGZAWYB/wEAAcwBmQIAAcwBmQEzAQABzAGZAWYB
        AAHMApkBAAHMAZkBzAEAAcwBmQH/AQACzAIAAswBMwEAAswBZgEAAswBmQEAA8wBAALMAf8BAAHMAf8C
        AAHMAf8BMwEAAZkB/wFmAQABzAH/AZkBAAHMAf8BzAEAAcwC/wEAAcwBAAEzAQAB/wEAAWYBAAH/AQAB
        mQEAAcwBMwIAAf8CMwEAAf8BMwFmAQAB/wEzAZkBAAH/ATMBzAEAAf8BMwH/AQAB/wFmAgAB/wFmATMB
        AAHMAmYBAAH/AWYBmQEAAf8BZgHMAQABzAFmAf8BAAH/AZkCAAH/AZkBMwEAAf8BmQFmAQAB/wKZAQAB
        /wGZAcwBAAH/AZkB/wEAAf8BzAIAAf8BzAEzAQAB/wHMAWYBAAH/AcwBmQEAAf8CzAEAAf8BzAH/AQAC
        /wEzAQABzAH/AWYBAAL/AZkBAAL/AcwBAAJmAf8BAAFmAf8BZgEAAWYC/wEAAf8CZgEAAf8BZgH/AQAC
        /wFmAQABIQEAAaUBAANfAQADdwEAA4YBAAOWAQADywEAA7IBAAPXAQAD3QEAA+MBAAPqAQAD8QEAA/gB
        AAHwAfsB/wEAAaQCoAEAA4ADAAH/AgAB/wMAAv8BAAH/AwAB/wEAAf8BAAL/AgAD//8A/wD/AP8ABQAQ
        /zAABf8EkgFtAQcB+AG8A/8wAAT/AewEDgEQAQcBkgH0A/8wABD/MAAF/wPsAf8C7AX/MAAF/wHxAQ8B
        EAHxAhAF/zAAEP8wABD/MAAF/wVtBv8wAAX/AbwK/zAABf8BvAGSCf8wAAX/AbwB/wHyAf8BBwb/MAAG
        /wHvAf8B+wf/MAAG/wHvArwBRAG8Bf8wAAb/Ae8E7QX/MAAQ/0AABv8E8xb/FQABoQVtAV8EAAT/AvEC
        EAEOASIC8QX/DQABBwH/FQABpwQHAZMB7AEKAwAD/wHyAg4B/wEbAVEBNwEiAQ4BvAT/DOwBQwEHAf8C
        AAGGAl8DAAHPAl8BzwkAARAFBwHsBAAD/wHsAQMBMAH/AVEBGgEwATcBAwEABP8B7AHwCf8BBwFDAQcB
        /wEAAa4B6wJtAe0BAAGnAewCbQHtBwABrgH8AacFBwHsAQAB7wESAaED/wHsAQMBNwH/AZkBcwE3ATAB
        AwEABP8B7AHwCf8BBwFDAQcB/wEAAQoB9wHfAf4CAAGnAQ4BuwG6BwABiwL8AacF8gHsAQAB7wHsAYUD
        /wHsAQMBNwH/AXkBmQI3AQMBAAT/AewB8AG8A+wB8wPsAe8BBwFDAQcB/wEAAQoBugLfAgABpwEAAbsB
        ugESBQABpwECAccB/AGnBe8BFQEAAe8B7AGFA/8B7AEDATcB/wGZAXkCNwEDAQAE/wHsAfAJ/wEHAUMB
        BwH/AQABCgH+Ad8BuwIAAacB6gH+AQcBDwUAAe0BkQL8AZAFBwHsAQAB7wHsAYUD/wHsAQMBNwH/ApkC
        NwEDAQAE/wHsAfABvAPsAfMD7AHvAQcBQwEHAf8BAAEKAbkBugH+AUMCzwEAAf4BugFDBQAB7AGRAbUC
        TwXtAesBAAHrAe0BhQP/AewBAwE3Af8BeQGZAjcBAwEABP8B7AHwCf8BBwFDAQcB/wEAAa4BDgQAARAB
        BwIAAewDAAG1AQAB6wH0AdYBmAFPBQcB7AEAAe8BbQGFA/8B7AEDATcB/wGZAXkCNwEDAQAE/wHsAfAB
        vAPsAfMD7AHvAQcBQwEHAf8CAAEUCAABEgUAAZIBuwFyAfwB7QXzAewBAAHsAZIBhQP/AewBAwEwAf8B
        cwGZATABmQEDAQAE/wHsAfAJ/wEHAUMBBwH/AwABDgGhAQABzwEQBAABDgGhAwABpwHyAv8BSAGnBQcB
        AAHvARQBhQP/AewBAwEaAV4BGgFeARoBXgEaAQAE/wHsAe8K7AFDAQcB/wUAAaEBzwEQBgABpwMAAbUB
        pwEIAwIB7ATwAQcB7AGFA/8B7AEbAV4BwwFeAcMBXgHDAV4BAAT/AewB9wOhAYUB/AEEAfEBFAGSARQB
        QwEHAf8GAAHPARALAAG1Af8BuwGhAgIB7wQHAe0BhQP/AfMB7QHDAV4BwwFeAcMBXgFzAfEE/wHsCgcB
        9wFDAQcB/wUAAaEBDwGnBgABpwUAAacB9wGQAYYBigHrBacBAAT/AfQG7AH0Bf8N7AHxAf8gACD/EAAB
        QgFNAT4HAAE+AwABKAMAAUADAAEwAwABAQEAAQEFAAGAAQEWAAP//wACAAL/BAAC/wH4AQ8EAAL/AfgB
        BwQAAccBDwH4AQMEAAGCAQ8B4AUAAYIBDwHABQABggEPAYAFAAGCAQ8BgAUAAYABDwGABQABhAEOAYAF
        AAHfAe4BgAUAAeQB8gGABQAB8AH4AcAFAAH4Af0B4AUAAfgB/QHwAQEEAAT/BAAC/ws=
</value>
  </data>
  <data name="$this.Name">
    <value>DataBaseTree</value>
  </data>
</root>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Founder Algorisys Technologies Pvt. Ltd.
India India
Co Founder at Algorisys Technologies Pvt. Ltd.

http://algorisys.com/
https://teachyourselfcoding.com/ (free early access)
https://www.youtube.com/user/tekacademylabs/

Comments and Discussions