How to create search in webpage and retive data from MSSql.

First You open ASP.net and MSSQL on your system.

Step 1) First you create table and store information you want to search from Sql Server.



Step 2) In step first of Asp.net you drag a control on webpage just like Textbox, Button, GridView.



step 3) then connect the datagrid to database through sqldatasource.



step 4) fist you choose data source.



step 5) then you fill the all connecting information in field.



step 6) after this a show the all field name and table name from database.



step 7) you choose field which you are using in this search



step 8) after selecting field then click "where" button for where clause. and fill all informtion you used for search. ex: (Search in = "Heading" Heading is the field name of sql table, Operator= "like", Source = "control" because you use a TextBox for search, Then last is controlid ="textbox1" this is textbox name. )



step 9) then you click next button. a new window open you test a statement in this window. just like I write a "BCCI" then click ok button to show a news of "BCCI".





step 10) then after click finish button. your serch is ready.



After this you run a page your search box display in page.

you fill a text and click search then display all serch infomation.