Question

asp.net 连接字符串 新手问题

webconfig中
<add key="ConStringEncrypt" value="true"/>
<add key="ConnectionString" value="04817800402BD70E4C8B139D6E8FD6AF5568D34E500DB473BDE9A864800F4F1EADACFA0FC95D160C247C5F68353DAE0F652BCBCC942CE65E57FE68FBADB008A0E70F339F6BBB949F71A58D25853C7A5BDFF888D667C68E3C4F3D116A2D5E942E9DE91E3923AE4EDB7815DA1D2113B6F"/>

新手，
1、想知道以上2句add是什么意思，后面那串长字符是加密的什么？
2、如果要连接本地数据库（例如Web\App_Data路径下的123.mdb) 应该怎么写

Answer 1

app.config文件中这样写
<appSettings >
<add key= "url" value= "\\数据库名.mdb;"></add>
</appSettings>

连接数据库的类中：
private static string strConn = string.Empty;
private static readonly string temp = System.Windows.Forms.Application.StartupPath;
/// <summary>
/// 连接对象
/// </summary>
public static OleDbConnection Conn
{
get
{
try
{
strConn = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + temp + new Common.DESEncryptService().DesDecrypt(System.Configuration.ConfigurationSettings.AppSettings["url"].ToString()); ;
}
catch (Exception)
{

strConn = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + temp + System.Configuration.ConfigurationSettings.AppSettings["url"].ToString(); ;
}
conn = new OleDbConnection(strConn);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
else if (conn.State == ConnectionState.Broken)
{
conn.Close();
conn.Open();
}
return conn;
}
}

Answer 2

第一个add是字符串是否加密，
第二个add是在c#中调用连接字符串的名字。
加密的是连接的字符串，
access的连接串的例子：Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Administrator\Desktop\1231.accdb

Answer 3

aa=split(arr,"|")
bb[0]=split(aa[0],",")[0]+split(aa[1],",")[0]+split(aa[2],",")[0]
bb[1]=split(aa[0],",")[1]+split(aa[1],",")[1]+spklit(aa[2],",")[1]
bb[2]=split(aa[0],",")[2]+split(aa[1],",")[2]+split(aa[2],",")[2]
多的话，用for循环语句吧，只要有规律可循，就能编程实现

Answer 4

直接访问数据库文件用oledb方式，你查查这样的字符串

Answer 5

KEY就是在C#里面读取的对象。 本地数据？ assecc吗？