Click here to Skip to main content
15,893,622 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,
I used sqlite with nsb-appstudio
I create a database in sqlite using cmd and connect this with my project in manifest
and then
after insertion, data saved in a local storage and when rerun the project data not found
I want to save the data in the database I created not a local storage
or why I can't find data in select

What I have tried:

C#
Dim DB
Sub Main 
  DB = SqlOpenDatabase("test.db")
End Sub

Function btnSave_onclick()
  sqlList[0]=[" insert into activityInfo (id, userName, whatToDo, whereToGo,    whoToCall, whatToBuy, isOne, isTwo) VALUES (?,?,?,?,?,?,?,?)", [4, userName,   txtWhatToDo.text, txtWhereToGo.text, txtWhoToCall.text, txtWhatToBuy.text, isOne, isTwo]]
  Sql(DB, sqlList)
End Function
Posted
Updated 15-Jun-16 6:17am
Comments
Richard MacCutchan 16-Jun-16 4:22am    
Try asking at the nsb-appstudio forum.

1 solution

Is your database file listed in Solution Explorer? If so, right-click it and pick Properties. There is an option for "Copy File" and it's probably set to "Copy always". This will overwrite the database file in the bin folder from where your application is running every time you launch the application under the debugger in Visual Studio.
 
Share this answer
 
Comments
Heba Kamel 16-Jun-16 2:26am    
I don't use Visual Studio, I am using nsb-appstudio with sqlite
Dave Kreskowiak 16-Jun-16 8:22am    
In that case, I have no idea what's wrong because I don't know nsb-appstudio and how it behaves.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900