请问连接数据库时,如何做到:我把各种数据库放进项目里,程序自己会找到此类数据库 DataSource及database的写法
[WebMethod]
public DataSet SQLDB(string Query)
{
SqlConnection CS = new SqlConnection("server=CHINA-58E53D04C;Trusted_Connection=yes;database="
+ this.Server.MapPath("test"));
SqlDataAdapter myCommand = new SqlDataAdapter(Query, CS);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "Results");
return myDataSet;
}
[WebMethod]
public DataSet AccessDB(string Query)
{
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
+ this.Server.MapPath("db2.mdb");
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
OleDbCommand myAccessCommand = new OleDbCommand(Query, myAccessConn);
OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);
myAccessConn.Open();
DataSet myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "Results");
myAccessConn.Close();
return myDataSet;
}
这里面DataSource及database的写法,可不可以又个正则表示之类的东西,自己会找到数据库。比如我放进去db.mdb,不需要知道名字就连接上去 因为webservice 生成DLL后看不见源码,如果随意放入数据库,数据库的名字怎么解决??