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
And here is the code behind
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: