通过c＃和sql server中的查询查询结果的差异 [英] Difference in Result in query through c# and in query in sql server

问题描述

这是我的一段代码，

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

注意：我使用的是master数据库在我的连接字符串Initial Catalog = Master;对于上面的代码。







但是当我在sql server查询编辑器中运行相同的查询时（主数据库）

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..??

推荐答案

我在测试应用程序上执行了相同的代码。它在应用程序中也给我相同的结果在sql。



它为我提供了相同的结果。只有我在代码中更改的内容是：

1。 SqlCommand comm = new SqlCommand（query， conn ）; ：而不是字符串变量我把SqlConnection conn的对象。

2。 conn.Open（）

3。 conn.Close（）



如下所述：

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 :

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();

感谢您关注他们..



不做任何改动代码或连接字符串现在代码运行正常，不知道为什么它之前显示错误的输出.. :)

接受这个作为一个答案将其从未答复中删除..

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..

这篇关于通过c＃和sql server中的查询查询结果的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！