关于Net异步页面问题 查询的资料上都是用异步页面调用SqlCommand的BeginExecuteReader、BeginExecuteNonQuery方法,Oracle数据库没有办法通过NET异步调用吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 protected void Page_Load(object sender, EventArgs e) { AddOnPreRenderCompleteAsync( new BeginEventHandler(BeginAsyncOperation), new EndEventHandler(EndAsyncOperation)); }IAsyncResult BeginAsyncOperation(object sender, EventArgs e, AsyncCallback cb, object state) { string sql = "SELECT TOP 10 * FROM dbo.Card_Ext"; SqlConnection _conn = new SqlConnection(ConfigurationManager. AppSettings["DataAccessContionStringRead"].ToString()); _conn.Open(); SqlCommand cmd = new SqlCommand(sql, _conn); IAsyncResult rIsynResult = cmd.BeginExecuteReader(cb, cmd, CommandBehavior.CloseConnection); return rIsynResult; } void EndAsyncOperation(IAsyncResult IResult) { if (!IResult.IsCompleted) { IResult.AsyncWaitHandle.WaitOne(); } else { SqlDataReader dr = (IResult.AsyncState as SqlCommand).EndExecuteReader(IResult); if (!dr.IsClosed) { List<string> _list = new List<string>(); while (dr.Read()) { _list.Add(dr[0].ToString()); } this.GridView1.DataSource = _list; this.GridView1.DataBind(); } dr.Close(); } }这是代码,但是Oracle里没有 cmd.BeginExecuteReader()这个方法。 C#的线程处理 C#中try catch的使用 SerialPort问题,在线等 Graphics问题 怎么判断数据表中相关内容列全为空!!!请高人指点下!!谢谢 C#能做什么?有没有人做过与硬件有关的程序,就像C++ 一样 一个关于播放清单的问题 关于自定义公式解析的问题 WinForm中如何将数据库中的一张表导成Excel表 昨天考高程考得不错,散分了 C#反射问题 才疏学浅,求助,C#调用C++ dll 返回结构体数组指针
{
AddOnPreRenderCompleteAsync(
new BeginEventHandler(BeginAsyncOperation),
new EndEventHandler(EndAsyncOperation)
);
}
IAsyncResult BeginAsyncOperation(object sender, EventArgs e, AsyncCallback cb, object state)
{
string sql = "SELECT TOP 10 * FROM dbo.Card_Ext";
SqlConnection _conn = new SqlConnection(ConfigurationManager. AppSettings["DataAccessContionStringRead"].ToString()); _conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
IAsyncResult rIsynResult = cmd.BeginExecuteReader(cb, cmd, CommandBehavior.CloseConnection); return rIsynResult;
}
void EndAsyncOperation(IAsyncResult IResult)
{
if (!IResult.IsCompleted)
{
IResult.AsyncWaitHandle.WaitOne();
}
else
{
SqlDataReader dr = (IResult.AsyncState as SqlCommand).EndExecuteReader(IResult);
if (!dr.IsClosed)
{
List<string> _list = new List<string>();
while (dr.Read())
{
_list.Add(dr[0].ToString());
}
this.GridView1.DataSource = _list;
this.GridView1.DataBind();
}
dr.Close();
}
}这是代码,但是Oracle里没有 cmd.BeginExecuteReader()这个方法。