I'm stuck in this problem. I need to buid a excel file from some info retreived from my database into my controller and just by calling the ActionResponse, this download the file, i been using gembox spreadsheet but run out of downloads pretty quickly, this is the logic of my controller:
public ActionResult Report()
{
IList MyClientList = new List();
DataBaseDataContext table = new DataBaseDataContext();
var query = from u in table.Subscriptions
where u.partnerid_mpn == Convert.ToInt32(id)
select u;
var list = query.ToList();
if (query.Count() > 0)
{
foreach (var item in list)
{
ClientNode node = new ClientNode();
node.Id = item.id_client;
node.Name = item.Name;
MyClientList.Add(node);
}
}
//create the file here based in the list and return it to user
return View();
}
Thanks to any answer. :)
