Hello,

I am new in VB and I have a problem. I'm trying to make a page where you enter some data in the textbox and on button click you search a database and you have a results in grid. But on button click nothing happens. Here is my code. Thank you in advanced

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      ConnectionString="<%$ ConnectionStrings:RIL_FilijalaConnectionString %>" 
      
      SelectCommand="SELECT * from ol
AND (OL.JMBG = @TextBox1) ">
      <SelectParameters>
        <asp:ControlParameter ControlID="TextBox1" Name="TextBox1" 
          PropertyName="Text" />
      </SelectParameters>
    </asp:SqlDataSource>


<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<asp:Button ID="Button1" runat="server" Text="Pošalji" />

<asp:GridView ID="GridView1" runat="server" EmptyDataText="Nothing"> </asp:GridView>

And here is the code behind

Public Class About
  Inherits System.Web.UI.Page

  Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

  End Sub

  Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As EventArgs) Handles TextBox1.TextChanged

  End Sub

  Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
    GridView1.DataSource = SqlDataSource1
    GridView1.DataBind()
  End Sub

  Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting

  End Sub

  Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles GridView1.SelectedIndexChanged

  End Sub
End Class

you need to fix the SQL query that you are using .

Check for proper syntax.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.