private void button1_Click(object sender, System.EventArgs e)
{
try
{
System.Collections.Specialized.StringCollection databases = new System.Collections.Specialized.StringCollection();
databases.Add("SEMPRA.DEV");
databases.Add("SEMPRA.STAGE");
Sempra.Login oracleLogin = new Sempra.Login(
true,
5,
"H:\\VS2003Projects\\SempraOpsDevLib\\Login",
"\\\\stdev2\\dev\\OpsDev\\XMLSchemas\\",
databases);
if (oracleLogin.Execute(oracleConnection))
{
label1.Text = "Login Successful";
oracleDataAdapter = new System.Data.OracleClient.OracleDataAdapter(
"select * from dept", oracleConnection);
DataSet dataSet = new DataSet();
oracleDataAdapter.Fill(dataSet);
gridData.BeginUpdate();
gridData.DataSource = dataSet;
gridData.DataMember = "Table";
gridData.EndUpdate();
}
else
{
label1.Text = "Login Failed";
}
}
catch (Exception error)
{
MessageBox.Show(error.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, System.EventArgs e)
{
try
{
System.Collections.Specialized.StringCollection databases = new System.Collections.Specialized.StringCollection();
databases.Add( "SEMPRA.DEV" );
databases.Add( "SEMPRA.STAGE" );
Sempra.Login oracleLogin = new Sempra.Login(
true,
5,
"H:\\VS2003Projects\\SempraOpsDevLib\\Login",
"\\\\stdev2\\dev\\OpsDev\\XMLSchemas\\",
databases );
if ( oracleLogin.Execute( oracleConnection ) )
{
label1.Text = "Login Successful";
oracleDataAdapter = new System.Data.OracleClient.OracleDataAdapter(
"select * from dept", oracleConnection );
DataSet dataSet = new DataSet();
oracleDataAdapter.Fill( dataSet );
gridData.BeginUpdate();
gridData.DataSource = dataSet;
gridData.DataMember = "Table";
gridData.EndUpdate();
}
else
label1.Text = "Login Failed";
}
catch( Exception error )
{
MessageBox.Show( error.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error );
}
}
