On my aspx page I have working sqldatasource control ha can insert record to db
The source is a REST query:-
http://query.yahooapis.com/v1/public/yql?q=select%20name%2C%20country%20from%20geo.places%20where%20text%3D%22san%20francisco%2C%20ca%22&diagnostics=true
Now it return XML.
I am new to JSON and seems it can hep in my situation above.
Would anyone point me to direction how ?
ie two steps
(1) Get the external data (query posted in #1) to sqldatasource
(2) Execute sqldatasource to save data to respective fields in db.
I have done part (2). But I do not know how to do part (1).
Pls help.. thanks
Go to the complete details ...