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(); }
public void Remove(OBConnection item) { this.InnerList.Remove(item); }
public int Add(System.String inputName, System.String inputConnection) { OBConnection inputOBCon = new OBConnection(inputName, inputConnection); return(this.Add(inputOBCon)); }
public int Add(OBConnection item) { return(this.List.Add(item)); }
public int IndexOf(OBConnection item) { return(base.List.IndexOf(item)); }
public void Insert(int index, OBConnection item) { this.List.Insert(index, item); }
public bool Contains(OBConnection item) { return(this.List.Contains(item)); }
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); } } }
public int Add(OBConnection item) { return this.List.Add(item); }
public int IndexOf(OBConnection item) { return base.List.IndexOf(item); }
public bool Contains(OBConnection item) { return this.List.Contains(item); }
public void AddRange(OBConnection[] collection) { this.AddRange(collection); }
public int Add(System.String inputName, System.String inputConnection) { OBConnection inputOBCon = new OBConnection(inputName, inputConnection); return this.Add(inputOBCon); }