private void LoadSourceData()
{
try
{
_dataSet = new NtfcDataSet();
using (OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Users\\genpetrp\\Projects\\NTXFC\\public_html\\Data\\ntfc.mdb;User ID=Admin;Password="******"SELECT * From {0}";
OleDbCommand cmd = new OleDbCommand("", cn);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
foreach (DataTable table in _dataSet.Tables)
{
string tableName = table.TableName;
adapter.SelectCommand.CommandText = String.Format(selectFormat, tableName);
adapter.Fill(_dataSet, tableName);
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
private void LoadSourceData()
{
try
{
_dataSet = new NtfcDataSet();
using (OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Users\\genpetrp\\Projects\\NTXFC\\public_html\\Data\\ntfc.mdb;User ID=Admin;Password="******"SELECT * From {0}";
OleDbCommand cmd = new OleDbCommand("", cn);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
foreach (DataTable table in _dataSet.Tables)
{
string tableName = table.TableName;
adapter.SelectCommand.CommandText = String.Format(selectFormat, tableName);
adapter.Fill(_dataSet, tableName);
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}
