Show data in Grid from returned model

» chash » Show data in Grid from returned model

By : user3100692

Date : January 12 2021, 09:11 PM

should help you out In short yes the same name is going to cause issues. Instead:
1 - Create a dedicated class that represents the grid data

code :

public class PersonCar
{
    public int PersonId { get; set; }

    public string PersonName { get; set; }

    public int CarId { get; set; }

    public string CarName { get; set; }
}

public ActionResult Index()
{
    var mainModel = context.Person.Join(context.Car, p => p.personID, c => c.IdPerson, (p, c) => new PersonCar { PersonId = p.personID, PersonName = p.Name, CarId = c.carID, CarName = c.Name }).ToList();
    return View(mainModel);
}

@model IEnumerable<CarSln.Models.PersonCar>
@{
    ViewBag.Title = "Home Page";
}
<div class="row">
        @(Html.Grid(Model).Build(columns =>
            {
               columns.Bound(x => x.PersonId);               
               columns.Bound(x => x.PersonName);               
               columns.Bound(x => x.CarId);               
               columns.Bound(x => x.CarName);               
             })
         )
</div>

Share :

JQuery grid doesn't show data - show empty grid

By : user3107206

Date : March 29 2020, 07:55 AM

help you fix your problem JQgrid is awesome! But the documentation is not very well...
In your case the problem is the Json data... If you look here in the JSON DATA part then you realize that the Json you're trying to use in not valid for JQGrid...

code :

{ 
  "total": "xxx", 
  "page": "yyy", 
  "records": "zzz",
  "rows" : [
    {"id" :"1", "cell" :["cell11", "cell12", "cell13"]},
    {"id" :"2", "cell":["cell21", "cell22", "cell23"]},
      ...
  ]
}

How to show "parent data" of model on Grid?

By : Andoo_pls

Date : March 29 2020, 07:55 AM

With these it helps Override column.renderer , and return record.getParent().get('someData');
http://docs.sencha.com/ext-js/4-1/#!/api/Ext.grid.column.Column-cfg-renderer

code :

renderer: function(value, metadata, record, rowIndex, colIndex, store, view){
  return record.getMarca().get('nombre');
}

Show Another Model Data in Admin Grid Magento

By : Samrat S

Date : March 29 2020, 07:55 AM

wish helps you If your extension uses a grid that extends Mage_Adminhtml_Block_Widget_Grid, you can modify the _prepareCollection() function to include data from other source (via joins). Also you will have to add new columns to the grid, which can be done in function __prepareColumns().
For an example look at the grid block of the Mage_Newsletter module Mage_Adminhtml_Block_Newsletter_Subscriber_Grid

How to show sql queue results on data grid based on selected rows of another data grid on VS2012

By : Tai Nguyen

Date : March 29 2020, 07:55 AM

I wish did fix the issue. First, your query is susceptible to sql injection. That aside, you might want to check what is the actual query that is getting created here, if at all:

code :

SqlCommand(@"SELECT Title, Author FROM Books INNER JOIN Borrow ON Borrow.BookID = Books.BookID WHERE Borrow.StudID = '"+dataGridView2.SelectedRows[0].Cells[0].Value.ToString()+"';");

string qryString = @"SELECT Title, Author FROM Books INNER JOIN Borrow ON Borrow.BookID = Books.BookID WHERE Borrow.StudID = '"+dataGridView2.SelectedRows[0].Cells[0].Value.ToString()+"';"

SqlCommand(qryString);

public void loadGrid1()
{
    con.Open();
    cmd = new SqlCommand(@"SELECT StudID, Stud_Lname, Stud_Fname FROM STUDENTS;",con);
    rdr = cmd.ExecuteReader();
    while (rdr.Read())
    {
        dataGridView2.Rows.Add(rdr[0].ToString(), rdr[1].ToString(), rdr[2].ToString());
    }

    // check if dataGridView2 has more than 0 rows
    // and then select the first row by default
    if(dataGridView2.Rows.Count > 0)
    {
        dataGridView2.Rows[0].Selected = true
    }
    con.Close();
}

Mvc Kendo grid - Doesn't show any data that returned from controller

By : fbohz

Date : March 29 2020, 07:55 AM

I think the issue was by ths following , The problem is that you are not saying where in the returned data is actually the array with the data.
Your model definition should be:

code :

    schema: {
        data: "Data",
        model: {
            ID: "ID",
            fields: {
                ID: { 
                    editable: false, 
                    nullable: true
                },
                DESCRIPTION: { 
                    validation: { required: true }
                }                    
            }
        }
    }