如何在sql server中获取执行查询的结果 [英] how can i get the result of executed query in sql server

问题描述

如果我传递查询，比如使用数据库1



那么结果显示为''命令已成功完成。''



同样的查询我想从前端执行。工作正常，bt如何捕获结果。

请参阅。帮助。

if i pass the query like use database1

then result is displayed like ''Command(s) completed successfully.''

same query i want to execute from front end.its working fine,bt how to catch that result.
pls. help.

推荐答案

您应该了解ADO.Net。然后，您可以使用类似的功能。这里有一些好文章：



初学者理解ADO.NET的教程 [ ^ ]

http://csharp-station.com/Tutorial/AdoDotNet [ ^ ]

http://www.sitepoint.com/introduction-ado -net / [ ^ ]

You should get an overview of ADO.Net. Then you can work on similar functionality. Here are few good articles:

A Beginner''s Tutorial for Understanding ADO.NET[^]
http://csharp-station.com/Tutorial/AdoDotNet[^]
http://www.sitepoint.com/introduction-ado-net/[^]

您好，



您可以使用SqlDataAdapter在前端执行查询。

Hi,

you can use SqlDataAdapter to execute your query in front end.

string con="<sql db="" connection="" string="">";
string query="select * from table1";
SqlDataAdapter da=new SqlDataAdapter(query,con); 
Dataset ds=new Dataset();
da.fill(ds);


//bind the dataset value into an gridview control.

gridview1.datasource=ds;
gridview1.databind();</sql>

我认为这会对你有帮助。

I think this will help you.

这篇关于如何在sql server中获取执行查询的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！