Click here to Skip to main content
Click here to Skip to main content

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

, 11 Oct 2004 CPOL
Rate this:
Please Sign up or sign in to vote.
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.

Sample screenshot

Sample screenshot

Introduction

The QASharp was developed for those using the MSDE (Microsoft Desktop Engine). 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.

All suggestions, apprehensions, criticisms are welcome.

Credits

SqlDBHandler.cs by http://www.aspenterprisemanager.com/.

Functionality Supported

  • Create new query.
  • Save existing query.
  • Open existing query.
  • Execute queries.
  • Multiple query output window.
  • Connect to different data source.
  • Flicker free Syntax highlighting of major keywords.
  • Added Show Errors in Help menu.
  • Object browser.
  • Data/Stored procedure editing functionality.
  • Printing queries.

Configuration settings to be made

In order for the application to work, make the following changes in the app.config file, in the keys listed below:

<?xml version="1.0" encoding="Windows-1252"?>
<configuration>
  <appSettings>
    <add key="server" value="(local)" /> 
    <add key ="database" value="master" />
    <add key="uid" value="sa"/>
    <add key="pwd" value=""/> 
  </appSettings>
</configuration>
Keys Values
Server The server to connect to
Database The initial database to connect to
Uid User ID
Pwd Password

Usage

  • Select a database.
  • Create a new document by clicking on New.
  • Type in the query (for multiple queries, add a “GO” keyword after each query).
  • Press “F5” to execute query, or click on the Execute icon on the toolbar.
  • To select a different server:
    • Click on File-> Connect. Enter the required parameters, and click on Connect.

The main code changes from V1.2 to V1.3


/// Syntax highlighting
private void rtbQueryPad_TextChanged(object sender, System.EventArgs e)
{
   /// Split the line into tokens.
   Regex r = new Regex("([ \\t{}();])");

   if (rtbQueryPad.Text.Trim() =="")
    return;

   /// Get current line

   int currentLine = rtbQueryPad.GetLineFromCharIndex(
    rtbQueryPad.GetCharIndexFromPosition(Cursor.Position));
   
   /// When large amount of text is copied, generates error
   
   try {
    string currentLineString = rtbQueryPad.Lines[currentLine];

    int startPos = 0;
    for (int i = 0; i < currentLine-1; i++)
    {
     startPos = startPos + rtbQueryPad.Lines[i].Length;
    }

    string [] tokens = r.Split(currentLineString);
    
    foreach (string token in tokens) 
      {
     if (token.Trim() != string.Empty) 
     {
      if (IsKeyWord(token))
       FindAndHighlight(token,Color.Blue,false,true,startPos);
      else
       FindAndHighlight(token,Color.Black,false,true,startPos);
     }
    }
   }
   catch (Exception ex)
   {
    Console.WriteLine(ex.Message);
   }
} 

private bool IsKeyWord(string input)
{
  for (int i = 0; i < keywords.Length; i++) 
  {
        if (input.Trim().ToLower() == keywords[i].ToLower())
    {
     return true;
    }
  }
  return false;
}

/// More functionality to be added later.
/// Code to print the query
protected void pdQuery_PrintPage (object sender, 
 System.Drawing.Printing.PrintPageEventArgs ev)
  {
   float linesPerPage = 0;
   float yPosition = 0;
   int count = 0;
   float leftMargin = ev.MarginBounds.Left;
   float topMargin = ev.MarginBounds.Top;
   string line = null;
   
   frmQueryWriter frmCurrentForm;
   frmCurrentForm = (frmQueryWriter)this.ActiveMdiChild;

   Font printFont = frmCurrentForm.rtbQueryPad.Font;
   SolidBrush myBrush = new SolidBrush(Color.Black);

   // Work out the number of lines per page, using the MarginBounds.
   linesPerPage = ev.MarginBounds.Height / printFont.GetHeight(ev.Graphics);

   // Iterate over the string using the StringReader, printing each line.
   while(count < linesPerPage && ((line=myReader.ReadLine()) != null)) 
   {
    // calculate the next line position based on 
    // the height of the font according to the printing device
    yPosition = topMargin + (count * printFont.GetHeight(ev.Graphics));

    // draw the next line in the rich edit control
    
    ev.Graphics.DrawString(line, printFont, myBrush, 
     leftMargin, yPosition, new StringFormat());
    count++;
   }

   // If there are more lines, print another page.
   if(line != null)
    ev.HasMorePages = true;
   else
    ev.HasMorePages = false;

   myBrush.Dispose();
      
  }

The main code changes from V1.1 to V1.2

// Update the table with changed values.

public void UpdateDT(DataTable dt)
{
   string sql;dt.TableName;                 
   try
   {
       if (m_conn.State == ConnectionState.Closed)
       {
           m_conn.Open ();
       }
       SqlDataAdapter da = new SqlDataAdapter(
        sql,m_conn.ConnectionString);
       string field="";
       string values="";
       string sql1 = "";
       foreach(DataRow dtr in  dt.Rows)
       { 
          if (dtr.RowState == DataRowState.Added)  
          {      
             sql1 = " insert into " + dt.TableName + " (";          
             field = "";                
             values = "";       
             foreach(DataColumn dc in dt.Columns)   
             {          
                if (dc.AutoIncrement == false)          
                {   
                    field += dc.ColumnName + ",";   
                    values +=  "'" +  dtr[dc.ColumnName] + "',";          
                }   
             }  
             field = field.Substring(0,field.Length-1);  
             values = values.Substring(0,values.Length-1); 
             sql1 += field  + ")" + "Values (" + values + ")" ;
          }
          else if (dtr.RowState == DataRowState.Modified)
          {
             sql1 = " update  " + dt.TableName + " set ";
             string stmt="";
             string where = " where ";

             foreach(DataColumn dc in dt.Columns)
             {
                field  = dc.ColumnName + " = ";
                values =  "'" +  
                 dtr[dc.ColumnName].ToString().Trim() + "' ";
                stmt += field +  values + ",";
                where += field + "'" +  
                dtr[dc.ColumnName,
                 DataRowVersion.Original].ToString().Trim() 
                     +   "' and " ;
             }

             stmt = stmt.Substring(0,stmt.Length-1);
             where = where.Substring(0,where.Length-5);
             sql1 += stmt + where;
          }

          else if (dtr.RowState == DataRowState.Deleted)
          {
             sql1 = " delete from " + dt.TableName ;
             string stmt="";
             string where = " where ";
             foreach(DataColumn dc in dt.Columns)
             {
                 field  = dc.ColumnName + " = ";
                 where += field + "'" +  
                 dtr[dc.ColumnName,DataRowVersion.Original].ToString().
                    Trim() + "' and " ;
             }
             where = where.Substring(0,where.Length-5);
             sql1 += stmt + where;
          }
          if (sql1.Trim() != string.Empty)
                ExecNonQuery(sql1);
      }

   }

   catch (Exception ex)
   {
       System.Diagnostics.Debug.WriteLine(ex.Message);
   }
}

Revision History

  • 06-Oct-2004
    • Added windows integrated security while logging in.
    • Improved flicker-free Syntax highlighting.
    • Added support for printing.
    • Bug fixes.
  • 05-Aug-2004
    • Object Browser.
    • Data / Stored Procedure Editor.
    • Database Tree Control.
  • 1.1 22nd-Feb-2004
    • Multiple query output window.
    • Syntax highlighting.
    • Connect to different data source menu option.
  • License

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

    Share

    About the Author

    Rajesh Pillai
    Architect
    India India
    Co Founder at TekAcademy Labs.
     
    http://tekacademy.com/
    Follow on   Twitter

    Comments and Discussions

     
    QuestionI need some help PinmemberMember 204359621-Sep-08 22:52 
    General.QASharp Development stopped !!! PinmemberRajesh Pillai3-Jan-06 4:44 
    Questionhandle udf's ? PinsussAnonymous28-Jun-05 13:18 
    QuestionStill no update? PinmemberandrewPP14-Mar-05 17:15 
    AnswerRe: Still no update? PinmemberRajesh Pillai15-Mar-05 0:32 
    GeneralCheck &quot;SQLBuddy&quot; project PinmemberBlackTigerAP24-Oct-04 22:02 
    QuestionDo you know something about 'Spliter'? PinmemberBlackTigerAP23-Oct-04 13:14 
    AnswerRe: Do you know something about 'Spliter'? PinmemberRajesh Pillai23-Oct-04 22:41 
    GeneralRe: Do you know something about 'Spliter'? PinmemberBlackTigerAP24-Oct-04 21:59 
    GeneralRe: Do you know something about 'Spliter'? PinmemberRajesh Pillai24-Oct-04 22:06 
    GeneralSlowest DB app! Sorry but it's true... PinmemberBlackTigerAP23-Oct-04 13:13 
    GeneralRe: Slowest DB app! Sorry but it's true... PinmemberRajesh Pillai23-Oct-04 22:38 
    GeneralNext release!!! PinmemberRajesh Pillai12-Oct-04 0:05 
    GeneralRe: Next release!!! PinmemberTom McAnnally12-Oct-04 17:34 
    GeneralRe: Next release!!! PinmemberRajesh Pillai12-Oct-04 19:21 
    GeneralSyntax Highlighting Pinmemberlabreuer12-Aug-04 4:03 
    GeneralRe: Syntax Highlighting PinmemberRajesh Pillai12-Aug-04 5:22 
    GeneralRe: Syntax Highlighting PinmemberFinn Rasmussen14-Sep-04 0:50 
    GeneralRe: Syntax Highlighting PinmemberRajesh Pillai14-Sep-04 0:56 
    GeneralSuggestions PinmemberDaaron11-Aug-04 14:06 
    GeneralRe: Suggestions PinmemberRajesh Pillai11-Aug-04 20:06 
    GeneralRe: Suggestions PinmemberDaaron12-Aug-04 5:23 
    GeneralRe: Suggestions PinmemberRajesh Pillai12-Aug-04 5:27 
    GeneralHint... PinmemberThomas Latuske5-Aug-04 10:42 
    GeneralRe: Hint... PinmemberRajesh Pillai5-Aug-04 20:37 
    GeneralRe: Hint... Pinmemberacehart20058-Jul-10 7:15 
    Generallooks good... PinmemberEllery_Familia5-Aug-04 8:04 
    GeneralRe: looks good... PinmemberRajesh Pillai5-Aug-04 8:09 
    GeneralRe: looks good... PinmemberEllery_Familia5-Aug-04 8:15 
    GeneralRe: looks good... PinmemberRajesh Pillai5-Aug-04 8:20 

    General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

    Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

    | Advertise | Privacy | Terms of Use | Mobile
    Web03 | 2.8.141223.1 | Last Updated 12 Oct 2004
    Article Copyright 2004 by Rajesh Pillai
    Everything else Copyright © CodeProject, 1999-2014
    Layout: fixed | fluid