C# 参数决定连接Access和Sql(简单问题)
程序在连接Access和SQL时,是由参数来决定连接哪个类型的数据库。
if (DataType=="Access")
{
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\data.mdb";
OleDbConnection Conn = new OleDbConnection(strConn);
OleDbCommand cm = new OleDbCommand("", Conn);
OleDbDataReader dr;
}
else
{
strConn = "Server=(local);User ID=sa;Password=;Initial Catalog=Northwind";
SqlConnection Conn = new SqlConnection(strConn);
SqlCommand cm = new SqlCommand("", Conn);
SqlDataReader dr;
}
怎么返回上面的Conn,cm,dr的值?
这样一来,我想在执行SQL语句时,就不管是cm是SqlCommand 和OleDbCommand
cm.CommandText="select * from A";
cm.ExecuteNonQuery();