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);
}
}
}
}
}