retrieve records in asp.net C# MVC2

Question

I want to retrieve some files using the contact id

here's my code.

    public string Edit(int id)
    {
        var GetContacts = from c in db.Contacts where c.ContactID == id
                        select c;

        return GetContacts.ToString();

    }

when I go to contacts/edit/1 for example. it displays this.

System.Data.Objects.ObjectQuery`1[ContactsMVC.Models.Contact]

what is wrong with my code? is it in the query. I actually want to get the name, mobile, and email of the user.

I am new to asp.net C# mvc 2 so bear with me.

thanks in advance.

var GetContacts returns IEnumerable<Contact> so assuming you want that, then your method should be public IEnumerable<Contact>Edit(int id) (all you currently doing is returning the ToString() value of IEnumerable<Contact>) — user3559349
– user3559349, Commented Sep 22, 2015 at 2:25
@StephenMuecke yes since I don't know how to get the name, mobile and etc. from the object.. — Sam Teng Wong
– Sam Teng Wong, Commented Sep 22, 2015 at 2:29
Your returning a collection of contacts (not one) so if you want the first one in the collection it needs to be var contact = (from c in db.Contacts where c.ContactID == id select c).FirstOrDefault(); and then you change the method to public Contact Edit(int id) (and access the properties of the model) — user3559349
– user3559349, Commented Sep 22, 2015 at 2:34
But since you seem to be wanting to navigate to a controller method, Then it needs to be public ActionResult Edit(int ID) { var contact = ...as above..; return View(contact); } — user3559349
– user3559349, Commented Sep 22, 2015 at 2:36

10K35H 5H4KY4 · Accepted Answer · 2015-09-22 02:41:45Z

1

Change your return type

public IEnumerable<Contacts> Edit(int id)
    {
        var GetContacts = from c in db.Contacts where c.ContactID == id
                        select c;

        return GetContacts.ToList();

    }

OR you can return as Json Object

 public ActionResult Edit(int id)
        {
            var GetContacts = from c in db.Contacts where c.ContactID == id
                            select c;

            return Json(GetContacts.ToList(), JsonRequestBehavior.AllowGet);
        }

Client Side - (for json one):

$.get("yourController/Edit",{id:yourid}, function(data){
   alert(data.Name); // For example
})

edited Sep 22, 2015 at 2:41

answered Sep 22, 2015 at 2:33

10K35H 5H4KY4

1,5265 gold badges22 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

retrieve records in asp.net C# MVC2

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related