Imports System.Data.SqlClient
Imports System.Data
Partial Class SearchBookType
Inherits System.Web.UI.Page
Public con As New SqlConnection(Convert.ToString(ConfigurationManager.ConnectionStrings("BookShopConnectionString"))) Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Try
Dim Searchstr As String = txtSearchstr.Text
Dim s As String = "%" + Trim(Searchstr) + "%"
Dim sqlstr As String
sqlstr = "select * from BookType where TypeName like '" & s & "'"
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim da As SqlDataAdapter = New SqlDataAdapter(sqlstr, con)
Dim dt As DataSet = New DataSet()
da.Fill(dt)
dgBookType.DataSource = dt
dgBookType.DataBind()
con.Close()
Catch ex As Exception
End Try End Sub
End Class
Imports System.Data
Partial Class SearchBookType
Inherits System.Web.UI.Page
Public con As New SqlConnection(Convert.ToString(ConfigurationManager.ConnectionStrings("BookShopConnectionString"))) Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Try
Dim Searchstr As String = txtSearchstr.Text
Dim s As String = "%" + Trim(Searchstr) + "%"
Dim sqlstr As String
sqlstr = "select * from BookType where TypeName like '" & s & "'"
If con.State = ConnectionState.Closed Then
con.Open()
End If
Dim da As SqlDataAdapter = New SqlDataAdapter(sqlstr, con)
Dim dt As DataSet = New DataSet()
da.Fill(dt)
dgBookType.DataSource = dt
dgBookType.DataBind()
con.Close()
Catch ex As Exception
End Try End Sub
End Class
弹出信息
endif