using Oracle.DataAccess.Client; internal void Main() { //CREATE QUERY string sql = BuildSQL(); //CREATE A SQL COMMAND OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sql; OracleConnection conn = new OracleConnection(); try { //OPEN THE CONNECTION conn.ConnectionString = "Data Source=<network alias>;User Id={0};Password={1}"; conn.Open(); //ASSIGN THE CONNECTION TO THE COMMAND cmd.Connection = conn; //SET THE DATA ADAPTER FOR THE COMMAND AND FILL A DATASET OracleDataAdapter da = new OracleDataAdapter(cmd); Dataset _dataset = new DataSet(); da.Fill(_dataset); //DO SOMETHING WITH THE DATASET } catch (OracleException ex) // Catch Oracle errors { switch (ex.Number) { case 12545: MessageBox.Show(@The database is unavailable); break; case 1017: MessageBox.Show(@ORA-1017: + Environment.NewLine + @Invalid username/password; logon denied); break; case 01013: MessageBox.Show(@Query cancelled by user.); break; default: MessageBox.Show(@Database error: + ex.Message); break; } } catch (Exception ex) { MessageBox.Show(ex.ToString); } finally { //CLEAN UP conn.Close(); conn.Dispose(); }
internal bool VerifyOracleClient() { try { Assembly.Load("Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342"); return true; } catch (Exception) { MessageBox.Show(@Your computer must have Oracle Client installed in order to use this application. + Environment.NewLine + @Click OK to exit., @My Add-In); return false; } }
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
