Tag Archives: xamarin

Populating A SQLite Database Using CSV

Up until now for item data I’ve been typing items directly into the SQLite database using DB Browser for SQLite. The process was a bit cumbersome because I didn’t enter the items in alphabetical order so to make sure I … Continue reading

Posted in Side Projects, Software Development | Tagged , , | Leave a comment

Trim And Capitalize

I discovered during some initial testing that if you attempted to save an item without entering in an item name the app would crash. So I added some error checking and text formatting (but not in that order). The TrimAndCapitalize … Continue reading

Posted in Side Projects, Software Development | Tagged , , | Leave a comment

Saving and Deleting Items

After some thought I’ve decided to add or remove items from the SQLite database as soon as they’re added to either list or removed from the Add list (the other option I entertained was replacing the entire database contents with … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , | Leave a comment

Adding a SQLite Database to Android

Implementing a SQLite database on Android went a bit quicker after the iOS work. The steps involved were: Adding the SQLite.Net NuGet package to the Android project Creating an ItemSQLite.db3 link in the Android project Coding the SQLite_Android iSQLite interface … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , | Leave a comment

Adding a SQLite Database to iOS

My original thoughts about using a local SQLite database to store list data were to check and see if a database existed on the device at app startup. If it didn’t exist, I’d create a new database and populate it from … Continue reading

Posted in Side Projects, Software Development | Tagged , , , | 1 Comment

Initial Thoughts on Persistent Storage and Cloud Services

Two items remain before I can consider Viand ready for field-testing. Persistent storage of the Buy/Add list on the device Cloud storage for a shared Buy/Add list For the first item I’m going to use SQLite. The question here is … Continue reading

Posted in Side Projects, Software Development | Tagged , , , | Leave a comment

Duplicate Item Check

Added code to prevent a duplicate item from being entered into the list

Posted in Side Projects, Software Development | Tagged , , , | Leave a comment

Saving Items

I’ve tied the Clicked event of Save Item to a method in the AddItemPage XAML page’s code behind called OnSaveClicked. The AddItemPage code behind page has a boolean field called addToBuyList. This addToBuyList boolean is used to determine which list to … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , | Leave a comment

XAML Formatting and Code Behind

I added some padding and spacing to the parent StackLayout to move it down on the screen and put a bit of space between the individual elements. I also user the Orientation property of the individual elements to center them nicely … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , | Leave a comment

Initial XAML for Add Item Screen

In less than an hour I was able to add a Forms ContentPage XAML to my Viand project by right clicking on the Viand project, selecting Add -> New File -> Forms -> Forms Content Page Xaml, and adding the XAML below to … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , , | Leave a comment