asp net实例教程求asp。net连接数据库的最最简单的例子

求asp。net连接数据库的最最简单的例子

using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.OleDb; using System.Web; namespace Dal { public class Db { static OleDbConnection conn = null; public Db() { if (conn == null) { conn = new OleDbConnection(); conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("数据库"); } } public OleDbConnection connOpen() { conn = new OleDbConnection(); conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("数据库"); conn.Open(); return conn; } public void connClose() { if (conn != null && conn.State == ConnectionState.Open) { conn.Dispose(); conn.Close(); } } } }