asp.net2.0中无控件用代码连接数据库

一、连接ACCESS2000数据库bao#xiu.mdb
1)在web.config中添加
<connectionStrings>
  <add name="baoxiuConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\bao#xiu.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>
 </connectionStrings>
2 在代码中创建连接
        OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["baoxiuConn"].ConnectionString);
       
二连接SQL2000数据库
1)在web.config中添加
<connectionStrings>
    <add name="ConnectionString" connectionString="Data Source=ZJJ0580\LOCALHOST;Initial Catalog=zjjzx;User ID=sa;Password=sandboy" providerName="System.Data.SqlClient"/>
  </connectionStrings>
2)在代码中创建连接
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
  
当然,如果用控件,那就真正达到了零代码编程,特酷!!