110,534
社区成员
发帖
与我相关
我的任务
分享
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\My Documents\db2.mdb;User Id=admin;Password=;";
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "test"; //这里是你查询的名称就行了,例如你的aaa或bbb
//ACCESS参数要注意:
//并不是按照名称匹配的,而是按照传入的顺序匹配的
OleDbParameter para1 = new OleDbParameter( "@StartDay", OleDbType.Date );
para1.Value = new DateTime( 2009, 1, 2 ); //假设日期为2010-01-01
cmd.Parameters.Add( para1 );
OleDbParameter para2 = new OleDbParameter( "@EndDay", OleDbType.Date );
para2.Value = new DateTime( 2009, 1, 15 ); //假设日期为2010-01-01
cmd.Parameters.Add( para2 );
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter( cmd );
da.Fill( ds );
conn.Close();
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=C:\BegASPNET\Northwind.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand comm = new OleDbCommand();
string sql = "把你在ACCESS中定义好的SQL语句引出来赋值";
comm.CommandText = sql;
comm.Connection = objConnection;
comm.Parameters.Add();...//將你原SQL中的所有变量在这申明一下,就是加进去
comm.Parameters[1].Value = 123;//当你要出入的时候,再通过赋值,传入进去。就可以了
OleDbConnection oeConn = new OleDbConnection(strConnection);
oeConn.Open();
string sql ="你的视图名称";
OleDbCommand command=new OleDbCommand(sql,oeConn);
command.Parameters.AddWithValue("@RepDay", OleDbType.DateTime).Value = 你的时间参数值;
DataTable dt = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
adapter.Fill(dt);
oeConn.Close();
adapter.Dispose();