Simple Databse Connection

hello all

the problem with me,im for the first time using SQL Server and ASP,so i have little knowledge baout these two progs.i want to know how pages in ASP are connected to databse.

second, i installed SQL Server2005 along with asp from the same CD(option of instalation of both was available). There is also a way use SQL Server within the ASP Environment(addnew itmes>sqldatabase>).

Question: if i create a databse through above method. then how i will use it in asp.net.
Although i can do it by draging "SQL Data sourcr" from "Data" category in the "toolbox"
however, i want to manually connect the application to Db.Something like this

Page_load(0

{

//db connection code goes here.
//sqlcommand goes here.

con.open()

}


 i want some controls like txtboxes and label to manualy connect to databse tables.

plz someone forward the code,