(773) 860-0643  

  • "It’s been really nice working with you, Jamie and Ruby! Thank you for your continued support to Frank, Rimerman Consulting."

    Beverly MCSM (GP Partner)
  • "Thanks for the late-night support the other night!... Client was operating as it should this morning!   WOOO HOOOO !"

    Maureen ACAE (GP Partner)
  • "Have I told Alba-Spectrum this year yet how F A S T the newsletter selection is now ???? Wow. Thank you very much!"

    Dennis Westbrook
  • "We were successful last night in completing the production deployment of Terminations WF. Ricardo was fantastic and we could not have done this without him"

    Tawna KProject Manager (Credit Management)
  • "[We are] so grateful for Jeff’s help, and Jeff has been so good to...ZTrim in all of his support."

    John ECFO (Agricultural Ingredient Technology)
  • "First off, thanks for all the great suggestions. I’ll let you know what we find out. Many thanks for your help"

    Mark BDeveloper (Telephone Company)
  • "I will e-mail you back to let you know I was successful with HJE – which I expect to be. I really appreciate how you helped me."

    Michele DurkinConsultant (GP Partner)
  • "...thank you both for taking some time out to help me troubleshoot the issue of creating a project directly into the GP tables without the benefit of using the web services."

    Jesse CPrincipal (GP Partner)
  • "For example, when an AE calls to confirm rates, there’s not a 30 second pause waiting for the billing schedule to open. It’s absolutely immediate, literally, click, click, click. It’s a huge difference."

    Vince FCredit Manager (Media Data Service)
  • "So far everything seems to be working fine. We have had it in production now for almost a month and have not experienced any problems."

    Mark MFinance Manager (Custom Woodwork)
  • "Alba will always be my choice for quality innovation on ANY project you put in their lap from websites to Great Plains implementations, customizations and people who think 'outside the box'. "

    Robert DCEO
  • "Rod, your team’s flexibility and quality of service have been appreciated."

    Nicholas NController (Financial Trading)
  • "I most heartily and sincerely recommend him and his firm for any software implementation task."

    John PCFO (Tourism Association)
  • "[the] team delivered several enhancements to Great Plains, significantly improving our sales order entry process, shipment routing, and handling of catch-weight items."

    Eddie HPresident (Food Products)
  • "You have come very highly recommended by other companies. I have been impressed with your professionalism and attention to detail."

    Timothy CPresident (Uniform Manufacture)
  • "I am very happy that Andrew was able to fix our invoice system. Your company is very professional and performs excellent service."

    Allen ZCFO (Oil Company)
  • "I don't know who your company president is, but you guys did great job and I hope he/she sees this email."

    Nathan M.Finance (Marketing Communications)
  • "I heartily recommend Alba to any developer or end user seeking to make the most of their GP investment."

    Brett GPresident (Software Development)
  • "Thank you for all your patience and hard work getting this all processed. Here at Friedr Dick Corp we are looking forward to a wonderful professional relationship."

    Jill DAccounting Manager (Home Furnishings)
  • "I think we are going to be a great team working forward on the Miami project."

    Jesse CPrincipal (GP Partner)
  • "As usual, superb product and service!! Everything is working great and all my users love the modification. Thanks again!"

    Michael LController (Healthcare Storage)
  • "[W]e thought your product GP Posting Server was the better solution. The interface is better, it is easier to understand, and there are more options considering the auto transfer feature. We compared it to the Envisage Post Master Enterprise software."

    Tom BSenior IT Administrator (Medical Implements Company)
Customer Feedback
  • "It’s been really nice working with you, Jamie and Ruby! Thank you for your continued support to Frank, Rimerman Consulting."

    Beverly MCSM (GP Partner)
  • "Thanks for the late-night support the other night!... Client was operating as it should this morning!   WOOO HOOOO !"

    Maureen ACAE (GP Partner)
  • "Have I told Alba-Spectrum this year yet how F A S T the newsletter selection is now ???? Wow. Thank you very much!"

    Dennis Westbrook
  • "We were successful last night in completing the production deployment of Terminations WF. Ricardo was fantastic and we could not have done this without him"

    Tawna KProject Manager (Credit Management)
  • "[We are] so grateful for Jeff’s help, and Jeff has been so good to...ZTrim in all of his support."

    John ECFO (Agricultural Ingredient Technology)
  • "First off, thanks for all the great suggestions. I’ll let you know what we find out. Many thanks for your help"

    Mark BDeveloper (Telephone Company)
  • "I will e-mail you back to let you know I was successful with HJE – which I expect to be. I really appreciate how you helped me."

    Michele DurkinConsultant (GP Partner)
  • "...thank you both for taking some time out to help me troubleshoot the issue of creating a project directly into the GP tables without the benefit of using the web services."

    Jesse CPrincipal (GP Partner)
  • "For example, when an AE calls to confirm rates, there’s not a 30 second pause waiting for the billing schedule to open. It’s absolutely immediate, literally, click, click, click. It’s a huge difference."

    Vince FCredit Manager (Media Data Service)
  • "So far everything seems to be working fine. We have had it in production now for almost a month and have not experienced any problems."

    Mark MFinance Manager (Custom Woodwork)
  • "Alba will always be my choice for quality innovation on ANY project you put in their lap from websites to Great Plains implementations, customizations and people who think 'outside the box'. "

    Robert DCEO
  • "Rod, your team’s flexibility and quality of service have been appreciated."

    Nicholas NController (Financial Trading)
  • "I most heartily and sincerely recommend him and his firm for any software implementation task."

    John PCFO (Tourism Association)
  • "[the] team delivered several enhancements to Great Plains, significantly improving our sales order entry process, shipment routing, and handling of catch-weight items."

    Eddie HPresident (Food Products)
  • "You have come very highly recommended by other companies. I have been impressed with your professionalism and attention to detail."

    Timothy CPresident (Uniform Manufacture)
  • "I am very happy that Andrew was able to fix our invoice system. Your company is very professional and performs excellent service."

    Allen ZCFO (Oil Company)
  • "I don't know who your company president is, but you guys did great job and I hope he/she sees this email."

    Nathan M.Finance (Marketing Communications)
  • "I heartily recommend Alba to any developer or end user seeking to make the most of their GP investment."

    Brett GPresident (Software Development)
  • "Thank you for all your patience and hard work getting this all processed. Here at Friedr Dick Corp we are looking forward to a wonderful professional relationship."

    Jill DAccounting Manager (Home Furnishings)
  • "I think we are going to be a great team working forward on the Miami project."

    Jesse CPrincipal (GP Partner)
  • "As usual, superb product and service!! Everything is working great and all my users love the modification. Thanks again!"

    Michael LController (Healthcare Storage)
  • "[W]e thought your product GP Posting Server was the better solution. The interface is better, it is easier to understand, and there are more options considering the auto transfer feature. We compared it to the Envisage Post Master Enterprise software."

    Tom BSenior IT Administrator (Medical Implements Company)

Returning JSON from Ajax-Enabled WCF Service

This is a simple way to display data from your database without calling a server side script bindings and without postbacks. This article shows you how to create a JSON enabled web service inside your ASP.net website.

Requirements

·         Visual Studio 2010

Steps

1.       First, create a website or use a pre-existing one.

2.       Add a new file and select the ‘AJAX-enabled WCF Service.

 AJAX-enabled WCF Service

3.       The IDE will generate the .svc file and the code behind of the service located in App_Code folder

4.       Create a new method that you wish to return a list of data.

 AJAXWebService

5.       Notice the attribute of the Method GetCustomers()

 AJAXWebService

You must include the WebInvoke attribute in order for the system ensures that this method returns a JSON format.

 

6.       Open your web.config file and replace the <enableWebScript /> into <webHttp />

 

 

7.       Build and try to run the service with the uri indicated on the WebInvoke attribute.

 

 

8.       Now that the service displays a JSON data, it’s time to parse and display it into HTML.

 

 AJAXWebService

 

9.       Create a simple HTML page and create a method that will show the data from your JSON returned URL.

 

AJAXWebService


10.   Now build the application and run the html page.

 

AJAXWebService

 

Conclusion

This approach is useful when it comes to simplicity and does not require extensive server side controls to display information from your database or any other data source.