获取SqlConnection的统计信息

最新推荐文章于 2023-10-09 22:21:14 发布

weixin_34128534

最新推荐文章于 2023-10-09 22:21:14 发布

阅读量167

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/Yellowshorts/archive/2013/02/17/2914588.html

版权

var MyConnectionString = @"Data Source=.;Initial Catalog=BalloonShop;Integrated Security=True";
using (SqlConnection Myconnection = new SqlConnection(MyConnectionString))
{
Myconnection.StatisticsEnabled = true;//启用信息收集
var MySql = "select * from Category";
var MyAdapter = new SqlDataAdapter(MySql, Myconnection);
var MyDateSet = new DataSet();
Myconnection.Open();
MyAdapter.Fill(MyDateSet, "adsfasdfa");
System.Collections.IDictionary MyStatistics = Myconnection.RetrieveStatistics();//获取信息
long byteReceived = (long)MyStatistics["BytesReceived"];
long selectRows = (long)MyStatistics["SelectRows"];
var MyInfo = "当前连接部分统计如下:";
MyInfo += "已经接受到的字节数" + byteReceived.ToString();
MyInfo += "查询已经或得的行数" + selectRows.ToString();
Response.Write(MyInfo);
}