<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection conn = new SqlConnection("server=.;database=sql2005;user id=sa;password=sqlsa;min pool size=4;max pool size=100;Connection Lifetime=30;Enlist=true;"))
{
using (SqlDataAdapter adapter = new SqlDataAdapter("waitfor delay '00:01'; select 1,2,3", conn))
{
[color=Red]adapter.SelectCommand.CommandTimeout = 120; //s[/color]
DataSet ds = new DataSet();
adapter.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>SqlDataAdapter查询超时设置-Mzwu.Com</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>如红色部分代码所示，可以设置SqlDataAdapter查询超时的时间，单位是秒。SqlDataAdapter.SelectCommand其实是一个SqlCommand对象，所以本质是设置SqlCommand对象的查询超时时间。
评论（0）
暂无评论。