Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>code on aspx page will be as follows:</p> <pre><code>&lt;/head&gt; &lt;body&gt; &lt;form id="form1" runat="server"&gt; &lt;div&gt; &lt;asp:TextBox ID="txtName" runat="server"&gt;&lt;/asp:TextBox&gt; &lt;asp:TextBox ID="txtFromDate" runat="server"&gt;&lt;/asp:TextBox&gt; &lt;asp:TextBox ID="txtToDate" runat="server"&gt;&lt;/asp:TextBox&gt; &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server"&gt; &lt;SelectParameters&gt; &lt;asp:ControlParameter ControlID="txtName" DefaultValue="%" Name="Name" PropertyName="Text" /&gt; &lt;asp:ControlParameter ControlID="txtFromDate " DefaultValue="%" Name="FromDate" PropertyName="Text"/&gt; &lt;asp:ControlParameter ControlID="txtToDate" DefaultValue="%" Name="txtToDate" PropertyName="Text"/&gt; &lt;/SelectParameters&gt; &lt;/asp:SqlDataSource&gt; &lt;asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"&gt; &lt;/asp:GridView&gt; &lt;asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" /&gt; &lt;/div&gt; &lt;/form&gt; </code></pre> <p> </p> <p>and code on button click event will be as follows:</p> <pre><code> protected void Button1_Click(object sender, EventArgs e) { string name = txtName.Text; string fromdate = txtFromDate.Text; string todate = txtToDate.Text; SqlDataSource1.SelectParameters.Clear(); SqlDataSource1.SelectParameters.Add("@Name", name); SqlDataSource1.SelectParameters.Add("@FromDate" , fromdate); SqlDataSource1.SelectParameters.Add("@ToDate", todate); GridView1.Visible = true; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload