Display data horizontally in vertically issue in public method in mvc

Question

I have a public get set list method in model class

public List<clsTradeBook> LSTList { get; set; }

I want to add data here which I am getting from database and that data showing horizontally in table, but I want to display in vertically in 3 columns like this:

      colns    Date           | Sale | Buy
               01/02/2021 0:00   0     05.6
               01/02/2021 1:00   0     15.6
               01/02/2021 2:00   0     20.6

Right now I'm adding data in List<string> ls = new List<string>(); and it display data like this 01/02/2021 0:00, 0, 05.6 in a list but I want to add data like above in

public List<clsTradeBook> LSTList { get; set; }

Here is some code in which data is adding in list view but I want in LSTList

So I need code for it so I can add it directly

public List<clsTradeBook> LSTList { get; set; }

Does anyone have an idea, then please share it with me with sample.

List<string> ls = new List<string>();
int i = 0;

for (i = 0; i < 24; i++)
{
    if (i == 0)
    {
        ls.Add(date + " " + i + ":00:00" + "," + string.Format("{0:0.00}", obj.LSTList24[0].decHH1) + ",0");
    }
    else if (i == 1)
    {
        ls.Add(date + " " + i + ":00:00" + "," + string.Format("{0:0.00}", obj.LSTList24[0].decHH2) + ",0");
    }
    else if (i == 2)
    {
        ls.Add(date + " " + i + ":00:00" + "," + string.Format("{0:0.00}", obj.LSTList24[0].decHH3) + ",0");
    }
}

clss.LSTList  = ls;

Regards

Sachin Singh · Answer

The problem is, you have used the List which flattened your data, you need to split it into chunks of 3 and then you can easily loop through it. var res= ls .Select((x, i) => new { Index = i, Value = x }) .GroupBy(x => x.Index / 3) .Select(x => x.Select(v => v.Value).ToList()) .ToList(); now loop through the "res" foreach(var grp in res) { foreach(string str in grp) { @str } }

Sachin Singh · Answer

it will be exactly the same public ActionResult Index() { // ls is yr list of string var res= ls .Select((x, i) => new { Index = i, Value = x }) .GroupBy(x => x.Index / 3) .Select(x => x.Select(v => v.Value).ToList()) .ToList(); claa.LSTList=res; return view(clss); } Date Sale Buy foreach(var grp in res) { foreach(string str in grp) { @str } }

Bikramjeet Singh · Answer

want to finsh in rozer page side im doing this so and show restls as above i told need to fix this one code in page side @ if (Model.LSTList != null && Model.LSTList.Count > 0) { List string > ls = new List string >(); int i = 0; DateTime dtDate = Convert.ToDateTime(Model.LSTList24[0].dtDate); string date = dtDate.ToString( "dd/MM/yyyy hh:mm:ss" ); for (i = 0; i { if (i == 0) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH1) + ",0" ); } else if (i == 1) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH2) + ",0" ); } else if (i == 2) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH3) + ",0" ); } else if (i == 3) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH4) + ",0" ); } else if (i == 4) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH5) + ",0" ); } else if (i == 5) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH6) + ",0" ); } else if (i == 6) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH7) + ",0" ); } else if (i == 7) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH8) + ",0" ); } else if (i == 8) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH9) + ",0" ); } else if (i == 9) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH10) + ",0" ); } else if (i == 10) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH11) + ",0" ); } else if (i == 11) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH12) + ",0" ); } else if (i == 12) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH13) + ",0" ); } else if (i == 13) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH14) + ",0" ); } else if (i == 14) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH15) + ",0" ); } else if (i == 15) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH16) + ",0" ); } else if (i == 16) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH17) + ",0" ); } else if (i == 17) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH18) + ",0" ); } else if (i == 18) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH19) + ",0" ); } else if (i == 19) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH20) + ",0" ); } else if (i == 20) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH21) + ",0" ); } else if (i == 21) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH22) + ",0" ); } else if (i == 22) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH23) + ",0" ); } else if (i == 23) { ls.Add(date + " " + i + ":00:00" + "," + string .Format( "{0:0.00}" , Model.LSTList24[0].decHH24) + ",0" ); } } var res = ls .Select((x, l) => new { Index = l, Value = x }) .GroupBy(x => x.Index / 3) .Select(x => x.Select(v => v.Value).ToList()) .ToList(); foreach (var grp in res) { foreach ( string str in grp) { string [] procol = str.ToString().Split( ',' ); @ for ( int v = 0; v { string [] Date = procol[0].Split( ',' ); string [] Buy = procol[1].Split( ',' ); string [] Sell = procol[2].Split( ',' ); } } }

Bikramjeet Singh · Answer

how to split it for table in mvc? in foreach lop