C# 数据库连接设置并把设置写入到txt文本中

来源：互联网发布：湖南教育出版社的软件编辑：程序博客网时间：2024/05/20 21:18

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.IO; //调用streamwirter命名空间

namespace test1
{
    public partial class frmsqlconset : Form
    {
        public frmsqlconset()
        {
            InitializeComponent();
        }

        private void btntest_Click(object sender, EventArgs e) //测试连接是否正常
        {
            if (txbip.Text.Trim() == string.Empty || txbsqlname.Text.Trim() == string.Empty || txbname.Text.Trim() == string.Empty)
            {
                MessageBox.Show("数据库IP、数据库名称或用户名不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                string strselect = "server='"+txbip.Text.Trim()+"';database='"+txbsqlname.Text.Trim()+"';user='"+txbname.Text.Trim()+"';pwd='"+txbpwd.Text.Trim()+"'";
                SqlConnection conn = new SqlConnection(strselect);
               try
                {
                    conn.Open();
                    MessageBox.Show("数据库连接成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("数据库连接失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

        private void btnok_Click(object sender, EventArgs e)
        {
            if (txbip.Text.Trim() == string.Empty || txbsqlname.Text.Trim() == string.Empty || txbname.Text.Trim() == string.Empty)
            {
                MessageBox.Show("数据库IP、数据库名称或用户名不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                string strselect = "server='" + txbip.Text.Trim() + "';database='" + txbsqlname.Text.Trim() + "';user='" + txbname.Text.Trim() + "';pwd='" + txbpwd.Text.Trim() + "'";
                SqlConnection conn = new SqlConnection(strselect);
                try
                {
                    conn.Open();
                    StreamWriter sw = new StreamWriter("config.txt");//把设置保存到文本中
                    {
                        sw.WriteLine("server:'" + txbip.Text.Trim() + "';");
                        sw.WriteLine("database:'" + txbsqlname.Text.Trim() + "';");
                        sw.WriteLine("user:'" + txbname.Text.Trim() + "';");
                        sw.WriteLine("pwd:'" + txbpwd.Text.Trim() + "';");
                    }
                    sw.Close();
                    this.Close();
                    //MessageBox.Show("数据库连接成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("数据库连接失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }

}
}