How to run sql query which is in dtq file from C# code

Question

4.00/5 (1 vote)

See more:

Dear all,

in my project I'm dealing with Microsoft SQL Server database.
I know one way of retrieving data from it from my c# code:

SqlCommand myCommand = new SqlCommand("select something from someTable where someCondition", myConnection);
     SqlDataReader myReader = myCommand.ExecuteReader();

and data is now in myReader object. That's fine.

But making query is much easier, for me anyway, by creating Database Query and saving it in *.dtq file.
So my question would be, whether it's possible to call query which is in *.dtq file from C# code in a similar fashion as above, and if it is, how to do it.

Thanks in advance.

Posted 21-Jan-11 4:24am

dsnlkc

Updated 21-Jan-11 6:37am

Yusuf

v2

Add a Solution

2 solutions

Solution 2

Ok, thanks. I see error of my ways now.

After Nishant Sivakumar suggested stored procedures as solution for the problem, I did some reading on the internet, so if you have the same problem as I did (once upon the time) and you are used to C# and/or VB but know only vary basics of databases and SQL, here is what I think to be usefull for you to read:

http://databases.about.com/od/sqlserver/a/storedprocedure.htm[^]
to get the basic idea what is stored procedure and why to use it, and not query, than

http://www.sql-server-performance.com/articles/dba/stored_procedures_basics_p1.aspx[^]
to cover the topic in more detail, and finaly

http://www.csharpfriends.com/articles/getarticle.aspx?articleid=78[^]
to learn how to call your stored procedures from C# code.

Thanks again for help.

Posted 24-Jan-11 6:36am

dsnlkc

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)

Nish Nishant · Accepted Answer · 2011-01-21T04:27:00

Solution 1

A common way of doing this is via stored procedures in the SQL server database. You can then invoke the stored procedures and pass it any required arguments.

And as for your original question, no, I don't think using dtq files is a very popular approach. :~

Posted 21-Jan-11 4:27am

Nish Nishant

v2

Comments

fjdiewornncalwe 24-Jan-11 14:51pm

+5. Agreed. If the OP wants to separate his sql code from his source (A great idea), then procedures are probably the best and most used way to go.