delete a row from database using kendo MVC

Question

Hi How to insert a image column in kendo grid view. I am using MVC 5 with kendo. I need to delete a row from gridview and database using delete image link. Thanks.

Gowtham Rajamanickam · Answer

public ActionResult ViewChangeLogs([DataSourceRequest] DataSourceRequest request) { List results = // whatever you do to get the items return Json(results.ToDataSourceResult(request)); // this does the paging }

neel k · Answer

ok thank you.

Guest User · Answer

Am not sure. I have exactly this in front of me, and it's working. Perhaps we have a different version of Kendo. I really can't say without seeing your project. Even if you posted it here, I have the rest of my evening filled with meetings. Do check the Kendo forum, a lot of issues are answered there, although you'll need to search thoroughly sometimes to find the answer.

neel k · Answer

I already try Json but same thing happens previously so that I did not use Json. anyway thanks for your help. if possible please answer how to solve this issue. I need to submit my task today

Guest User · Answer

Hmz, the grid should take care of that, perhaps a setting. I suggest you check the Kendo forum, as I am out of time for today.

neel k · Answer

in the final result I got one message. Do you want to open or save 2.json(876 bytes) from localhost?

Guest User · Answer

return Json(users.ToDataSourceResult(request), JsonRequestBehavior.AllowGet );

neel k · Answer

where I need to write that line in my code.

Guest User · Answer

That tells you exactly what you should do. Add JsonRequestBehavior.AllowGet as a parameter to the Json() method.

neel k · Answer

I got an error when I change IQuerable to List. This request has been blocked because sensitive information could be disclosed to third party web sites when this is used in a GET request. To allow GET requests, set JsonRequestBehavior to AllowGet.

Guest User · Answer

Change IQueryable to a List.

neel k · Answer

Here is my controller code for above view code. public ActionResult ManageUsers([DataSourceRequest]DataSourceRequest request, external_applications application, string appname) { TempData["AppID"] = application.id; TempData["AppName"] = appname; IQueryable users = (from c in db.SP_ManageUsers() where c.appid == application.id select c).AsQueryable(); //return View(users.ToList()); return Json(users.ToDataSourceResult(request)); } I got an error "The result of a query cannot be enumerated more than once."

Guest User · Answer

You can page server-side, but then you need to adjust something to this controller action: .Read(read => read.Action("ViewChangeLogs", "ExternalApplications")) It would need to look something like this: public ActionResult ViewChangeLogs([DataSourceRequest] DataSourceRequest request) { List results = // whatever you do to get the items return Json(results.ToDataSourceResult(request)); // this does the paging }

neel k · Answer

when I change ServerOpeationis true pageable is not working, when I click the 2nd page button data is not showing.

Guest User · Answer

.ServerOperation(false) prevents this. If you want it to go to the controller, set it to true.

neel k · Answer

now image is showing correctly. when I lick the image it is not going to the controller.

Guest User · Answer

You really need to check with a browser developer tool. With that you can see if the image is being downloaded or if it's not even there. The view adds no new information. Have you tried prefixing Content with a forward slash?

neel k · Answer

Here is my view code @(Html.Kendo().Grid(Model) .Name("grid") .Columns(columns => { columns.Bound(c => c.ad_user_id).Title("User").Groupable(false).HeaderHtmlAttributes(new { style = "font-size:18pt;" }); columns.Bound(c => c.title).Title("Title Description").HeaderHtmlAttributes(new { style = "font-size:18pt;" }); columns.Bound(c => c.date_created).ClientTemplate("#= kendo.toString(date_created,\"MM/dd/yyyy hh:mm:ss tt\") #").Title("Created Date").HeaderHtmlAttributes(new { style = "font-size:18pt;" }); columns.Template(@ ).ClientTemplate(@" "); .HtmlAttributes(new { style = "height: 380px;" }) .Scrollable() .Groupable() .Filterable() .Sortable(sortable => sortable.AllowUnsort(true).SortMode(GridSortMode.MultipleColumn)) .Pageable(pageable => pageable .PageSizes(true) .ButtonCount(5)) .Resizable(resize => resize.Columns(true)) .DataSource(dataSource => dataSource .Ajax() .ServerOperation(false) .PageSize(20) .Batch(true) .Model(model => model.Id(p => p.ad_user_id)) .Destroy(delete => delete.Action("Remove", "ExternalApplications")) .Read(read => read.Action("ViewChangeLogs", "ExternalApplications")) ) )

Guest User · Answer

Then use your browser's developer tools to find out more. Can only guess without access to the website.

neel k · Answer

yes

Guest User · Answer

Have you tried an absolute path to your image? Is it copied to the right place when you build?

neel k · Answer

Here is my image code. columns.Template(@ ).ClientTemplate(@" "); Can you please give me the controller code for row delete operation.

Guest User · Answer

I don't know what could be wrong with your image. Using the class k-grid-delete triggers the delete command from the grid. I assumed you already had those events connected. This is what you would need to add: .DataSource(dataSource => dataSource .Ajax() .Model(model => model.Id(item => item.Id)) .PageSize(20) .ServerOperation(true) .Destroy(update => update.Action("YourControllerDeleteAction", "YourController")) ) Controller code would have: public ActionResult YourControllerDeleteAction ([DataSourceRequest] DataSourceRequest request, ViewModel viewModel) { // here you can use viewModel.Id to delete your record }

neel k · Answer

Thanks for your reply. image is not displaying correctly. it is showing small black color box. href='\#' what should I use in place of #. is there any code in controller.

Guest User · Answer

You can use something like this: @(Html.Kendo().Grid () .Name("grid") .Columns(columns => { columns.Template(@ ).ClientTemplate(@" "); }) )