Dim str As String = "select * from tab where name='"+Text1.text+"'" Session("searchP") = str Dim mycmd As SqlCommand mycmd = con.CreateCommand() con.Open() //Me.DgshowProject.AllowPaging = False mycmd.CommandText = str Dim result As SqlDataReader result = mycmd.ExecuteReader() 'DgShowCustomer.DataSource = result 'DataBind() If result.HasRows Then DgshowProject.DataSource = result DgshowProject.DataBind() Else Response.Write("<script>alert('數據庫中未找到查詢記錄!');</script>") Response.Write("<script>window.location.href='ACM_Project_QO.aspx'</script>") End If // Me.DgshowProject.AllowPaging = True之前用了这个,也没有报错,怎么现在就报这样的错呢?麻烦了
Dim mycmd As SqlCommand
mycmd = con.CreateCommand()
con.Open()
//Me.DgshowProject.AllowPaging = False
mycmd.CommandText = str
Dim result As SqlDataReader
result = mycmd.ExecuteReader()
'DgShowCustomer.DataSource = result
'DataBind()
If result.HasRows Then
DgshowProject.DataSource = result
DgshowProject.DataBind()
Else
Response.Write("<script>alert('數據庫中未找到查詢記錄!');</script>")
Response.Write("<script>window.location.href='ACM_Project_QO.aspx'</script>")
End If
// Me.DgshowProject.AllowPaging = True之前用了这个,也没有报错,怎么现在就报这样的错呢?麻烦了