Question Button - Search database HELP

SergioBG

New member
Joined
Aug 15, 2011
Messages
1
Programming Experience
Beginner
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

VB.NET:
<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

VB.NET:
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

 
Last edited:
Back
Top