how to convert the int value into string to show in grid in asp.net mvc

Question

i have tried the following code and it is giving error

var res = (from results in db.JobSearchAgents
                        where results.SiteID == 110 && results.UserID == sess
                        select new Agentlist
                        {
                            JobSearchAgentID = results.JobSearchAgentID.ToString(),

                            EmailAddress = results.EmailAddress,
                            Keywords = results.Keywords,


                            Country = results.Country,
                            zipcode = results.ZipCode,
                            miles = results.Miles.ToString()


                        }).AsEnumerable();
             ViewData["ajax"] = true;
             ViewData["scrolling"] = true;
             ViewData["paging"] = true;
             ViewData["filtering"] = true;
             ViewData["grouping"] = true;
             ViewData["sorting"] = true;
             ViewData["showFooter"] = true;
             //ViewData["searchresults"] = res;

            return View(res);


<%using (Html.BeginForm())
       {%>
       <%=Html.Telerik().Grid(Model).Name("Grid").Columns(columns=>
    {
        columns.Bound(m=>m.Keywords);
        columns.Bound(m=>m.Country);
    }).DataBinding(databinding=>
        {
            databinding.Server().Select("Agentlist","Grid",new
            {
           ajax=ViewData["ajax"]
            });
             databinding.Ajax().Select("Agentlist",
                "Grid").Enabled((bool)ViewData["ajax"]);
        })
        .Scrollable(scrolling => scrolling.Enabled((bool)ViewData["scrolling"]))
        .Sortable(sorting => sorting.Enabled((bool)ViewData["sorting"]))
        .Pageable(paging => paging.Enabled((bool)ViewData["paging"]))
        .Filterable(filtering => filtering.Enabled((bool)ViewData["filtering"]))
        .Groupable(grouping => grouping.Enabled((bool)ViewData["grouping"]))
        .Footer((bool)ViewData["showFooter"])


           %>
      <%}%>

It is giving error. OK, does this error come with an error message or something? — Darin Dimitrov
– Darin Dimitrov, Commented May 27, 2011 at 10:24
linq to entities doesnot recognizes the methos system.string.tostring() — iProgrammer
– iProgrammer, Commented May 27, 2011 at 10:28

Muhammad Adeel Zahid · Accepted Answer · 2011-05-27 10:38:38Z

1

The Error is because your query is trying to execute ToString method in db. using AsEnumerable you can tell the query to execute your methods in c#. you can either change your query to

var res = (from results in db.JobSearchAgents
                        where results.SiteID == 110 && results.UserID == sess
                        select result).AsEnumerable().Select(result=>new Agentlist
                        {
                            JobSearchAgentID = results.JobSearchAgentID.ToString(),

                            EmailAddress = results.EmailAddress,
                            Keywords = results.Keywords,


                            Country = results.Country,
                            zipcode = results.ZipCode,
                           miles = results.Miles.ToString()

                        });

Or you can bind your columns to telerik grid without calling ToString method. Telerik grid does not require the data to be in string format. Moreover, if you want data to be displayed in specific format you can call Format method when binding to the grid

columns.Bound(m=>m.Keywords).Foramt("format string");

answered May 27, 2011 at 10:38

Muhammad Adeel Zahid

17.8k16 gold badges95 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Muhammad Adeel Zahid Over a year ago

By all means. Telerik grid comes with functionality of CRUD. for more info visit demos.telerik.com/aspnet-mvc/grid?theme=vista

Collectives™ on Stack Overflow

how to convert the int value into string to show in grid in asp.net mvc

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related