Protected Sub search_bot_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles search_bot.Click
Dim strConn As String
Dim sqluername As String
strConn = WebConfigurationManager.ConnectionStrings("conn").ConnectionString
Dim Conn As New SqlConnection(strConn)
Conn.Open()
sqluername = "SELECT * From drug where id_mode = '" & name_mode1.Text & "' AND id_shop = '" & name_shop1.Text & "' AND name_drug like '%" & search_text.Text & "%' "
Dim da As New SqlDataAdapter(sqluername, Conn)
Dim ds As New DataSet
da.Fill(ds, "drug")
GridView1.DataSource = ds.Tables("drug")
GridView1.DataBind()
Conn.Close()
'-----------------------------------------------------------------------------------------------
Dim strConn1 As String
Dim sqluername1 As String
strConn1 = WebConfigurationManager.ConnectionStrings("conn").ConnectionString
Dim Conn1 As New SqlConnection(strConn1)
Conn1.Open()
sqluername1 = "SELECT * From drug where id_mode = '" & name_mode2.Text & "' AND id_shop = '" & name_shop2.Text & "' AND name_drug like '%" & search_text.Text & "%' "
Dim da1 As New SqlDataAdapter(sqluername1, Conn1)
Dim ds1 As New DataSet
da.Fill(ds1, "drug")
GridView2.DataSource = ds1.Tables("drug")
GridView2.DataBind()
Conn1.Close()
End Sub