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