通过c#和sql server中的查询查询结果的差异 [英] Difference in Result in query through c# and in query in sql server
本文介绍了通过c#和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屋!
查看全文