Hi,
I am using Infragistics grid in MVC3. In the Infragistics grid i want a column to have a checkbox and this checkbox is checked based on the data from the database. Could you please guide me how to do with MVC3 razor.
thanks.
Hello Suresh A,
If you want to display checkboxes into the column then you can accomplish this through row template. Row template uses jQuery Templates (See http://api.jquery.com/category/plugins/templates/ ) and is enabled by setting "rowTemplate" and "jQueryTemplating" properties in igGrid.
Here is the example:
In Aspx:
[code]
@(Html.Infragistics().Grid(Model).ID("grid1").RowTemplate("<tr><td>${ProductID}</td><td>${Name}</td><td>${ProductNumber} </td><td><input type='checkbox' {{if IsAvailable}} checked='checked' {{/if}}></td><tr>")
.JQueryTemplating(true).Height("400").DataSourceUrl(Url.Action("PagingGetData")).DataBind().Render()
)
[/code]
In JS:
var exampleDataSource = [ {"ProductID": "1", "Name": "Product", "ProductNumber": "Art1", "IsAvailable": 1}];
$(window).load(function () {
$("#grid1").igGrid({
autoGenerateColumns: false,
rowTemplate: "<tr><td>${ProductID}</td><td>${Name}</td><td>${ProductNumber} </td><td><input type='checkbox' {{if IsAvailable}} checked='checked' {{/if}}></td><tr>",
columns: [
{headerText: "ProductID", key: "ProductID" },
{headerText: "Name", key: "Name" },
{headerText: "ProductNumber", key: "ProductNumber" },
{headerText: "IsAvailable", key: "IsAvailable" }
],
jQueryTemplating: true,
dataSource: exampleDataSource
});
You can see how to use row template in ASPX and Razor scenario in this sample:
https://www.igniteui.com/grid/overview
For igGridUpdating we don't have support for checkboxes right now. Available editors are listed in this help topic:
http://help.infragistics.com/Help/Doc/jQuery/2011.2/CLR4.0/html/igGrid_Updating.html
Hope this helps,
Martin Pavlov
Infragistics, Inc.
Thanks for your suggestion. Using rowtemplate am able to create the checkbox and set its status based on the field value. I need to make the checkbox in 2 rows of the grid to be mutually exclusive for which i need to know the status of the checkbox in the grid. Could you please provide me any sample code to read the status of the checkbox in Jquery IGgrid.Thanks.
Hi Suresh A,
Please feel free to contact us if you have any questions.