Difference in Result in query through c# and in query in sql server

Question

0.00/5 (No votes)

See more:

Hi,

Here is my piece of code,

string con = ConfigurationSettings.AppSettings["DBConnectionString"]
SqlConnection conn = new SqlConnection(con);
string query="select name from sysdatabases(nolock)";
sqlcommand comm= new sqlcommand(query,con);
sqlDatareader dr= comm.executeReader();

dr returning result as

master
tempdb
model
msdb

Note: I am using master database in my connectionstring "Initial Catalog=Master;" for above code.

but when I am running the same query in sql server query editer (Master Database)

select name from sysdatabases(nolock)

result: (this one is correct result)

master
tempdb
model
msdb
DB_test
DB_HMS

Please Point/suggest me where I am doing wrong..??

Posted 15-Aug-13 23:26pm

Adarsh chauhan

Add a Solution

Comments

Anurag Sinha V 16-Aug-13 5:45am

Interesting question Adarsh..need to see it...

Adarsh chauhan 16-Aug-13 5:47am

:) I don't know if I am missing something.. any help would be appreciated.. :)

Mehdi Gholam 16-Aug-13 5:55am

Are you using the same username and password?

Adarsh chauhan 16-Aug-13 5:59am

yes.. same username and password,as i have only one user account for my sql server..

2 solutions

Solution 1

I executed same code on my test application. It gives me same result in application as well in sql.

it provides me the same result. Only the thing i changed in your code is :
1. SqlCommand comm = new SqlCommand(query, conn); : instead of string variable i put the object of SqlConnection conn.
2. conn.Open()
3. conn.Close()

as mentioned below :

C#

string con = ConfigurationSettings.AppSettings["DBConnectionString"];
SqlConnection conn = new SqlConnection(con);
conn.Open();
string query = "select name from sysdatabases(nolock)";
SqlCommand comm = new SqlCommand(query, conn);
SqlDataReader dr = comm.ExecuteReader();
conn.Close();

Posted 16-Aug-13 1:11am

CodeBlack

Updated 16-Aug-13 1:12am

v3

Comments

CodeBlack 16-Aug-13 7:13am

still it doesnt work then there must be a permission issue i guess.

Adarsh chauhan 16-Aug-13 7:44am

Ok, will try once I reach on my machine.
well what I think it should not be affected by conn or con.

CodeBlack 16-Aug-13 7:52am

thats true. it doesnt make sense. But still, if our luck is not good then we may face problem because of some silly mistakes. :)

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)

Adarsh chauhan · Accepted Answer · 2013-08-20T00:25:00

Solution 2

Thanks for showing concern guys..

Without making any changes in code or connection string now code is running fine, don't know why it was showing wrong output earlier.. :)
Accepting this as an answer to remove it from unanswered..

Posted 20-Aug-13 0:25am

Adarsh chauhan

Updated 20-Aug-13 0:26am

v2