Windows Store App Login

Question

 loginQuery = "SELECT count(*) FROM Accounts WHERE username = '" + txtUsername.Text + "' AND passcode = '" + pboxPasscode.Password + "';";

Hey guys,

I have a Windows Store App and it throws an exception on:

count = dbConnect.Execute(loginRecordsCount);        

The table definitions are fine and everything else appears to work, any suggestions?

Answer 1

Hi DGrasso,

I’m afraid that it is not the correct forum about this issue, since this forum is to discuss Visual C#. I will move your question to windows store app forum(http://social.msdn.microsoft.com/Forums/en-US/home?forum=winappswithcsharp). Thanks for your understanding.

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Hi,

The Sql database contain in your local computer or cloud?

If the Sql database contain in your local computer, you do not have access to it
in windows store app.

I recommend you can use SQLite instead of it or consider Windows Azure Mobile
Services to access to remote data.

See the link below:

http://msdn.microsoft.com/en-us/library/windows/apps/dn263252.aspx

Best Wishes!

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey. Thanks<br/> MSDN Community Support<br/> <br/> Please remember to &quot;Mark as Answer&quot; the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

Answer 3

If it a Sql server data base in the cloud "your own server" 

you have to provide the sql query through web services and make the windows store application read from this service.

thanks

Amr