How to search for a specific record in a data gridview c#

Hanif Hefaz

10y1k.NET

Hello, i want to search for a specific record in my page how to code that? here is the image

4 Replies

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

Raja T10y ago
Accepted answer
Hi, Please refer below links
Gridview:
http://www.c-sharpcorner.com/UploadFile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/
http://www.aspsnippets.com/Articles/Search-records-in-GridView-and-highlight-results-in-ASPNet-using-C-and-VBNet.aspx
DataGridview:
http://www.c-sharpcorner.com/UploadFile/1e050f/search-record-in-datagridview-C-Sharp/
http://stackoverflow.com/questions/13173915/search-for-value-in-datagridview-in-a-column
http://stackoverflow.com/questions/10179223/find-a-row-in-datagridview-based-on-column-and-value
+1
Raja T10y ago
Hi, You are most welcome.. Happy coding....:)
0
Hanif Hefaz10y ago
YES!!!
the second link worked Thank You Raja, here i will post all the code needed in my project, and thanks to the original coder.
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Web;
usingSystem.Data;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
usingSystem.Text.RegularExpressions;
publicpartialclassSearch:System.Web.UI.Page
{
protectedvoidPage_Load(objectsender,EventArgse)
{
if(!this.IsPostBack)
{
this.BindGrid();
}
}
privatevoidBindGrid()
{
stringconstr=ConfigurationManager.ConnectionStrings["regConnectionString"].ConnectionString;
using(SqlConnectioncon=newSqlConnection(constr))
{
using(SqlCommandcmd=newSqlCommand())
{
cmd.CommandText="SELECT*FROMprojectsWHERECompanyLIKE'%'+@Company+'%'";
cmd.Connection=con;
cmd.Parameters.AddWithValue("@Company",txtSearch.Text.Trim());
DataTabledt=newDataTable();
using(SqlDataAdaptersda=newSqlDataAdapter(cmd))
{
sda.Fill(dt);
GridView1.DataSource=dt;
GridView1.DataBind();
}
}
}
}
protectedvoidOnPageIndexChanging(objectsender,GridViewPageEventArgse)
{
GridView1.PageIndex=e.NewPageIndex;
this.BindGrid();
}
protectedvoidButton1_Click(objectsender,EventArgse)
{
this.BindGrid();
}
}
0
Hanif Hefaz10y ago
Hello Raja, and thanks for the reply,
Unfortunately, the first and third links were not help full to me, i have visited them before, and tried, the first one is really dumb, and the second one says (Both datasource and datasource id are defined at one place, i separated them but didn't work.
and thanks for the second link i will try it now.
0