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