Gridview filter when typing on a textbox

Dealy

10y4.2kVisual Basic .NET

Hello,

I have the following code:

>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>title>
<style type="text/css">
.auto-style1 {
width: 4px;
}
style>
head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td class="auto-style2">
<asp:Label ID="lblIDNO" runat="server" Text="IDNO:">asp:Label>
td>
<td class="auto-style3">
<asp:TextBox ID="srchIDNO" runat="server">asp:TextBox>
td>
tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Name: ">asp:Label>
td>
<td>
<asp:TextBox ID="srchName" runat="server">asp:TextBox>
td>
tr>
table>
<br />
<asp:GridView ID="gvDisplay" runat="server" AutoGenerateColumns="false" DataSourceID="SqlDataSource1"
DataKeyNames="IDNO" OnRowDataBound="OnRowDataBound" EmptyDataText="Δεν υπάρχουν καταχωρημένες αιτήσεις." >
<Columns>
<asp:BoundField DataField="IDNO" HeaderText="IDNO" ItemStyle-Width="50" />
<asp:BoundField DataField="CName" HeaderText="CName" ItemStyle-Width="80" />
<asp:CommandField ButtonType="Link" ShowEditButton="true"
ShowDeleteButton="true" ItemStyle-Width="100" />
Columns>
asp:GridView>
<br />
<table>
<tr>
<td class="auto-style1">
IDNO:<br />
<asp:TextBox ID="txtIDNO" runat="server" Width="100" />
td>
<td class="auto-style4">
Name:<br />
<asp:TextBox ID="txtName" runat="server" Width="200" />
td>
<td class="auto-style5">
<asp:Button ID="btnAdd" runat="server" Text="Insert" OnClick="Insert" Width="90px" />
td>
tr>
table>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connectionString %>"
DeleteCommand="sprocDelete" DeleteCommandType="StoredProcedure"
InsertCommand="sprocInsert" InsertCommandType="StoredProcedure"
SelectCommand="sprocSelect" SelectCommandType="StoredProcedure"
UpdateCommand="sprocUpdate" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="txtIDNO" Name="IDNO" Type="String" />
<asp:ControlParameter ControlID="txtName" Name="CName" Type="String" />
SelectParameters>
<InsertParameters>
<asp:ControlParameter ControlID="txtIDNO" Name="IDNO" Type="String" />
<asp:ControlParameter ControlID="txtName" Name="CName" Type="String" />
InsertParameters>
<UpdateParameters>
<asp:Parameter Name="IDNO" Type="String" />
<asp:Parameter Name="CName" Type="String" />
UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="IDNO" Type="String" />
DeleteParameters>
asp:SqlDataSource>
div>
form>
body>
html>

protected void Insert(object sender, EventArgs e)
{
SqlDataSource1.Insert();
txtIDNO.Text = String.Empty;
txtName.Text = String.Empty;
}
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow && gvDisplay.EditIndex != e.Row.RowIndex)
{
(e.Row.Cells[2].Controls[2] as LinkButton).Attributes["onclick"] = "return confirm('Do you want to delete this row?');";
}
}

How can I filter the gridview while typing on the textboxes? sprocSelect take parameters the IDNO and Name.

Thank you in advance.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Accepted answer
Hi
Dont use data source user SQLconnection proivider to bind the grid. as provided in link
http://www.aspdotnet-pools.com/2014/09/search-gridview-record-on-button-click.html
0
Dealy10y ago
All of your answers work if I don't use SQLDataSource, so I changed my code.
I will mark as accepted answer the example I used.
Thank you all.
0
Tapan Patel10y ago
You can refer to below article of mine, may be something similar would help you.

http://www.c-sharpcorner.com/article/listbox-filtered-in-wpf/

Please mark it as answer if it resolves the issue.
0
Bikesh Srivastava10y ago
Hi,
This is the best example of your query..
http://www.aspsnippets.com/Articles/Search-and-Filter-GridView-as-you-type-in-TextBox-using-jQuery-AJAX-in-ASPNet.aspx
0
Dealy10y ago
I already have the code for select/insert/update/delete through sqldatasource.
Is there a way to have the filtering work with that method?
I already tried to pass the parameters through <SelectParameters>but I get the EmptyDataText.
sprocSelect is tested and works with or without parameters (if no input given takes null as the parameter's value)
Thanks again for the help.
0
Dealy10y ago
Thank you both for your answers.
If I use this method I get the following error because I have an SQLDataSource for binding the datagrid.
"Both DataSource and DataSourceID are defined on 'gvDisplay'. Remove one definition."
0
Vinay Singh10y ago
Hi
check the link
http://www.aspdotnet-pools.com/2014/09/search-gridview-record-on-button-click.html
0
Ajay Malik10y ago
To bind gridview data write the following code.
privatevoidGridData()
{
stringconString=ConfigurationManager.ConnectionStrings["MyCon"].ToString();
SqlConnectionsqlcon=newSqlConnection(conString);
SqlCommandsqlcmd;
SqlDataAdapterda;
DataTabledt=newDataTable();
Stringquery;
if(txtsearch.Text=="")
{
query="selectPersonID,LastName,FirstNamefromPerson";
}
else
{
query="selectPersonID,LastName,FirstNamefromPersonwherePersonIDlike'"+txtsearch.Text+"%'orLastNamelike'"+txtsearch.Text+"%'orFirstNamelike'"+txtsearch.Text+"%'";
}
sqlcmd=newSqlCommand(query,sqlcon);
sqlcon.Open();
da=newSqlDataAdapter(sqlcmd);
dt.Clear();
da.Fill(dt);
if(dt.Rows.Count>0)
{
grdsearch.DataSource=dt;
grdsearch.DataBind();
}
else
{
grdsearch.DataBind();
Label1.Text="NoRecordsFound";
}
sqlcon.Close();
}
In page load event
if(!IsPostBack)
{
GridData();
}
for search button click event call GridData() method and for clear button click event write following code
txtsearch.Text="";
GridData();
Label1.Text="";
0