static void Main(string[] args) { OBConnection OBConn = new OBConnection("Triumph", "Data Source=10.209.41.166:1521/TRIUMP;User ID=viewer;Password=cprt_hsi;Unicode=True"); System.Data.DataSet results = OBConn.Query("Select username From hsi.useraccount"); System.Data.DataTable resultTable = results.Tables[0]; for (System.Int32 x = 0; x < resultTable.Rows.Count; x++) { for (System.Int32 y = 0; y < resultTable.Columns.Count; y++) { Console.WriteLine(resultTable.Rows[x][y]); } } Console.ReadLine(); }
private void connectToolStripMenuItem_Click(object sender, EventArgs e) { Connect connForm = Connect.GetChildInstance(); if (connForm.ShowDialog(this) == DialogResult.OK) { this.DocListChkLst.Items.Clear(); this.connector = new OBConnection(connForm.ConnName, connForm.ConnString); this.ConnStatusLbl.Text = "Connection Name: " + connForm.ConnName; String queryString = "select itemtypenum, trim(itemtypename) from hsi.doctype where itemtypenum in (select itemtypenum from hsi.scanqueuexit) and itemtypegroupnum > 100 order by itemtypename"; Type[] typeAr = { Type.GetType("System.Int32"), Type.GetType("System.String") }; System.Data.DataSet DocumentTypes = this.connector.Query(queryString, typeAr); System.Data.DataTable DocTypeTable = DocumentTypes.Tables[0]; for (Int32 x = 0; x < DocTypeTable.Rows.Count; x++) { CheckedListBoxItem clbItem = new CheckedListBoxItem((System.String)DocTypeTable.Rows[x][1], System.Decimal.ToInt32((System.Decimal)DocTypeTable.Rows[x][0])); DocListChkLst.Items.Add(clbItem); } } }