1、配置web.config文件:配置数据库连接参数
<configuration>
<appSettings/>
<connectionStrings>
<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=F:\TeacherSystem\App_Data\db.mdb;Jet OLEDB:Database Password=123"
providerName="System.Data.OleDb" />
</connectionStrings>
2
<strong class="kgb" onmouseover="isShowAds = false;isShowAds2 = false;
isShowGg = true;InTextAds_GgLayer="_u7A0B_u5E8F_u8BBE_u8BA1";
KeyGate_ads.ShowGgAds(this,"_u7A0B_u5E8F_u8BBE_u8BA1",event)" style="border-right: 0px;
padding-right: 0px; border-top: 0px; padding-left: 0px; font-weight: normal;
padding-bottom: 0px; margin: 0px;
border-left: 0px;
cursor: hand;
color: #0000ff; padding-top: 0px;
border-bottom: 0px;
text-decoration: underline" onclick="javascript:window.open("http://pagead2.googlesyndication.com/pagead/iclk?sa=l&ai=ByoUWdLRCR8i-KZjy6wOvk_WDC7W_BMPyC8CNtwHAuAIQAhgCIIL2kgsoFDgAUMeoydYGYJ3R1IGwBaoBCjIwMDAwMTc0NTSyAQ93d3cua25vd3NreS5jb23IAQHaASJodHRwOi8vd3d3Lmtub3dza3kuY29tLzM0NTIzNC5odG1sqAMB6AMf6APXAg&num=2&adurl=http://www.allroundautomations.com/plsqldev.html&client=ca-pub-7244513001137299");
GgKwClickStat("程序设计","www.allroundautomations.com","afc","2000017454");
" onmouseout="isShowGg = false;InTextAds_GgLayer="_u7A0B_u5E8F_u8BBE_u8BA1"">程序设计开始:
1、按要求建立Access数据库及数据表
2、编写数据库访问、操作的公用类,此类可以复用到以后开发的任何系统中
(1)、新建一个C# 类库
<strong class="kgb" onmouseover="isShowAds = false;isShowAds2 = false;
isShowGg = true;InTextAds_GgLayer="_u9879_u76EE";
KeyGate_ads.ShowGgAds(this,"_u9879_u76EE",event)" style="border-right: 0px;
padding-right: 0px; border-top: 0px; padding-left: 0px; font-weight: normal;
padding-bottom: 0px; margin: 0px;
border-left: 0px;
cursor: hand; color: #0000ff;
padding-top: 0px; border-bottom: 0px;
text-decoration: underline" onclick="javascript:window.open("http://pagead2.googlesyndication.com/pagead/iclk?sa=l&ai=B7zB9dLRCR8i- KZjy6wOvk_WDC8GtzjSRxN3QA8CNtwGA8QQQFBgUIIL2kgsoFDgAUMKdsxVgndHUgbAFoAGH58n8A6oBCjIwMDAwMTc0NTSyAQ93d3cua25vd3NreS5jb23IAQHaASJodHRwOi8vd3d3Lmtub3dza3kuY29tLzM0NTIzNC5odG1sqQIxv8VdghSCPsgC_ZKeAagDAegDH-gD1wI&num=20&adurl=http://28.com/%3Fcomeid%3D20286&client=ca-pub-7244513001137299");
GgKwClickStat("项目","28.com","afc","2000017454");" onmouseout="isShowGg = false;InTextAds_GgLayer="_u9879_u76EE"">项目, 命名为“Com.LXJ”,设置项目属性:程序集名称、默认命名空间均为“Com.LXJ”
(2)、在此项目目录下创建目录Database,新建C# 类文件ConnDbForAccess.cs 在Database目录下。
添加引用:System.Web.dll
(3)、编写ConnDbForAccess.cs 的
<strong class="kgb" onmouseover="isShowAds = false;isShowAds2 = false;
isShowGg = true;InTextAds_GgLayer="_u4EE3_u7801";
KeyGate_ads.ShowGgAds(this,"_u4EE3_u7801",event)" style="border-right: 0px;
padding-right: 0px; border-top: 0px; padding-left: 0px; font-weight: normal;
padding-bottom: 0px; margin: 0px;
border-left: 0px; cursor: hand;
color: #0000ff; padding-top: 0px;
border-bottom: 0px;
text-decoration: underline" onclick="javascript:window.open("http://pagead2.googlesyndication.com/pagead/iclk?sa=l&ai=BePdQdLRCR8i-KZjy6wOvk_WDC8f43z-32oqWA8CNtwGw6gEQBRgFIIL2kgsoFDgAUISc9qL8_____wFgndHUgbAFoAHZkZT9A6oBCjIwMDAwMTc0NTSyAQ93d3cua25vd3NreS5jb23IAQHaASJodHRwOi8vd3d3Lmtub3dza3kuY29tLzM0NTIzNC5odG1sgAIBqQIxv8VdghSCPsgCw5qeAagDAegDH-gD1wI&num=5&adurl=http://www.51dz.com/s.asp%3Fid%3D2110%26i%3Dgg&client=ca-pub-7244513001137299");
GgKwClickStat("代码","www.51dz.com","afc","2000017454");
" onmouseout="isShowGg = false;InTextAds_GgLayer="_u4EE3_u7801"">代码
using System;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Configuration;
namespace Com.LXJ.Database
{
/// <summary>
/// conn 的摘要说明。
/// </summary>
public class ConnDbForAcccess
{
/// <summary>
/// 连接数据库字符串
/// </summary>
private string connectionString;
/// <summary>
/// <strong class="kgb" onmouseover="isShowAds = false;isShowAds2 = false;
isShowGg = true;InTextAds_GgLayer="_u5B58_u50A8";
KeyGate_ads.ShowGgAds(this,"_u5B58_u50A8",event)" style="border-right: 0px;
padding-right: 0px; border-top: 0px; padding-left: 0px; font-weight: normal;
padding-bottom: 0px; margin: 0px; border-left: 0px; cursor: hand; color: #0000ff;
padding-top: 0px; border-bottom: 0px;
text-decoration: underline" onclick="javascript:window.open ("http://pagead2.googlesyndication.com/pagead/iclk?sa=l&ai=BfevqdLRCR8i- KZjy6wOvk_WDC4nsiRXd__TVA8CNtwGA0w4QAxgDIIL2kgsoFDgAUKap1Nz4_____wFgndHUgbAFoAHpxcn- A6oBCjIwMDAwMTc0NTSyAQ93d3cua25vd3NreS5jb23IAQHaASJodHRwOi8vd3d3Lmtub3dza3kuY29tLzM0NTIzNC5odG1sqAMB6AMf6APXAg&num=3&adurl=http://www.sqldetective.com/entry3.php&client=ca-pub-7244513001137299");
GgKwClickStat("存储","www.sqldetective.com","afc","2000017454");
" onmouseout="isShowGg = false;InTextAds_GgLayer="_u5B58_u50A8"">存储数据库连接(保护类,只有由 它派生的类才能访问)
/// </summary>
protected OleDbConnection Connection;
/// <summary>
/// 构造函数:数据库的默认连接
/// </summary>
public ConnDbForAcccess()
{
string connStr;
connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
// connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString(); //从web.config配置中读取
connectionString = connStr;
//connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + connStr;
// connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
//
Connection = new OleDbConnection(connectionString);
}
/// <summary>
/// 构造函数:带有参数的数据库连接
/// </summary>
/// <param name="newConnectionString"></param>
public ConnDbForAcccess(string newConnectionString)
{
//connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Request.PhysicalApplicationPath + newConnectionString;
connectionString = newConnectionString;
Connection = new OleDbConnection(connectionString);
}
/// <summary>
/// 获得连接字符串
/// </summary>
public string ConnectionString
{
get
{
return connectionString;
}
}
/// <summary>
/// 执行SQL语句没有返回结果,如:执行删除、更新、插入等操作
/// </summary>
/// <param name="strSQL"></param>
/// <returns>操作<strong class="kgb" onmouseover="isShowAds = false;isShowAds2 = false;
isShowGg = true;InTextAds_GgLayer="_u6210_u529F";
KeyGate_ads.ShowGgAds(this,"_u6210_u529F",event)" style="border-right: 0px;
padding-right: 0px; border-top: 0px; padding-left: 0px; font-weight: normal;
padding-bottom: 0px; margin: 0px; border-left: 0px; cursor: hand; color: #0000ff;
padding-top: 0px; border-bottom: 0px;
text-decoration: underline" onclick="javascript:window.open ("http://pagead2.googlesyndication.com/pagead/iclk?sa=l&ai=B3U-edLRCR8i-KZjy6wOvk_WDC8S5yi-c4bjrAsCNtwGQsAoQARgBIIL2kgsoFDgAUOqM9o
没有合适的资源?快使用搜索试试~ 我知道了~
Access数据库连接(整理)
共18个文件
txt:17个
doc:1个
需积分: 9 10 下载量 182 浏览量
2008-10-03
20:08:17
上传
评论
收藏 52KB RAR 举报
温馨提示
很好的Access数据库连接代码(包含java/C#/asp.net/.net)
资源推荐
资源详情
资源评论
收起资源包目录
Access数据库连接(整理).rar (18个子文件)
Java连接access数据库.txt 5KB
Java连接access数据库.doc 54KB
Access数据库连接(整理)
c#中连接Access数据库(3).txt 1KB
ACCESS中使用SQL语句.txt 3KB
C#连接ACCESS数据库(2).txt 1KB
ASP,ASP.NET,ACCESS数据库连接.txt 3KB
sql数据库 转 Access SQL语句改写之 Case When Then When Then Else End.txt 2KB
十万条Access数据表分页的两个解决方法.txt 1KB
ASP中各种数据库连接代码.txt 2KB
access数据类型大全.txt 3KB
access 一次执行多条sql语句.txt 2KB
C#连接ACCESS数据库(1).txt 1KB
Net如何连接access数据库.txt 12KB
Sql Server 和 Access 操作数据库结构Sql语句.txt 1KB
在C#中使用ADO.Net部件来访问Access数据库.txt 3KB
定期归档Access数据库.txt 2KB
ACCESS数据库里的一些查询语句用法.txt 439B
设定Access数据库自增长字段初始值.txt 1KB
共 18 条
- 1
资源评论
lzhlkl
- 粉丝: 6
- 资源: 7
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功