public DataSet GetOrderDetails(int PONum)
{
string IDS;
string queryStr = "SELECT ListOfProductID FROM PurchaseOrderItems WHERE PoID=@ID";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(queryStr, conn);
cmd.Parameters.AddWithValue("@ID", PONum);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
//Continue to read the resultsets row by row if not the end
dr.Read();
IDS = dr["ListOfProductID"].ToString();
conn.Close();
List <int> idlist = new List <int>();
foreach (var item in IDS.Split(','))
{
idlist.Add(int.Parse(item));
}
return(GetProductUsingID(idlist.ToArray()));
}
