Solved

Visual Studio Express SQL Textbox Formatting

Posted on 2014-01-21
2
908 Views
Last Modified: 2014-01-30
Hi,

I am creating an application in Visual Studio Express (VB). One of the fields is a non editable text box which will contain some SQL.

How can I format the textbox so that the SQL dedicated words / comments etc are properly formatted?

Thanks

Mike
0
Comment
Question by:ubya308
  • 2
2 Comments
 
LVL 32

Expert Comment

by:Robberbaron (robr)
ID: 39799267
how do you define 'properly formatted' ?

do you mean you want the SQL reserved words capitalised, if not in quotes ?
0
 
LVL 32

Accepted Solution

by:
Robberbaron (robr) earned 500 total points
ID: 39799285
some lists for reference...
http://technet.microsoft.com/en-us/library/ms189822.aspx
https://drupal.org/node/141051

then parse the text looking for these words, but need to check for quotes

or do you want different functions to be on separate lines as well...


but a better option would be to send it to on of the online formatters like http://sqlformat.org/api/   the VB.NET calls would be similar to the ruby example.

http://architectshack.com/PoorMansTSqlFormatter.ashx has a library you  could use.

(note i have not tried any of the api or libraries)
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question