Retrive data to text boxes using search

Question

Hi I need to design a page with student information first name last nameaddress 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(querycon); Cmd.paramerts.Add(new Sqlparamerts(@studentidcombobox1.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(); }