form程序数据库连接界面

最新推荐文章于 2021-11-05 11:29:02 发布

jiidd

最新推荐文章于 2021-11-05 11:29:02 发布

阅读量472

点赞数

分类专栏： WinForm 文章标签： winfrom 数据库连接

本文链接：https://blog.csdn.net/jiidd/article/details/81937662

版权

WinForm 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

2013-11-29 16:01:57

http://pan.baidu.com/s/1nEjiu DBConnectSetting.dll

使用的是上面这个dll

界面代码：

Microsoft.Data.ConnectionUI.DataConnectionDialog dialog = new Microsoft.Data.ConnectionUI.DataConnectionDialog();
dialog.DataSources.Add(Microsoft.Data.ConnectionUI.DataSource.SqlDataSource);            
dialog.SelectedDataProvider = Microsoft.Data.ConnectionUI.DataProvider.SqlDataProvider;            
dialog.StartPosition = FormStartPosition.CenterScreen;            
dialog.Title = "Connect to Microsoft SQL Server";            
dialog.ConnectionString = ConnectSql.ConnectionString;             
if (Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(dialog, this) == DialogResult.OK)            
{                
    ConnectSql.SetConfigValue("ConnectionString", DES.EncryptDES(dialog.ConnectionString, "mladerby"));            
}            
App.ConnectionString = dialog.ConnectionString;

ConnectSql.cs

/// <summary>        
/// 获取连接字符串        
/// </summary>        
public static string ConnectionString        
{            
    get{                
        if (App.ConnectionString == null)                
        {                    
            string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];                    
            string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];                   
             _connectionString = DES.DecryptDES(_connectionString, "mladerby");                   
              return _connectionString;               
        }                
        else 
        {                    
            return App.ConnectionString;                
        }            
    }        
}                
/// <summary>        
/// 写操作        
/// </summary>        
/// <param name="AppKey"></param>        
/// <param name="AppValue"></param>        
public static void SetConfigValue(string AppKey, string AppValue)        
{            
                      XmlDocument xDoc = new XmlDocument();            
                      //获取可执行文件的路径和名称            
                      xDoc.Load(System.Windows.Forms.Application.ExecutablePath + ".config");            
                      XmlNode xNode;            
                      XmlElement xElem1;            
                      XmlElement xElem2;            
                      xNode = xDoc.SelectSingleNode("//appSettings");            
                      xElem1 = (XmlElement)xNode.SelectSingleNode("//add[@key='" + AppKey + "']");            
                      if (xElem1 != null)                
                      xElem1.SetAttribute("value", AppValue);            
                      else            
                      {                
                          xElem2 = xDoc.CreateElement("add");                
                          xElem2.SetAttribute("key", AppKey);                
                          xElem2.SetAttribute("value", AppValue);                
                          xNode.AppendChild(xElem2);            
                      }            
                          xDoc.Save(System.Windows.Forms.Application.ExecutablePath + ".config");            
                          ConfigurationManager.RefreshSection("appSettings");        
}        
/// <summary>        
/// 读取.exe.config的值        
/// </summary>        
/// <param name="path">.exe.config文件的路径</param>        
/// <param name="appKey">"key"的值</param>        
/// <returns>"value"的值</returns>        
internal static string GetConfigValue()        
{            
    XmlDocument xDoc = new XmlDocument();            
    xDoc.Load(System.Windows.Forms.Application.ExecutablePath + ".config");           
    XmlNode xNode;            
    XmlElement xElem;            
    xNode = xDoc.SelectSingleNode("//appSettings");            
    xElem = (XmlElement)xNode.SelectSingleNode("//add[@key=\"" + ConnectionString + "\"]");            
    if (xElem != null)    
        return xElem.GetAttribute("value");           
    else                
        return "";        
}

app.cs

public static string ConnectionString;//设置一个存储为了 App.config 文件修改后取值不会修改问题

以下是微软自带的实现界面、功能的dll

Microsoft.Data.ConnectionUI.Dialog.dll -- 微软自带的数据连接配置界面库

Microsoft.Data.ConnectionUI.dll --微软自带的数据连接配置界面库

Microsoft.Data.ConnectionUI.Dialog.resources.dll 微软自带的数据连接配置界面库语言包

详情参考：http://blog.csdn.net/sliphades/article/details/8425180