110,533
社区成员
发帖
与我相关
我的任务
分享
private void buttonConnect_Click(object sender, System.EventArgs e)
{
// obtain the connection information specified
String host = textBoxHost.Text;
String port = textBoxPort.Text;
String user = textBoxUser.Text;
String pass = textBoxPass.Text;
// build a connect string
string connStr = "Data Source=\'" + host + "\';Port=\'" + port + "\';UID=" + user + ";PWD=\'" + pass + "\';Database=\'pubs2\';";
_conn = new AseConnection( connStr );
// if tracing has been enabled, setup tracing
if(checkTrace.Checked)
{
// create the trace file
_fs = new FileStream("trace.log", FileMode.Create, FileAccess.Write);
_strmWriter = new StreamWriter(_fs);
_strmWriter.WriteLine("************ Sybase ASE ADO.NET Data Provider Trace start ****************");
indentLevel = 0;
// register the trace event handlers
_conn.TraceEnter += new TraceEnterEventHandler(TraceEnter);
_conn.TraceExit += new TraceExitEventHandler(TraceExit);
}
try
{
_conn.Open();
Setup();
buttonExecute.Enabled = true;
buttonConnect.Enabled = false;
}
catch (AseException ex)
{
MessageBox.Show(ex.Source + " : " + ex.Message + " (" + ex.ToString() + ")", "Failed to connect");
}
}
private void Setup()
{
//setup
try
{
AseCommand dropCmd = new AseCommand(strDropProc, _conn);
dropCmd.ExecuteNonQuery();
}
catch(AseException)
{
//If the proc does not exist we expect this exception
}
AseCommand createCmd = new AseCommand(strCreateProc, _conn);
createCmd.ExecuteNonQuery();
}