Return in json from stored procedure in MVC web api

Question

public class VersionController : ApiController
{
    [HttpGet]
    public List<AutoCompleteCompany> acCompany(string term)
    {
        DataSet ds = new DataSet();
        List<AutoCompleteCompany> co= new List<AutoCompleteCompany>();

        try
        {
            ds = getdetails(term);//privae method returns dataset
            co = ds.Tables[0].ToList<AutoCompleteCompany>();
        }
        catch (Exception ex)
        { 
        }

        return co;
    }
}

Properties below

public class AutoCompleteCompany
{
    public string Value { get; set; }
}

Converts dataset to list

public static List<T> ToList<T>(this DataTable table) where T : new()
{
    IList<PropertyInfo> properties = typeof(T).GetProperties().ToList();
    List<T> result = new List<T>();

    foreach (var row in table.Rows)
    {
        var item = CreateItemFromRow<T>((DataRow)row, properties);
        result.Add(item);
    }

    return result;
}

private static T CreateItemFromRow<T>(DataRow row, IList<PropertyInfo> properties) where T : new()
{
    T item = new T();

    foreach (var property in properties)
    {
        if (property.PropertyType == typeof(System.DayOfWeek))
        {
            DayOfWeek day = (DayOfWeek)Enum.Parse(typeof(DayOfWeek), row[property.Name].ToString());
            property.SetValue(item, day, null);
        }
        else
        {
            if (row[property.Name] == DBNull.Value)
                property.SetValue(item, null, null);
            else
                property.SetValue(item, row[property.Name], null);
        }
    }

    return item;
}

Webapiconfig

config.MapHttpAttributeRoutes();
config.Routes.MapHttpRoute(name: "DefaultApi",
                routeTemplate: "Api/{controller}/{action}/{id}",
                defaults: new { id = RouteParameter.Optional });

Error:

No HTTP resource was found that matches the request

MessageDetail: no action was found on the controller 'AutoComplete' that matches the request.

and below custom method works

public string GetAccess(string id)
{
    return "value3";
}

Please suggest a way to return dataset from stored procedure in to json as result (web api rest)

which url endpoint you are trying to use when you received the error MessageDetail: no action was found on the controller 'AutoComplete' that matches the request.? — sam
– sam, Commented Mar 4, 2020 at 21:17
ocalhost:5555/api/Version/acCompany/somevalue.............this got error — mr_gemini
– mr_gemini, Commented Mar 4, 2020 at 21:38

AmirNorsou · Accepted Answer · 2020-03-04 21:18:28Z

1

You must call something like :

http://yourhostname/Api/Version/acCompany?term=someString

Your Controller name is Version not AutoComplete!

answered Mar 4, 2020 at 21:18

AmirNorsou

1,1291 gold badge12 silver badges27 bronze badges

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

Comments

Alex - Tin Le · Accepted Answer · 2020-03-04 21:06:38Z

1

Because your controller name is Version, not AutoComplete. You just use wrong url.

answered Mar 4, 2020 at 21:06

Alex - Tin Le

2,0101 gold badge8 silver badges11 bronze badges

Comments

LarsTech · Accepted Answer · 2020-03-04 21:12:21Z

1

Change your return type to IActionResult, and wrap your list in an OkObjectResult, like so...

return Ok(co);

edited Mar 4, 2020 at 21:12

LarsTech

81.9k14 gold badges161 silver badges237 bronze badges

answered Mar 4, 2020 at 21:09

blue_thunder

311 silver badge5 bronze badges

Comments

schwechel · Accepted Answer · 2020-03-04 21:14:17Z

1

Instead of returning a List you can just return a JsonResult like this.

[HttpGet]
public JsonResult acCompany(string term)
{
  DataSet ds = new DataSet();
  List<AutoCompleteCompany> co= new List<AutoCompleteCompany>();
  try
  {
    ds = getdetails(term);//privae method returns dataset
    co= ds.Tables[0].ToList<AutoCompleteCompany>();
  }
  catch (Exception ex)
  { 
  }
  return Json(new { co {);
}

answered Mar 4, 2020 at 21:14

schwechel

3053 silver badges10 bronze badges

Comments

sam · Accepted Answer · 2020-03-04 22:39:31Z

0

I know this has been answered via query string. But as mentioned by OP in comments, if you want to invoke your endpoint like this: http://localhost:5555/api/Version/acCompany/somevalue

then you will need to modify your webapi action parameter to taken in id instead of term as shown below:

[HttpGet]
public List<AutoCompleteCompany> acCompany(string id)
{
   // rest of your action code would make use of id instead of term
}

After this change, you should be able to invoke it as http://localhost:5555/api/Version/acCompany/somevalue. When this is invoked, id will take in somevalue.

The reason why you need to use id is because the way how they are configured in webapiconfig.cs.

answered Mar 4, 2020 at 22:39

sam

1,9951 gold badge11 silver badges16 bronze badges

Collectives™ on Stack Overflow

Return in json from stored procedure in MVC web api

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related