ASP.NET

priyaahh wrote:

If any of the table is not having row, then I am getting no records in my resultant cartesian product table.

public static class DataTableExtensions
{
    public static IEnumerable<DataRow> AsEnumerableNotEmpty(this DataTable table)
    {
        if (table == null) throw new ArgumentNullException("table");
        if (table.Rows.Count != 0) return table.Rows.Cast<DataRow>();
        return new[] { table.NewRow() };
    }
}

var newDatatable = from TowerName in dtTower.AsEnumerableNotEmpty()
                   from CountryName in dtCountry.AsEnumerableNotEmpty()
                   from Level in dtLevel.AsEnumerableNotEmpty()
                   from CityName in dtCity.AsEnumerableNotEmpty()
                   from BandName in dtBand.AsEnumerableNotEmpty()
                   from EType in dtEmploymentType.AsEnumerableNotEmpty()
                   from Skill in dtSkill.AsEnumerableNotEmpty()
                   select new { TowerName, CountryName, Level, CityName, BandName, EType, Skill };

System.Drawing.Bitmap bitmap = ...;
string filename = ...;
bitmap.Save(filename,  System.Drawing.Imaging.ImageFormat.Png);