Ok, so thanks to some kind help from this site last night and yet more Googling this morning, I have managed to create a VB function which gives me this:
http://test.hartnollguitars.co.uk/makeJSON.aspx
This is a list of 50 items within my product database in a JSON format.
Now I want to use this in an Autocomplete field in a product search in the sales system that I am rebuilding.
What's the best process here? I've a few questions
- Should this output actually be saved as a text file, or is it possible to use it directly from this aspx file? (this is preferred as the data can change regularly)
- I am happy to use Javascript in my back-end content management system (which I am working on at the moment) but would like to know how to do this server-side as well.
Given point 2, I'd like to use http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/autocomplete/autocomplete.aspx rather than http://jqueryui.com/demos/autocomplete/ although, both do essentially what I am after.
Thinking as I type... I guess using Javascript client-side for this application would be fine, but I still want to know how to decode this stuff server-side so I can use it to navigate the Facebook Graph and output data (specifically event data) to my website for all users. Currently I have a lot of hashed-up code that does this!!!!
EDIT: Forgot to emphasis... I'm using VB not C#! There's load of online tutorial for C#, but really struggling to find helpful examples for VB