Hhow to find the records from datagridview in c# u

Question

Dear Experts

How to find the Records into datagridview using from Textbox in windows application C#. Back End SQL server2005.

I am having 5 fields(Date,Name,Address,etc..) in database. All that fields are binding with data grid in Form1 and also one text box. when i am load the Form1 all fields are displaying in datagrid view. everything going good so far.
Now, I want type the some text into textbox( private void txtdate_TextChanged(object sender, EventArgs e) ) like type date (ex:05-05-2014), the date will be highlighting in Data Grid view where every it has placed.

Thanks in Advance

Sreeni

Dipankar Biswas · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { FillData(); } void FillData() { using (SqlConnection c = new SqlConnection("Data Source=Localhost; Initial catalog=damo; Integrated security=true")) { c.Open(); using (SqlDataAdapter a = new SqlDataAdapter("SELECT * FROM tbl_s", c)) { DataTable t = new DataTable(); a.Fill(t); dataGridView1.DataSource = t; c.Close(); } } } void Search() { using (SqlConnection cnn = new SqlConnection("Data Source=Localhost; Initial catalog=damo; Integrated security=true")) { cnn.Open(); using (SqlDataAdapter ab = new SqlDataAdapter("SELECT * FROM tbl_s WHERE Sname='" + textBox1.Text.ToString() + "'", cnn)) { DataSet ds = new DataSet(); ab.Fill(ds,"Sname"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "Sname"; cnn.Close(); } } } private void button1_Click(object sender, EventArgs e) { Search(); } } }

Riddhi Valecha · Answer

Hi... Placing only 1 textbox for searching records from gridview is a wrong practice. Right now, say you have 5 fields - Date, Name, Address, Salary, BankName. Now, in your backend (say SQL Server), make a dynamic search query. Your stored procedure will look like - (I am explaining for 2 variables - Date and Name.) -----------Stored Procedure---------- @Date datetime = null, @Name varchar(50) = null Begin declare @SQLQUERY as nvarchar(max) @SQLQUERY = 'select * from TableName where 1=1' If @Date is not null then @SQLQUERY = @SQLQUERY + 'and TableName.Date = '''+@Date+'''' If @Name is not null then @SQLQUERY = @SQLQUERY + 'and TableName.Name = '''+@Name+'''' exec @SQLQUERY -------------End Of Stored Procedure-------------- For Front End - Take 5 textboxes. Make a method in Code File. ANd Call the procedure. ------ Font-End is a easy task. Please send your project if you can. I will make changes in that and send it back. Hope this helps.

Hhow to find the records from datagridview in c# u

Answers (2)