Include MSSQL query editor in your C# application

Question

1.00/5 (4 votes)

See more:

Okay I saw an application that has this amazing feature. It lets you run SQL codes directly on the application without having to launch SQL management studio. Of course you would have to know the the table definitions and all to use this...

I'm working on an application and I want to implement this idea. This is because I want to save frequently needed SQL scripts somewhere on the server e.g 10 Youngest Employees, Highest Paid Employees etc... You select a script and it runs...

I will like a solution that runs just like what Microsoft Management Studio provides that the save as option when you right click the results...

I know the disadvantages of this so I'll write a query that would ensure only a SELECT statement would run...

Thanks guys...

What I have tried:

I might have tried nothing yet

Posted 24-Jan-17 23:58pm

Akinloluwa

Updated 25-Jan-17 23:11pm

v2

Add a Solution

Comments

Richard MacCutchan 25-Jan-17 6:14am

So what is your question?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

F-ES Sitecore · Accepted Answer · 2017-01-25T00:20:00

Solution 1

Simply provide a textbox then execute the contents of that textbox against the database. You can use ado.net to do this

Executing a Command[^]

change the CommandType to "Text" and set the CommandText property to be YourSQLBox.Text.

Posted 25-Jan-17 0:20am

F-ES Sitecore

Comments

Akinloluwa 26-Jan-17 3:58am

Okay great... I'll do this, then fill the data in a gridview and add an export to excel button. I'll probably also run a check for insert, delete, update and join statements so that data is not manipulated... That quite sums it. Really... thanks...