How to save the current location into database when button was clicked?

Question

I'm creating a project that need to get the current location of the user and when the user clicked the specific button the current location, date and time will automatic save into database and in another activity you can see the list or history of your location log 

can anyone please help me with the database I already know how to get current location of the user creating database for the current location to be saved is the only my problem can anyone please help me?

James Watson · Answer

If you already know how to get current location, you may create a database in design time and build the db into your app package. 
The db should include at least one table for records. In your click event handler codes, just execute insert sql command to insert a record with current location info as well as current date and time.