寻找c#对access操作的示例
貌似我没积分，不好意思了 不过：谢谢你！想学习ado.net连access，C#对access的一些操作，想找一些例题代码什么的，学学。可以的话帮忙发些，3Q!
追问：xiexie 谢谢大家的答案。共同继续讨论，3Q
当前位置：编程学习 > C#/ASP.NET >>
答案：这是我曾经练手的一个程序中的代码。增删改查基本都来了。这里提醒一句，使用access数据库的时候，一定要注意尽量不用关键字（有些关键字估计你压根都不知道是关键字，比如user，不然报的错会让你莫名其妙）。但是不是不能用，加个中括号就好。我的access数据库是加密了的，aap.config文件的代码如下：<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="DataBaseOwner" connectionString="dbo"/>
<add name="XinXingConnectionString" connectionString=
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db2.mdb;User ID=Admin;Jet OLEDB:Database Password=密码"
providerName ="Microsoft.Jet.OLEDB.4.0"/>
</connectionStrings>
<appSettings>
<add key="DBType" value="Sql"/>
</appSettings>
</configuration>具体增删改查的代码如下：
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Configuration;
using XinXingModels;namespace XinXingDAL
{
public class ProgramService
{
#region Private Members
//从配置文件中读取数据库连接字符串
private readonly string connString =
ConfigurationManager.ConnectionStrings["XinXingConnectionString"].ToString();
private readonly string dboOwner =
ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
#endregion/// <summary>
/// 查询所有账户信息
/// </summary>
/// <returns></returns>
public IList<Account> SearchAllRemarks()
{
List<Account> account = new List<Account>();
using (OleDbConnection conn = new OleDbConnection(connString))
{
OleDbCommand objCommand = new OleDbCommand("select * from Account", conn);
conn.Open();
OleDbDataReader objReader = objCommand.ExecuteReader();
while (objReader.Read())
{
Account a = new Account();
a.Id = Convert.ToInt32(objReader["ID"]);
a.Remarks = Convert.ToString(objReader["Remarks"]);
a.LoginID = Convert.ToString(objReader["LoginID"]);
a.Pwd = Convert.ToString(objReader["Pwd"]);
a.TwoPwd = Convert.ToString(objReader["TwoPwd"]);
a.Type = Convert.ToString(objReader["Type"]);
account.Add(a);
}
objReader.Dispose();conn.Close();
conn.Dispose();
}
return account;
}
/// <summary>
/// 根据ID和备注查询相关信息
/// </summary>
/// <param name="id"></param>
/// <param name="remarks"></param>
/// <returns></returns>
public IList<Account> SelectInfoByRemarksAndID(int id, string remarks)
{
List<Account> account = new List<Account>();
using (OleDbConnection conn = new OleDbConnection(connString))
{
Account a = new Account();
string sql = string.Format("select LoginID,Pwd,TwoPwd,Type from Account Where Id={0} and remarks='{1}'", id, remarks);
OleDbCommand objCommand = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader objReader = objCommand.ExecuteReader();
if (objReader.Read())
{
a.LoginID = Convert.ToString(objReader["LoginID"]);
a.Pwd = Convert.ToString(objReader["Pwd"]);
a.Type = Convert.ToString(objReader["Type"]);
a.TwoPwd = Convert.ToString(objReader["TwoPwd"]);
account.Add(a);
}
}
return account;
}
/// <summary>
/// 查询所有备忘录
/// </summary>
/// <returns></returns>
public IList<Notepad> SearchAllInfoFromNotepad()
{
List<Notepad> notepad = new List<Notepad>();
using (OleDbConnection conn = new OleDbConnection(connString))
{
OleDbCommand objCommand = new OleDbCommand("select * from Notepad", conn);
conn.Open();
OleDbDataReader objReader = objCommand.ExecuteReader();
while (objReader.Read())
{
Notepad n = new Notepad();
n.Id = Convert.ToInt32(objReader["ID"]);
n.Time = Convert.ToDateTime(objReader["Times"]);
n.Content = Convert.ToString(objReader["Content"]);
notepad.Add(n);
}
objReader.Dispose();
conn.Close();
conn.Dispose();
}
return notepad;
}
/// <summary>
/// 将备忘录插入
/// </summary>
/// <returns></returns>
public int InsertAllInfoIntoNotepad(string note)
{
int id;
using (OleDbConnection conn = new OleDbConnection(connString))
{
string sql = string.Format("insert into Notepad(content) values('{0}')", note);
OleDbCommand objCommand = new OleDbCommand(sql, conn);
conn.Open();
id = objCommand.ExecuteNonQuery();
}
return id;
}
/// <summary>
/// 查询最后一条记录
/// </summary>
/// <returns></returns>
public string SelectLastNotepad()
{
string message = "\n";
using (OleDbConnection conn = new OleDbConnection(connString))
{
string sql = string.Format("SELECT top 1 * from notepad order by ID desc");
OleDbCommand objCommand = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataReader objReader = objCommand.ExecuteReader();
while (objReader.Read())
{
message += Convert.ToDateTime(objReader["Times"]) + "\n";
message += Convert.ToString(objReader["Content"]);
}
}
return message;
}public int InsertAccount(string loginID, string pwd,string twoPwd,string remarks,string type)
{
int id;
using (OleDbConnection conn = new OleDbConnection(connString))
{
string sql = string.Format("insert into Account(LoginID,Pwd,TwoPwd,Remarks,Type) values('{0}','{1}','{2}','{3}','{4}')", loginID, pwd, twoPwd, remarks, type);
OleDbCommand objCommand = new OleDbCommand(sql, conn);
conn.Open();
id = objCommand.ExecuteNonQuery();
}
return id;
}
}}
using System;
using System.Co
上一个：C#怎么连接串口接收数据编程
下一个：C#中TreeView与数据库绑定?
