asp.net2.0中连接数据库

SqlConnection myConnection&＃61;new SqlCOnnection()

myConnection.ConnectionString &＃61;”Data Source&＃61;localhost;”&＃43;Initial Catalog&＃61;Pubs;Integrated Security&＃61;”SSPI”;

…

String connectionString&＃61;WebConfigurationManager.ConnectionStrings[“Pubs”].ConnectionString;

SqlCommand myCommand&＃61;new SqlCommand();

myCommand.Connection&＃61;myConnection;

myCommand.CommandText&＃61;”Selet * form authors”;

or

SqlCommand myCommand&＃61;new SqlCommand(“select *from authors”,myConnection);