大家好，又见面了，我是你们的朋友全栈君。
取得Web config文件连接数据库字符各个属性。
代码
public
string
GetConnectionValue(
string
Keyword,
string
connectionString)
{
string
[] aa
=
Keyword.Split(
‘
,
‘
);
string
[] bb
=
connectionString.Split(
‘
;
‘
);
string
strTempValue
=
string
.Empty;
foreach
(
string
b
in
bb)
{
foreach
(
string
a
in
aa)
{
if
(b.IndexOf(
“
=
“
)
<
0
)
continue
;
if
(b.StartsWith(a, StringComparison.OrdinalIgnoreCase))
strTempValue
=
b.Substring(b.IndexOf(
“
=
“
)
+
1
);
}
}
return
strTempValue;
}
代码
public
string
GetServerName()
{
string
key
=
“
Data Source,Server,Address,Addr,Network Address
“
;
return
GetConnectionValue(key);
}
public
string
GetDataBaseName()
{
string
key
=
“
Initial Catalog,Database
“
;
return
GetConnectionValue(key);
}
public
string
GetPassword()
{
string
key
=
“
Password,Pwd
“
;
return
GetConnectionValue(key);
}
public
string
GetUserId()
{
string
key
=
“
User ID,uid
“
;
return
GetConnectionValue(key);
}
public
string
GetPacketSize()
{
string
key
=
“
Packet Size
“
;
return
GetConnectionValue(key);
}
public
string
GetPooling()
{
string
key
=
“
Pooling
“
;
return
GetConnectionValue(key);
}
public
string
GetMaxPoolSize()
{
string
key
=
“
Max Pool Size
“
;
return
GetConnectionValue(key);
}
public
string
GetTrustedSecurity()
{
string
key
=
“
Integrated Security,Trusted_Connection
“
;
return
GetConnectionValue(key);
}
public
bool
IsTrustedSecurityConnection()
{
string
sScty
=
GetTrustedSecurity();
return
(sScty
==
“
SSPI
“
||
sScty
==
“
True
“
);
}
public
bool
IsAtLocalMachine()
{
string
sName
=
GetServerName();
return
(sName
==
“
127.0.0.1
“
||
sName
==
“
localhost
“
);
}
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/143292.html原文链接：https://javaforall.net
