public string[][] GetPortfolioIDAndRunID(string accountname)
{
OleDbConnection conn = new OleDbConnection(_oledbConnectionString);
conn.Open();
string sql = "select b.PortfolioID,b.RunID from Portfolios a left join Transactions b on a.PortfolioID = b.PortfolioID where "
+ "a.AccountName = '" + accountname +"' and b.RunID is not null group by b.PortfolioID,b.RunID order by b.RunID";
OleDbDataAdapter oledbDataAdapter = new OleDbDataAdapter(sql, conn);
DataTable dataTable = new DataTable();
oledbDataAdapter.Fill(dataTable);
string[][] strID = null;
if (dataTable.Rows.Count > 0)
{
strID = new string[dataTable.Rows.Count][];
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dataRow = dataTable.Rows[i];
strID[i] = new string[2];
if (dataRow["PortfolioID"] != System.DBNull.Value)
{
strID[i][0] = dataRow["PortfolioID"].ToString();
}
if (dataRow["RunID"] != System.DBNull.Value)
{
strID[i][1] = dataRow["RunID"].ToString();
}
}
}
dataTable.Clear();
dataTable.Dispose();
conn.Close();
conn.Dispose();
return strID;
}