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 void Remove(OBConnection item)
{
this.InnerList.Remove(item);
}
public int Add(OBConnection item)
{
return this.List.Add(item);
}
public void Insert(int index, OBConnection item)
{
this.List.Insert(index, 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);
}
