谁能给个ADODB.NET和ADODB的例子.
来源:百度知道 编辑:UC知道 时间:2024/09/22 09:21:31
注:不要网上的,要自己写的.
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