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

Question

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

Raja T · 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

Raja T · Answer

Hi, You are most welcome.. Happy coding....:)

Hanif Hefaz · Answer

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. using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; using System.Text.RegularExpressions; public partial class Search:System.Web.UI.Page { protected void Page_Load( object sender,EventArgse) { if (! this .IsPostBack) { this .BindGrid(); } } private void BindGrid() { string constr=ConfigurationManager.ConnectionStrings[ "regConnectionString" ].ConnectionString; using (SqlConnectioncon= new SqlConnection(constr)) { using (SqlCommandcmd= new SqlCommand()) { cmd.CommandText= "SELECT*FROMprojectsWHERECompanyLIKE'%'+@Company+'%'" ; cmd.Connection=con; cmd.Parameters.AddWithValue( "@Company" ,txtSearch.Text.Trim()); DataTabledt= new DataTable(); using (SqlDataAdaptersda= new SqlDataAdapter(cmd)) { sda.Fill(dt); GridView1.DataSource=dt; GridView1.DataBind(); } } } } protected void OnPageIndexChanging( object sender,GridViewPageEventArgse) { GridView1.PageIndex=e.NewPageIndex; this .BindGrid(); } protected void Button1_Click( object sender,EventArgse) { this .BindGrid(); } }

Hanif Hefaz · Answer

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.

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

Answers (4)