.net速度慢，求解决方案
前台：
<%@ Page Language="C#" AutoEventWireup="true" ValidateRequest="false" CodeFile="jyxm.aspx.cs"
Inherits="Jybg_jyxm" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script language="javascript" src="../js/jquery.js" type="text/javascript"></script>
<script language="javascript" src="../js/common.js" type="text/javascript"></script>
<script language="javascript" src="../js/jyxm.js" type="text/javascript"></script>
</head>
<body style="margin: 0;">
<script language="javascript" type="text/javascript">
//获得焦点
//如果是AutoComplete则设置相关内容
function GetFocus(Name) {
var TextName;
var AutoCompleteClientId;
var ContextKey;
var AutoCompleteName;
switch (Name) {
case "TextDw":
TextName = document.getElementById("<%=TextXm.ClientID %>");
ContextKey = "检验项目/单位" + "| and 项目='" + TextName.value + "'";
AutoCompleteClientId = "<%=TextDw_AutoCompleteExtender.ClientID %>";
AutoCompleteName = $find(AutoCompleteClientId);
if (AutoCompleteName != null)
AutoCompleteName.set_contextKey(ContextKey);
break;
case "TextBz":
TextName = document.getElementById("<%=TextXm.ClientID %>");
ContextKey = "检验项目/标准" + "| and 项目='" + TextName.value + "'";
TextName = document.getElementById("<%=TextDw.ClientID %>");
ContextKey = ContextKey + " and 项目单位='" + TextName.value + "'";
AutoCompleteClientId = "<%=TextBz_AutoCompleteExtender.ClientID %>";
AutoCompleteName = $find(AutoCompleteClientId);
if (AutoCompleteName != null)
AutoCompleteName.set_contextKey(ContextKey);
break;
case "TextJybz":
TextName = document.getElementById("<%=TextXm.ClientID %>");
ContextKey = "检验项目/检验标准" + "| and 项目='" + TextName.value + "'";
TextName = document.getElementById("<%=TextDw.ClientID %>");
ContextKey = ContextKey + " and 项目单位='" + TextName.value + "'";
AutoCompleteClientId = "<%=TextJybz_AutoCompleteExtender.ClientID %>";
AutoCompleteName = $find(AutoCompleteClientId);
if (AutoCompleteName != null)
AutoCompleteName.set_contextKey(ContextKey);
break;
case "TextPdbz":
TextName = document.getElementById("<%=TextXm.ClientID %>");
ContextKey = "检验项目/判定标准" + "| and 项目='" + TextName.value + "'";
TextName = document.getElementById("<%=TextBz.ClientID %>");
ContextKey = ContextKey + " and 项目标准='" + TextName.value + "'";
AutoCompleteClientId = "<%=TextPdbz_AutoCompleteExtender.ClientID %>";
AutoCompleteName = $find(AutoCompleteClientId);
if (AutoCompleteName != null)
AutoCompleteName.set_contextKey(ContextKey);
break;
if (GetId(Name).value == "") GetId(Name).value = GetId("HiddenPdbz").value;
break;
}
StatusTip(Name);
}
</script>
<form id="form1" runat="server">
<cc1:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" ScriptMode="Release"
EnableScriptGlobalization="True">
</cc1:ToolkitScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" Visible="true">
<ContentTemplate>
<input id="HiddenUser" type="hidden" runat="server" />
<input id="HiddenConfig" type="hidden" runat="server" />
<div class="Head">
<asp:Panel ID="PanelSelect" runat="server">
分类：<asp:RadioButton ID="RadioButtonBgfl0" runat="server" GroupName="bgfl" Text="所有"
Checked="True" OnCheckedChanged="RadioButton_CheckedChanged" AutoPostBack="True" /></asp:Panel>
<div style="overflow: auto; width: 780px; height: 100px">
<asp:GridView ID="GridViewBgbh" runat="server" OnRowDataBound="GridViewBgbh_RowDataBound">
</asp:GridView>
</div>
<br />
报告编号：<asp:TextBox ID="TextBgbh" runat="server" MaxLength="9" Width="75px"></asp:TextBox>
<cc1:AutoCompleteExtender ID="TextBgbh_AutoCompleteExtender" runat="server" ContextKey="检验项目/报告编号"
TargetControlID="TextBgbh">
</cc1:AutoCompleteExtender>
<asp:Button ID="ButtonJyxmRead" runat="server" Text="读出" OnClick="ButtonJyxmRead_Click" />
产品名称：<asp:TextBox ID="TextCpmc" runat="server" Width="160px" Enabled="False"></asp:TextBox>
序号：<asp:TextBox ID="TextXh" runat="server" Width="30px" Enabled="True" Text="1"></asp:TextBox>
<asp:Button ID="ButtonYlbz" runat="server" Text="查询已录标准" OnClick="FindBz"
Enabled="False" />
<asp:Button ID="ButtonXsbg" runat="server" Text="查询相似报告" OnClick="FindBz" Enabled="False" />
<br />
项目：<asp:TextBox ID="TextXm" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ID="TextXm_AutoCompleteExtender" runat="server" CompletionInterval="100"
CompletionListCssClass="CompletionList" ContextKey="检验项目/项目" DelimiterCharacters=""
Enabled="True" MinimumPrefixLength="1" OnClientItemSelected="OnACEItemSelected"
ServiceMethod="GetSearchTerms" ServicePath="~/AutoCompleteService.asmx" TargetControlID="TextXm">
</cc1:AutoCompleteExtender>
单位：
<asp:TextBox ID="TextDw" runat="server" Width="70"></asp:TextBox>
<cc1:AutoCompleteExtender ID="TextDw_AutoCompleteExtender" runat="server" CompletionInterval="100"
CompletionListCssClass="CompletionList" ContextKey="项目单位" DelimiterCharacters=""
Enabled="True" MinimumPrefixLength="1" ServiceMethod="GetSearchTerms" ServicePath="~/AutoCompleteService.asmx"
TargetControlID="TextDw">
</cc1:AutoCompleteExtender>
标准：
<asp:TextBox ID="TextBz" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ID="TextBz_AutoCompleteExtender" runat="server" CompletionInterval="100"
CompletionListCssClass="CompletionList" ContextKey="项目标准" DelimiterCharacters=""
Enabled="True" MinimumPrefixLength="1" ServiceMethod="GetSearchTerms" ServicePath="~/AutoCompleteService.asmx"
TargetControlID="TextBz">
</cc1:AutoCompleteExtender>
<br />
检验标准：<asp:TextBox ID="TextJybz" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ID="TextJybz_AutoCompleteExtender" runat="server" CompletionInterval="100"
CompletionListCssClass="CompletionList" ContextKey="检验标准" DelimiterCharacters=""
Enabled="True" MinimumPrefixLength="1" ServiceMethod="GetSearchTerms" ServicePath="~/AutoCompleteService.asmx"
TargetControlID="TextJybz">
</cc1:AutoCompleteExtender>
判定标准：<asp:TextBox ID="TextPdbz" runat="server"></asp:TextBox>
<cc1:AutoCompleteExtender ID="TextPdbz_AutoCompleteExtender" runat="server" CompletionInterval="100"
CompletionListCssClass="CompletionList" ContextKey="判定标准" DelimiterCharacters=""
Enabled="True" MinimumPrefixLength="1" ServiceMethod="GetSearchTerms" ServicePath="~/AutoCompleteService.asmx"
TargetControlID="TextPdbz">
</cc1:AutoCompleteExtender>
<asp:TextBox ID="HiddenJyxmId" runat="server" CssClass="Hidden" Enabled="false" />
<asp:TextBox ID="HiddenPdbz" runat="server" CssClass="Hidden" Enabled="false" />
<asp:TextBox ID="HiddenBgbh" runat="server" CssClass="Hidden" Enabled="false" />
<asp:TextBox ID="HiddenRowIndex" runat="server" CssClass="Hidden" Enabled="false" />
<asp:Button ID="ButtonJyxmAdd" runat="server" Enabled="False" OnClick="SaveJyxmData"
Text="添加" />
<asp:Button ID="ButtonJyxmEdit" runat="server" Enabled="False" OnClick="SaveJyxmData"
Text="编辑" />
<asp:Button ID="ButtonJyxmInsert" runat="server" Enabled="False" OnClick="SaveJyxmData"
Text="插入" />
<asp:Button ID="ButtonJyxmDelete" runat="server" Enabled="False" OnClick="SaveJyxmData"
Text="删除" />
<br />
</div>
<div class="Table">
<asp:GridView ID="GridViewJyxm" runat="server" OnRowDataBound="GridViewJyxm_RowDataBound">
</asp:GridView>
</div>
</ContentTemplate>
</asp:UpdatePanel>
</form>
</body>
</html>
速度很慢，有人说是gridview的原因，有人说是sql的原因，但其他类似页面速度还可以，不知道是什么原因？
[解决办法]
你的SELECT 语句写在页面里，应该进行分层。
另外别一次从数据库取出所有数据，你数据多的话，会慢的一塌糊涂，甚至死机。
[解决办法]
