gridview 绑定数据源,速度慢
按以下这样查询,速度非常慢,有什么解决办法吗?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
Data_Bind()
End If
End Sub
Private Sub Data_Bind()
Dim ConnectionStr As String = ConfigurationManager.ConnectionStrings("cw_cbConnectionString").ConnectionString
Dim SqlStr As String = "SELECT * from biao"
Dim Myds As New DataSet()
Dim SqlConn As New SqlConnection(ConnectionStr)
Try
If SqlConn.State.ToString() = "Close" Then
SqlConn.Open()
End If
Dim Sqlda As New SqlDataAdapter(SqlStr, SqlConn)
Sqlda.Fill(Myds)
Me.GridView1.DataSource = Myds.Tables(0).DefaultView
Me.GridView1.DataBind()
Catch ex As Exception
Response.Write("数据库错误,错误原因:" + ex.Message)
Response.[End]()
Finally
If SqlConn.State.ToString = "open" Then
SqlConn.Close()
End If
End Try
End Sub