private void btnSaveConnect_Click(object sender, EventArgs e)
{
try
{
if (this.IsNull() == true)
{
return;
}
string connectstring = "provider=Microsoft.jet.OLEDB.4.0;Data Source=accountsystem.mdb;Jet OleDb:Database Password=lxw618";
string sqlcommand = "update [Set] set [connect]='Data Source=" + txtServer.Text + "\\" + txtCase.Text + ";Initial Catalog=" + txtDatabase.Text + ";User ID=" + txtUsername.Text + ";Password="******"'";
string sqlcommand2 = "update [Set] set [server]='" + txtServer.Text + "',[case]='" + txtCase.Text + "',[database]='" + txtDatabase.Text + "',[user]='" + txtUsername.Text + "',[password]='" + txtPassword.Text + "'";
OleDbConnection aConnection = new OleDbConnection(connectstring);
aConnection.Open();
OleDbCommand aCommand = new OleDbCommand(sqlcommand, aConnection);
aCommand.ExecuteNonQuery();
OleDbCommand aCommand2 = new OleDbCommand(sqlcommand2, aConnection);
aCommand2.ExecuteNonQuery();
MessageBox.Show("保存成功", "恭喜");
aConnection.Close();
this.Close();
fSC = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统错误");
}
}
private void btnSet_Click(object sender, EventArgs e)
{
if (SetConnect.fSC == null)
{
SetConnect setconnect = new SetConnect();
setconnect.Show();
}
else
{
SetConnect.fSC.Activate();
}
}
public SetConnect()
{
InitializeComponent();
fSC = this;
}
private void picClose_MouseClick(object sender, MouseEventArgs e)
{
this.Close();
fSC = null;
}
