Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Building JSON Results Table FROM DB
I want to take a page like this and create a JSON table so users could look up finishers based on one or more of the following search fields:
1) First Name
2) Last Name
3) Gender
4) Age
5) Bib
6) Race Participating in
All of these fields are in a sql server db will require a JOIN of three tables.
Tables:
1) Participant (First, Last, Gender) joined by ParticipantID to
2) PartRace (Bib, Age) joined by RaceID to
3) RaceData (Race Entered)
Let me know what else I need to tell you to purt this together.
1) First Name
2) Last Name
3) Gender
4) Age
5) Bib
6) Race Participating in
All of these fields are in a sql server db will require a JOIN of three tables.
Tables:
1) Participant (First, Last, Gender) joined by ParticipantID to
2) PartRace (Bib, Age) joined by RaceID to
3) RaceData (Race Entered)
Let me know what else I need to tell you to purt this together.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
have a look at aspJSON, it's a classic asp library that'll allow you to load data from the database and convert it to a json formatted string with one line of code
How are you calling your C# method which returns the results? And what is that method's signature?
For example, if you use AJAX from your View to call a method in your controller, you can return JSON by using the following pattern:
The JsonResult class is part of the System.Web.Mvc library.
For example, if you use AJAX from your View to call a method in your controller, you can return JSON by using the following pattern:
[HttpPost]
public JsonResult MyMethod()
{
return Json(myObject);
}
The JsonResult class is part of the System.Web.Mvc library.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial