Simple example of retrieving information from the database and printing it out on the page

I need a simple example of selecting some data from mssql database and 开发者_运维技巧then printing it out arbitrarily into controls or however you would go about printing them to the page. Thanks.

If you are looking at a simple option, Look at the example of gridview and sqldatasource where a gridview is populated with data from sql db. msdn is a good place to start. http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.aspx