gridview

Question

how can i search record in gridview.example suppose i add "v" in the textbox.then i can find all records starting from v(desktop application in c#)

Satyapriya Nayak · Answer

Hi Vikas, Try this.... 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.OleDb; namespace Search_datagridview { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oledbda; string str; DataSet ds; public Form1() { InitializeComponent(); } private void bindgrid() { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select name from employee where name like '" + textBox1.Text + "%'"; com = new OleDbCommand(str, con); oledbda = new OleDbDataAdapter(com); ds = new DataSet(); oledbda.Fill(ds, "employee"); dataGridView1.DataMember = "employee"; dataGridView1.DataSource = ds; con.Close(); } private void textBox1_TextChanged(object sender, EventArgs e) { bindgrid(); } } } Thanks If this post helps you mark it as answer

Abhimanyu K Vatsa · Answer

hey, find a very simple way to do this here that i've posted long days back http://www.itorian.com/2012/05/gridview-control-in-aspnet-part-2.html#.UFCO4rKPU1w

Rewant Choudhary · Answer

myConnection = WebConfigurationManager.ConnectionStrings["onnectionString"].ConnectionString; connect = new SqlConnection(myConnection); command = new SqlCommand(); connect.Open(); command.Connection = connect; string komut = "SELECT * FROM table name WHERE authername='"+textbox1.Text+"'"; try { SqlCommand sqlCommand = new SqlCommand(); sqlCommand = connect.CreateCommand(); sqlCommand.CommandText = komut; SqlDataAdapter sda = new SqlDataAdapter(sqlCommand.CommandText, connect); SqlCommandBuilder scb = new SqlCommandBuilder(sda); //Create a DataTable to hold the query results. DataTable dTable = new DataTable(); //Fill the DataTable. sda.Fill(dTable); GridView1.DataSource = dTable; GridView1.DataBind(); } catch (SqlException) { //Console.WriteLine(e.StackTrace); } reader.Close(); connect.Close();

nallya · Answer

Use like operator from sql The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern ex:SELECT * FROM Persons WHERE City LIKE 's%' Source:http://www.w3schools.com/sql/sql_like.asp