好多网友朋友问我如何实现Access/Sql/Oracle数据类型切换,其实原理很简单,在Web.Config里面添加一变量,根据变量值进行不同的数据类型切换 举一个非常简单的例子:
Web.Config代码如下:
今天就到这里,待续...........(转文请注明出处)
static
void
Main(
int
n)
... {
switch(n)
...{
case 0:
Console.WriteLine("Access");
break;
case 1:
Console.WriteLine("Sqlserver");
break;
default:
Console.WriteLine("Oracle");
break;
}
}
... {
switch(n)
...{
case 0:
Console.WriteLine("Access");
break;
case 1:
Console.WriteLine("Sqlserver");
break;
default:
Console.WriteLine("Oracle");
break;
}
}
Web.Config代码如下:
<
appSettings
>
< add key ="ELDataType" value ="1" />
< add key ="ELAccess" value ="new.mdb" />
< add key ="ELOracle" value ="Data Source=EdisonLiu;password=EdisonLiu;user id=EdisonLiu;min pool size=4;max pool size=4" />
< add key ="ELSqlserver" value ="server=EdisonLiu;database=EdisonLiu;uid=EdisonLiu;pwd=EdisonLiu " />
appSettings>
< add key ="ELDataType" value ="1" />
< add key ="ELAccess" value ="new.mdb" />
< add key ="ELOracle" value ="Data Source=EdisonLiu;password=EdisonLiu;user id=EdisonLiu;min pool size=4;max pool size=4" />
< add key ="ELSqlserver" value ="server=EdisonLiu;database=EdisonLiu;uid=EdisonLiu;pwd=EdisonLiu " />
appSettings>