SqlDataAdapter加载超时
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable dt = new DataTable();
try
{
this.Open();
adapter.SelectCommand = new SqlCommand("sysListCoursewareInfo_x", cn);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("@delstate", Convert.ToInt32(0)));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@type", type));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@kind", kind));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@special", special));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@course", course));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@CKind", ckind));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@name", name));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@Verif", 1));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@schoolid", schoolid));
adapter.Fill(dt);///执行的到这里页面会提超时错误
this.gv_CoursewareList.DataSource = dt;
this.gv_CoursewareList.DataBind();
错误信息:超时时间已到。在操作完成之前超时时间已过或服务器未响应。