Newbee asking to be pointed in the right direction - SQL connection and code examples

[Markus]

Good day to all your experts

I have a web site were I store stuff in a sql express database. I basically save notes to be presented to me on a specific date. One presented I click a button and it will be presented to me again in the future. Here is a short video about the web http://www.youtube.com/watch?v=k1Ve2KpK9Rk

Now I have been using this over the web for quite a while and am thinking now to make an iOS and Android app so users can easily use it on their smart phones.

Installed Icenuim, connected the Galaxy S3 played around and everything works fine.

Now coming from a web developer side using Telerik  products  and SF I am of course a bit clueless about how to go on with more advanced stuff. I use OpenAccess for the project if this helps me any :-)

I heavily relay on examples where I can see how its done and then amend them to my needs.

So the tasks I am up against an looking for code examples are 

1) basicaly connecting to a sql server db on the web
    - for login purposes 
    - retrieving date
    - display data
     - save date

- Web Api seems to be the way, but how to secure a request to users so not all users are returned ?

2) Multilingual Apps
     - form the web I use .resx files (whow to handle it in 'real' apps)

Well once I get the login going I am happy that the rest will fall in place (with some more post here :-)

Markus

[Deyan Varchev]

Hi,

 Thank you for trying out Icenium. We hope it will be of help so that you achieve your goals.
 You've identified pretty well the direction you need to go. Your first goal should be to expose your data from the database to the mobile app through some type of services. You can go in different directions from here but what we recommend fits best with a hybrid app is to use some type of restful service. You can either go and build it with Web Api or some other framework (like ServiceStack). Open Access also provide some means to expose an OpenAccessContext thorough restful services - more info here.
 As far as service security is concerned, both Web API and ServiceStack provide flexible models of authenticating and authorizing service call usages with tons of resources online. You just need to search for it.

 Now to address your second question about internationalization of your app. The basic means of identifying what type of culture(language) the client mobile device has configured are available in Cordova's Javascript API - more info on that here. From then on you need to provide a set of translations of your application texts and bind them to the appropriate UI elements. Unfortunately we cannot provide you with a sample for that but I think this StackOverflow question and answer shows one simple approach.

 I hope this information will be of help. If you struggle with something while working with Icenium, we'll always be here for you.

Regards,
Deyan Varchev
Telerik

Do you enjoy Icenium? Vote for it as your favorite new product here (use short code H048S).
Looking for tips & tricks directly from the Icenium team? Check out our blog!
Share feedback and vote for features on our Feedback Portal.

[Markus]

Dear Deyan

Thank's for taking the time. The links will be very usefull.

At the moment I am building my first very simple app. 

I went with the OpenAccess approach
- localhost call to web api works
- http://myserver call to web api results in 404 

Thank you very much for all the links. Will try to read (and understand them)

Markus