Retrive data to text boxes using search

Question

Hi, I need to design a page with student information ,first name ,last name,address phone number etc., for this i want to use excel as my database where i predefinely given required data in it and i need a search text box in the c# page when i enter the student id the relative columns data has to be display in given text boxes and i am new to this can any explain me with screen shots.

Krishna Rajput Singh · Answer

hello friends here answer helpful for you   http://www.textfixer.com/tutorials/html-search-box.php   http://stackoverflow.com/questions/14113025/how-to-display-data-from-database-into-textbox-and-update-it    in search button in C# code some of code by me i hope helpful privat void srchbutton_click(object sender EventArgs) { con.open ();     // con.open is connection open u need to want to full code contact me  String query="select * from student where studentid=@studentid"; SqlCommand cmd=new SqlCommand(query,con); Cmd.paramerts.Add(new Sqlparamerts("@studentid",combobox1.text); SqlDataReader.readdata=cmd.ExecuteReader(); while(readdata.Read()) { textbox1.Text=readdata[1].Tostring(); textbox2.Text=readdata[2].Tostring(); textbox3.Text=readdata[3].Tostring(); textbox4.Text=readdata[4].Tostring();  }  con.close(); }