/// <summary> /// 创建SqlConnection /// </summary> /// <returns></returns> public static SqlConnection getSqlCon() { //string sqlcon = ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString; SqlConnection con = new SqlConnection(DataConnectManager.return_ConnectString()); con.Open(); return(con); }
private void btn_Link_Click(object sender, EventArgs e) { bool isconnect = DataConnectManager.ConnectDataBase(txt_fuwuqi.Text, txt_uid.Text, txt_pwd.Text, cmb_database.SelectedItem.ToString()); if (isconnect == true) { MessageBox.Show("数据库连接成功!"); } else { MessageBox.Show("数据库连接失败!"); } }
/// <summary> /// 建立连接字符串 /// </summary> /// <param name="uid"></param> /// <param name="pwd"></param> /// <param name="basename"></param> public static bool ConnectDataBase(string fuwuqi, string uid, string pwd, string basename) { bool isConnect = false; string path = Application.StartupPath + "\\App.config"; XmlDocument doc = new XmlDocument(); doc.Load(path); XmlNodeList nodes = doc.GetElementsByTagName("add"); //nodes[0].RemoveAll(); //doc.Save(path); string attrvalue = "server=" + fuwuqi + ";database=" + basename + ";uid=" + uid + ";pwd=" + pwd + ";"; //XmlAttribute attr_name = doc.CreateAttribute("name"); //attr_name.Value = "sqlcon"; //nodes[0].Attributes.Append(attr_name); //XmlAttribute attr_connect = doc.CreateAttribute("connectionString"); //attr_connect.Value = attrvalue; //nodes[0].Attributes.Append(attr_connect); XmlElement ele = (XmlElement)nodes[0]; ele.SetAttribute("connectionString", attrvalue); doc.Save(path); SqlConnection con = null; try { con = new SqlConnection(DataConnectManager.return_ConnectString()); con.Open(); isConnect = true; return(isConnect); } catch { return(isConnect); } finally { con.Close(); } }