Hi Guys - newbie here..
I have been working with OLEDB connection for the past few weeks and now have this connection in ADO and i'm not sure how to proceed.
The Connection information is the following:
private ADODB.Connection adoConn = new ADODB.Connection();
private ADODB.Recordset adoRS = new ADODB.Recordset();
and then...
public Form1()
{
InitializeComponent();
//Opens Line 50 Connection//
adoConn.Open("SageLine50v17", "Manager", "", 0);
adoRS = adoConn.OpenSchema(ADODB.SchemaEnum.adSchemaTables, null, System.Reflection.Missing.Value);
while (!(adoRS.EOF))
{
comboBox1.Items.Add(adoRS.Fields["TABLE_NAME"].Value.ToString());
adoRS.MoveNext();
}
adoRS.Close();
}
now currently this opens the Scheme for the Databse and populates the table names inside a drop-down combox.
What I was it to do is on connection fill a 'Datagridview' with the Table called 'Sales_Ledger'.
I'm a little confused on how to move forward on this due to the intelli-sense giving me differnt options to the OLEDB I have been using.
any help on this would be great! ^_^