按以下这样查询,速度非常慢,有什么解决办法吗?
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
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
解决方案 »
- jquery,$(this).text()得到内容,alert出来明明显示有空格,怎么用空格去替换怎么替换不掉,还是显示出空格 ,为什么呀?
- 问下关于这个<%= %> 动态 来绑定HTML 标签写法
- NET 文件上传进度条
- js清空gridview中某一行里面所有的文本内容
- 帮忙解决~~~~~谢谢各位~~~
- 请教大家个问题,关于使用子函数的问题,谢谢
- 数据丢失,严重问题,请大家帮帮忙~~~急!
- 动态控件的问题
- C#程序访问ASP.net网页的问题
- 错误:指定的参数已超出有效值的范围。参数名: value ( 高手进)
- 母版页控件的动作如何响应到内容页里面
- URI formats are not supported
可以采用分页的方式,给你一个分页的参考:
http://www.webdiyer.com/AspNetPager/default.aspx
数据量多不多呢?试试select top 100 ... 看看是否还慢