谁能给个ADODB.NET和ADODB的例子.

来源:百度知道 编辑:UC知道 时间:2024/09/22 09:21:31
谁能给个ADODB.NET和ADODB向ACCESS添加数据的例子.

注:不要网上的,要自己写的.

string str = "连接串";
using (OleDbConnection conn = new OleDbConnection(str))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand("insert into 表名(字段1,字段2,...)values(值一,值二,...)",conn);
cmd.ExecuteNonQuery();
}

/// <summary>
/// 返回查询的数据表
/// </summary>
/// <param name="sql">查询语句</param>
/// <returns></returns>
public DataTable DataTableBack(string sql)
{

string strconnection = "provider=microsoft.jet.oledb.4.0;data source=D:\\RootStone\\App_Data\\rootstone.mdb";

OleDbConnection myconn = new OleDbConnection(strconnection);
myconn.Open();
OleDbCommand mycmd = new OleDbCommand(sql, myconn);
DataTable dt = new DataTable();
try