执行Sqlserver中waitfor delay延时 *** 作或waitfor time定时 *** 作

概述private static string connectionString = RBAC.Dal.DataRootBase.ConnectionString;private SqlConnection mConnection = new SqlConnection(connectionString);#region/// <summary>/// 当点击执行查询时发生(异步 *** 作) /

private static string connectionString = RBAC.Dal.DaTarootBase.ConnectionString;private sqlConnection mConnection = new sqlConnection(connectionString);#region/// <summary>/// 当点击执行查询时发生(异步 *** 作) /// 执行数据库waitfor delay延时存储过程/// 或者waitfor time定时存储过程/// </summary>private voID button_DoSearch_Click(object sender,EventArgs e){	sqlCommand command = new sqlCommand("pro_StoreDelay",mConnection);	command.CommandType = CommandType.StoredProcedure;	mConnection.open();	AsyncCallback callBack = new AsyncCallback(HandleCallback);//注册回调方法	//开始执行异步查询，将Command作为参数传递到回调函数以便执行End *** 作	command.BeginExecuteReader(callBack,command); //异步查询 回调	//command.BeginExecuteNonquery(null,command); //直接执行 无回调}#endregion#region/// <summary>/// 异步查询的回调方法/// </summary>/// <param name="MyResult">异步 *** 作状态</param>private voID HandleCallback(IAsyncResult MyResult){	try	{		//sqlCommand command = (sqlCommand)MyResult.AsyncState;		//sqlDataReader reader = command.EndExecuteReader(MyResult);		//Datatable datatable = new Datatable();		//datatable.Load(reader);		//reader.dispose();		//command.dispose();	}	catch (Exception ex)	{	}	finally	{		if (mConnection != null)		{			mConnection.Close();  //回调后关闭连接		}	}}#endregion

总结

以上是内存溢出为你收集整理的执行Sqlserver中waitfor delay延时 *** 作或waitfor time定时 *** 作全部内容，希望文章能够帮你解决执行Sqlserver中waitfor delay延时 *** 作或waitfor time定时 *** 作所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。