Merge multiple string values into single list of values

can be achieved easily with simple cross join, meaning a hooded shirt can be of any size and any given color so total combination is n*n*n

public ActionResult abc()
{
List shirtTypes= new List(){"Hooded Shirts","Oxford Shirts","Casual Shirts","Smart Shirts","Checked Shirts"};
List sizes= new List(){"XXS","XS","S","M","L","XL","XXL"};
List colors = new List() { "Black", "Blue", "Brown", "Cream", "Green", "Grey", "Orange", "Pink", "Purple", "Red", "Stone", "White", "Yellow" };
var res = (from a in shirtTypes
from b in sizes
from c in colors
select new Custome
{
shirtType = a,
size = b,
color = c
}).ToList();
return View(res);
}

public class Custome
{
public string shirtType { get; set; }
public string size { get; set; }
public string color { get; set; }
}

@model IEnumerable
@{
Layout = null;
}
"viewport" content="width=device-width" />
abc
@Html.ActionLink("Create New", "Create")
class="table">
@Html.DisplayNameFor(model => model.shirtType)
@Html.DisplayNameFor(model => model.size)
@Html.DisplayNameFor(model => model.color)
@foreach (var item in Model) {
@Html.DisplayFor(modelItem => item.shirtType)
@Html.DisplayFor(modelItem => item.size)
@Html.DisplayFor(modelItem => item.color)
@Html.ActionLink("Edit", "Edit", new { /* id=item.PrimaryKey */ }) |
@Html.ActionLink("Details", "Details", new { /* id=item.PrimaryKey */ }) |
@Html.ActionLink("Delete", "Delete", new { /* id=item.PrimaryKey */ })
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
can be achieved easily with simple cross join, meaning a hooded shirt can be of any size and any given color so total combination is n*n*n
public ActionResult abc()
       {
           List shirtTypes= new List(){"Hooded Shirts","Oxford Shirts","Casual Shirts","Smart Shirts","Checked Shirts"};
           List sizes= new List(){"XXS","XS","S","M","L","XL","XXL"};
           List colors = new List() { "Black", "Blue", "Brown", "Cream", "Green", "Grey", "Orange", "Pink", "Purple", "Red", "Stone", "White", "Yellow" };
           var res = (from a in shirtTypes
                     from b in sizes
                     from c in colors
                      select new Custome
                     {
                         shirtType = a,
                         size = b,
                         color = c
                     }).ToList();

           return View(res);
       }
public class Custome
    {
       public string shirtType { get; set; }
       public string size { get; set; }
       public string color { get; set; }
    }
@model IEnumerable

@{
    Layout = null;
}





    "viewport" content="width=device-width" />
    abc




        @Html.ActionLink("Create New", "Create")


    class="table">


                @Html.DisplayNameFor(model => model.shirtType)


                @Html.DisplayNameFor(model => model.size)


                @Html.DisplayNameFor(model => model.color)




    @foreach (var item in Model) {


                @Html.DisplayFor(modelItem => item.shirtType)


                @Html.DisplayFor(modelItem => item.size)


                @Html.DisplayFor(modelItem => item.color)


                @Html.ActionLink("Edit", "Edit", new { /* id=item.PrimaryKey */ }) |
                @Html.ActionLink("Details", "Details", new { /* id=item.PrimaryKey */ }) |
                @Html.ActionLink("Delete", "Delete", new { /* id=item.PrimaryKey */ })


    }
+1
peter5y ago
Thats good. Although i require unique column values to display once only!
I know the relation by the extra ID column values,so i dont require a print out of all combinations when there could be a vast list.

Thanks
0