Comments by Elvally Boubacar (Top 21 by date)

now i getting this error



System.Web.Mvc.WebViewPage<tmodel>.Model.get retournée null.


in @foreach (DataColumn col in Model.Columns) on my view

yeah i already used datatable but i met an error like my model getting null
on below my view with datatable

@using System.Data
@model DataTable


@foreach (DataColumn col in Model.Columns)
{
}

@foreach (DataRow row in Model.Rows)
{
@foreach (DataColumn col in Model.Columns)
{
}
}
@col.ColumnName@row[col.ColumnName]

sorry a have a time
so i don't understand how can i use that can you explain more please

hi thanks for your answer but i have a dynamic model and i want to display data on mvc view
i tried code in below but nothing


@model List<Dictionary<string, object>>
@{
ViewBag.Title = "DynamicIndex";
Layout = "~/Views/Shared/_Layout.cshtml";
}
@for (int i = 0; i < objDataColumn.Count; i++)
{

dt.Columns.Add(objDataColumn[i].ToString());
}

@for (int i = 0; i < d.Count; i++)
{
DataRow dr = dt.NewRow();
List<string>
tempList = new List<string>
();
var res = d[i].subject.ToList();
@for (int j = 0; j < res.Count; j++)
{
tempList.Add(res[j].Value.ToString());
}
int k = 0;
@ foreach (var v in tempList)
{
k++;
}
dt.Rows.Add(dr);
// dt.Rows.Add(tempList.ToArray<string>
());
}
tempList.Add(d[i].Planner.ToString()); tempList.Add(d[i].Vendor_Location.ToString()); tempList.Add(d[i].Bulk_Material.ToString()); dr[k] = v.toString();

thanks for your replay
now i ask how i can dispaly this on view

can i using dynamic datatable on view with foreach to get this pivot?

c#

my question:
i have a table with a dynamic column (Week) and I want to display it by pivoting this column dynamically on a mvc view

this is my source data who i want pivot https://drive.google.com/file/d/1NM6ZvPfTN96oHicEnI26zEU9clrRwfai/view?usp=sharing

i put it on google drive

yeh im using datatable
my view must return something as

https://drive.google.com/file/d/1dxpXch3LaM3ArKyAX-FpfGsN9WyWwPhX/view?usp=sharing

the model is for a dynamic pivot table. in below

namespace YMOReporting.Models
{
using System;
using System.Collections.Generic;
using System.Data;

public partial class Proc1_Result
{
public string Planner { get; set; }
public string Vendor_Location { get; set; }
public string Bulk_Material { get; set; }
public Nullable<double> Value { get; set; }
public string Week { get; set; }
}
}

in the first foreach exactly in Model.Columns

Hi thanks Sir for your a proposition but my stored return null (it return : NullReferenceException) so i can't show the result in my view