在web.config里写: <appSettings>
<add key="SQLConnString" value="server=192.168.2.123;database=DB;User ID=sa;password=sa"/>
</appSettings>在页面里调用:
myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLConnString"]);记得加上名称空间:
using System.Configuration;
<add key="SQLConnString" value="server=192.168.2.123;database=DB;User ID=sa;password=sa"/>
</appSettings>在页面里调用:
myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLConnString"]);记得加上名称空间:
using System.Configuration;
解决方案 »
- vs 2010运行项目shtml显示不正常
- 想在静态方法中使用服务器控件
- Linq to sql怎么调用存储过程??
- 求助gridview的问题,大家帮忙看看,谢谢!
- 推荐书籍asp.net 书籍
- 如何将一个net工程逆转为一个powerdesinger模型
- 如何通过数据引擎读取客户端EXCEL文件内容?
- ********项目即将完成了,可是还没有解决web下的打印问题,ie下的打印真烂,真是让你伤心。还有好的解决办法!!*******
- 急啊!不小心改了ASPNET用户密码怎么办?
- 关于XML的问题
- 请问在asp.net中如何控制messageBox作出判断,并由该判断引发其他事件?
- 祝大家圣诞快乐,散分!并提问
try
{
string username="";
string servername=".";
System.Xml.XmlTextReader xmr=new System.Xml.XmlTextReader(文件地址);
while(xmr.Read())
{
if(xmr.NodeType==System.Xml.XmlNodeType.Element)
{
if(xmr.HasAttributes)
{
while(xmr.MoveToNextAttribute())
{
switch(xmr.Name.Trim())
{
case "ServerName":
servername=xmr.Value.Trim();
break;
case "User":
username=xmr.Value.Trim();
break;
}
}
}
}
}
string connectstring="workstation id="+Environment.MachineName+";packet size=4096;user id="+username.Trim()+";data source="+servername.Trim()+";persist security info=True;initial catalog=数据库名;password=密码";
return connectstring;然后在页面里调用:
_Default frm1=new _Default();
this.sc.ConnectionString=frm1.SQLConn();XML文件:
<?xml version="1.0" encoding="utf-8" ?>
<Connection ServerName="服务器名" User="用户"/>
别用cs的方法用这bs上
// 函数名: 数据库连接字符串 : GetDBConnectionStringEx : Public
// 输 入: 数据库连接
// 输 出: 返回值,数据库连接
// 描 述:
//--------------------------------------------------------------------------
public int GetDBConnectionString(out string sDBConnectionString)
{
sDBConnectionString=""; //数据库连接字符串
string sDataSource="", sInitialCatalog="", sPersistSecurity="", sUserId="", sPassword="", sWorkstation="", sPacketSize=""; if (GetConfigValue("DBConnection","DataSource",out sDataSource)!=0
|| GetConfigValue("DBConnection","InitialCatalog",out sInitialCatalog)!=0
|| GetConfigValue("DBConnection","PersistSecurty",out sPersistSecurity)!=0
|| GetConfigValue("DBConnection","UserId", out sUserId)!=0
|| GetConfigValue("DBConnection","Password",out sPassword)!=0
|| GetConfigValue("DBConnection","WorkstationId",out sWorkstation)!=0
|| GetConfigValue("DBConnection","PacketSize", out sPacketSize)!=0
)
{
sErrMessage=CError.c_sErr003;
return -3; //
}
else
{
try
{
sDBConnectionString = "data source=" + sDataSource + ";"+
"initial catalog=" + sInitialCatalog + ";" +
"persist security info=" + sPersistSecurity + ";" +
"user id=" + sUserId + ";" +
"password=" + sPassword + ";" +
"workstation id=" + sWorkstation + ";" +
"packet size=" + sPacketSize;
return 0;
}
catch
{
sErrMessage=CError.c_sErr006;
return -6; //引用复制错误
}
}
}