关于关闭连接池的数据库进程的 据库进程处于 sleeping 在程序中怎么关闭啊 程序中都什么需要关闭或断开老有很多进程处于sleeping 站用连接数怎么关闭啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 this.sqlConnection1.ConnectionString = System.Configuration .ConfigurationSettings .AppSettings ["conn"]; string selectTxt="select distinct "+this.TextField +" from "+this.SourceTableName ; System.Data .SqlClient .SqlDataAdapter myda =new System .Data .SqlClient .SqlDataAdapter(selectTxt,this.sqlConnection1 ); System.Data .DataSet ds1 =new System .Data .DataSet (); myda.Fill (ds1,this.SourceTableName ); this.DropDownList1 .DataSource = ds1.Tables [this.SourceTableName ].DefaultView ;; this.DropDownList1 .DataTextField =this.TextField ; this.DropDownList1 .DataValueField =this.ValueField ; if(!this.IsPostBack ) { this.DropDownList1 .DataBind (); } myda.Dispose(); this.DropDownList1.Dispose(); this.sqlConnection1.Close();这段代码执行之后就有一个进程处于sleeping状态 在打开这页在执行是又有一个是这状态怎么关闭 this.sqlConnection1.ConnectionString = System.Configuration .ConfigurationSettings .AppSettings ["conn"];string selectTxt="select distinct "+this.TextField +" from "+this.SourceTableName ;System.Data .SqlClient .SqlDataAdapter myda =new System .Data .SqlClient .SqlDataAdapter(selectTxt,this.sqlConnection1 );System.Data .DataSet ds1 =new System .Data .DataSet ();myda.Fill (ds1,this.SourceTableName );this.DropDownList1 .DataSource = ds1.Tables [this.SourceTableName ].DefaultView ;;this.DropDownList1 .DataTextField =this.TextField ;this.DropDownList1 .DataValueField =this.ValueField ;if(!this.IsPostBack ){ this.DropDownList1 .DataBind ();}myda.Dispose();this.DropDownList1.Dispose();this.sqlConnection1.Close(); 看你的代码好累...你能不能先引用空间using System;using System.Data;using System.Data.SqlClient;用不着每句都跟个System.Data .SqlClient .SqlDataAdapter myda =new System .Data .SqlClient .SqlDataAdapter(selectTxt,this.sqlConnection1 ); 你什么地方打开过数据库连接???this.sqlConnection1.Open(); Redirect 到另一个网站,怎么保持cookie? 给个学习asp.net的思路,大哥大姐们 asp.net2.0的验证控件依赖于哪个js文件? 怎样访问数据集中被删除的行 如何有效的操作在线用户的交互? 请教一个关于下拉菜单的问题,大家帮帮忙。 一张dvd碟的vs.net2003 改如何安装? .NET如何取得上一个HTM网页传来的数据 在文本框里的回车,无法显示到页面上 同一个界面多次使用一个自定义控件,显示的数据相同? 找工作夥伴 字符文本中的字符太多
string selectTxt="select distinct "+this.TextField +" from "+this.SourceTableName ;
System.Data .SqlClient .SqlDataAdapter myda =new System .Data .SqlClient .SqlDataAdapter(selectTxt,this.sqlConnection1 );
System.Data .DataSet ds1 =new System .Data .DataSet ();
myda.Fill (ds1,this.SourceTableName );
this.DropDownList1 .DataSource = ds1.Tables [this.SourceTableName ].DefaultView ;;
this.DropDownList1 .DataTextField =this.TextField ;
this.DropDownList1 .DataValueField =this.ValueField ;
if(!this.IsPostBack )
{
this.DropDownList1 .DataBind ();
}
myda.Dispose();
this.DropDownList1.Dispose();
this.sqlConnection1.Close();
这段代码执行之后就有一个进程处于sleeping状态 在打开这页在执行是又有一个是这状态
怎么关闭
string selectTxt="select distinct "+this.TextField +" from "+this.SourceTableName ;
System.Data .SqlClient .SqlDataAdapter myda =new System .Data .SqlClient .SqlDataAdapter(selectTxt,this.sqlConnection1 );
System.Data .DataSet ds1 =new System .Data .DataSet ();
myda.Fill (ds1,this.SourceTableName );
this.DropDownList1 .DataSource = ds1.Tables [this.SourceTableName ].DefaultView ;;
this.DropDownList1 .DataTextField =this.TextField ;
this.DropDownList1 .DataValueField =this.ValueField ;
if(!this.IsPostBack )
{
this.DropDownList1 .DataBind ();
}
myda.Dispose();
this.DropDownList1.Dispose();
this.sqlConnection1.Close();
你能不能先引用空间
using System;
using System.Data;
using System.Data.SqlClient;
用不着每句都跟个
System.Data .SqlClient .SqlDataAdapter myda =new System .Data .SqlClient .SqlDataAdapter(selectTxt,this.sqlConnection1 );
你什么地方打开过数据库连接???
this.sqlConnection1.Open();