>#%@ Page Language="VB" %> > >#!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > >#script runat="server"> > > Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) > Me.GridView1.DataBind() > End Sub > > Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting > e.Command.Parameters("Resource").Value = TextBox1.Text > End Sub >#/script> > >#html xmlns="http://www.w3.org/1999/xhtml"> >#head runat="server"> > #title>#/title> >#/head> >#body> > #form id="form1" runat="server"> > #div> > > Enter the Parameter#br /> > #asp:TextBox ID="TextBox1" runat="server">#/asp:TextBox> > > #asp:Button ID="Button1" runat="server" onclick="Button1_Click" > Text="Get Data" /> > #br /> > #br /> > #asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" > DataSourceID="SqlDataSource1" AllowPaging="True"> > #Columns> > #asp:BoundField DataField="idKPI_WOAgingValues" > HeaderText="idKPI_WOAgingValues" InsertVisible="False" > SortExpression="idKPI_WOAgingValues" /> > #asp:BoundField DataField="IdParameter" HeaderText="IdParameter" > SortExpression="IdParameter" /> > #asp:BoundField DataField="Value" HeaderText="Value" SortExpression="Value" /> > #asp:BoundField DataField="SaveDate" HeaderText="SaveDate" > SortExpression="SaveDate" /> > #/Columns> > #/asp:GridView> > #asp:SqlDataSource ID="SqlDataSource1" runat="server" > ConnectionString="#%$ ConnectionStrings:MySqlConnection %>" > ProviderName="#%$ ConnectionStrings:MySqlConnection.ProviderName %>" > SelectCommand="select * from kpi_woagingvalues where idparameter = @resource"> > #SelectParameters> > #asp:FormParameter Name="Resource" /> > #/SelectParameters> > #/asp:SqlDataSource> > #br /> > #br /> > > #/div> > #/form> >#/body> >#/html> >>