How to look for specific items from database

Here is a code that will help. Do not copy and paste as it wont work that way. Write it down yourself. using system.data.sqlclient; //declare variables sqlconnection cn; sqldataadapter da; dataset ds; //in form_load cn= new sqlconnection("server=servername;uid=username;pwd=password;data=database_name;); cn.open(); //in button click da = new sqldataadapter("select * from table_name where fieldname = '"+ textbox1.text +"'",cn); ds = new dataset(); da.fill(ds,"table_name"); //all your datas that match the criteria are now selected. //Now showing on the dataridview. (in button click) dataGridView1.DataMember = "table_name"; dataGridView1.DataSource = ds;