Search functionality in asp.net with gridview? [Resolved]

Hi,

Refer following link.
http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/

Or
Apply JQuery Data tables to your grid.
please refer this URL if you are ok with jquery plugin
http://datatables.net/release-datatables/examples/api/highlight.html

Thank you,
Govind

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

You want to get data based on search content then prepare SP as you need.

EX:

[code]
create procedure Searched_Content
(
@Search varchar(100)=null
)
as
begin
select * from tablename where colname like '%'+@Search+'%'
end
[/code]

and use this sp while binding data to gridview and in design time you just use on textbox control and based on textbox input you can search data and pass that textbox value as a input parameter for the above storedprocedure.

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator

<asp:TemplateField HeaderText="TagData">
            <ItemTemplate>
            <asp:Label ID="LblTagData" runat="server" Text="<%#Bind('TagData') %>" />
            </ItemTemplate>
            <EditItemTemplate>
                    <asp:TextBox ID="TxtTagData" Width ="400" runat="server"
                    Text="<%# Bind('TagData') %>" />
                </EditItemTemplate>
            </asp:TemplateField>
              <asp:TemplateField HeaderText="Keywords">
                     <ItemTemplate>
            <asp:Label ID="LblKeywords" runat="server" Text="<%#Bind('Keywords') %>" />
            </ItemTemplate>
             <EditItemTemplate>
                    <asp:TextBox ID="TxtKeywords" Width="100" runat="server"
                    Text="<%# Bind('Keywords') %>" />
                 </EditItemTemplate>
                </asp:TemplateField>
             <asp:TemplateField HeaderText="Tagusage">
            <ItemTemplate>
            <asp:Label ID="LblTagusage" runat="server" Text="<%#Bind('Tagusage') %>" />
            </ItemTemplate>
            <EditItemTemplate>
                    <asp:TextBox ID="TxtTagusage" runat="server"
                    Text="<%# Bind('Tagusage') %>" />
                </EditItemTemplate>
            </asp:TemplateField>

                 <asp:TemplateField HeaderText="Tag Sno">
            <ItemTemplate>
            <asp:Label ID="LblTagId" runat="server" Text="<%#Bind('TagId') %>" />
            </ItemTemplate>
           <EditItemTemplate>
                    <asp:TextBox ID="TxtTagId" runat="server"
                    Text="<%# Bind('TagId') %>" />
                </EditItemTemplate>
            </asp:TemplateField> 
</Columns> 
        </asp:GridView>

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator

My Cs code

protected void Page_Load(object sender, EventArgs e)
        {
            con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
            con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
            da = new SqlDataAdapter("Select * from Tagrankingtable where ClientId =" + Session["ClientId"], con);
            cb = new SqlCommandBuilder(da);
            ds = new DataSet();
            da.Fill(ds, "Tagrankingtable");
            GridView1.DataSource = ds.Tables["Tagrankingtable"];
            GridView1.DataBind();
                //ShowData();
           
        }

After that i want search functinality based on TagId?
For this one i am writting the below code

private void ShowData1()
        {
                      SqlConnection  con1 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
          SqlDataAdapter da1 = new SqlDataAdapter("Select CampaignName,Taglocation,TagType,TagData,Keywords,Tagusage,TagId from Tagrankingtable where ClientId =" + Session["ClientId"] + "and TagId=" + txtSearch.Text, con1);
           SqlCommandBuilder cb1 = new SqlCommandBuilder(da1);
           DataSet ds1 = new DataSet();
            da1.Fill(ds1, "Tagrankingtable");
            GridView1.DataSource = ds1.Tables["Tagrankingtable"];
            GridView1.DataBind();

        }

It is correct way for search records from gridview based on condition

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator

protected void Page_Load(object sender, EventArgs e)
        {
            con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
            con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
            da = new SqlDataAdapter("Select * from Tagrankingtable where ClientId =" + Session["ClientId"], con);
            cb = new SqlCommandBuilder(da);
            ds = new DataSet();
            da.Fill(ds, "Tagrankingtable");
            GridView1.DataSource = ds.Tables["Tagrankingtable"];
            GridView1.DataBind();
                //ShowData();
           
        }

After that i want search functinality based on TagId?
For this one i am writting the below code

private void ShowData1()
        {
                      SqlConnection  con1 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["stgdbConnectionString"].ConnectionString);
          SqlDataAdapter da1 = new SqlDataAdapter("Select CampaignName,Taglocation,TagType,TagData,Keywords,Tagusage,TagId from Tagrankingtable where ClientId =" + Session["ClientId"] + "and TagId=" + txtSearch.Text, con1);
           SqlCommandBuilder cb1 = new SqlCommandBuilder(da1);
           DataSet ds1 = new DataSet();
            da1.Fill(ds1, "Tagrankingtable");
            GridView1.DataSource = ds1.Tables["Tagrankingtable"];
            GridView1.DataBind();

        }

It is correct way for search records from gridview based on condition

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator

please help me

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator