How to look for specific items from database

Question

I a search button and a database containing tables. I want to type a value in the textBox and then retrieve matching items and then finally display them in a datagridview OR loads the items from the database into the datagridview and set the focus on some items when clicking on the search button. am new to c#.net. Please send me the codes

utsav rathour · Answer

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;

How to look for specific items from database

Answers (1)