public class EOMCountsheet
    {        
        [PrimaryKey, AutoIncrement, Column("-id")]
        public int Id { get; set; }
        [MaxLength(6)]
        public string Location { get; set; }
        public int InventoryCount { get; set; }
        public string Part { get; set; }
        public string UserID { get; set; }
        public string UniqueStamp { get; set; }
    }    

Select all Open in new window

            string path = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "CountSheet.db3");
            var tablelistout = new SQLiteConnection(path);
            var list = tablelistout.Table<EOMCountsheet>().OrderByDescending(t => t.Id).ToList();
            var data = new List<string>();

            foreach (var listing in list)
            {
                data.Add(listing.Id + "  " + listing.Part + " - " + listing.InventoryCount);
            }

            ArrayAdapter<String> listAdapter = new ArrayAdapter<String>(Activity, Android.Resource.Layout.SimpleSelectableListItem, data.ToArray());
            listAdapter.NotifyDataSetChanged();

            //_listView1.Adapter = listAdapter;
            //***************************************************************************************************

            _listView1 = EOMScanFragment.FindViewById<ListView>(Resource.Id.listView1);

            _listView1.ItemClick += (object sender, AdapterView.ItemClickEventArgs e) =>
            {
                ///GRAB ID HERE AND PASS TO DeleteRow()
                var item = _listView1.SelectedItemId;
                

            };
            _listView1.Adapter = listAdapter;

Select all Open in new window

public class EOMSelectItemActivity : Activity

    {
        public Button _btnSelect;
        public ListView _listView1;
        public TextView _txtFilter;
        public string jsonString;
        public string inventoryitems;
        private ArrayAdapter<string> adapter;
        public string items;
        private List<string> invItems;
                

        protected override void OnCreate(Bundle savedInstanceState)
        {
            base.OnCreate (savedInstanceState);
            SetContentView(Resource.Layout.EOMSelectItem);

            _listView1 = FindViewById<ListView>(Resource.Id.listView1);
            

            string filePath = Path.Combine(FileSystem.Current.LocalStorage.Path + "inventory.json");

            invItems = new List<string>();
            invItems.Add(items);

            var jsonContents = System.IO.File.ReadAllText(filePath);
            items = JsonConvert.DeserializeObject(jsonContents).ToString();

            ArrayAdapter<string> adapter = new 

Select all Open in new window

/* © 2009 ROBO Design
 * http://www.robodesign.ro
 */

var imageData, context, pixels;

function clearCanvas()
{
	context.putImageData(imageData, 0, 0);
}

function checkFields()
{
	var themessage = "Please complete the following fields:";
	if (document.form.ptname.value=="") 
		{
		themessage = themessage + "\n     Patient's Name";
		}
	if (document.form.dob.value=="") 
		{
		themessage = themessage + "\n     Birthdate";
		}
	//alert if fields are empty and cancel form submit
	if (themessage != "Please complete the following fields:") 
		{
			alert(themessage);
			return true;
		}
		else
		{
			return checkdate(document.form.dob.value);
		}
}
function checkdate(input)
{
	
	var validformat=/^\d{2}\/\d{2}\/\d{4}$/ //Basic check for format validity
	var returnval=true
	if (!validformat.test(input))
		alert("Invalid Date Format. Format: (mm/dd/yyyy) \nPlease correct and submit again.")
	else
	{ //Detailed check for valid date ranges
		var 

Select all Open in new window

/* © 2009 ROBO Design
 * http://www.robodesign.ro
 */

var imageData, context, pixels;

function clearCanvas()
{
	context.putImageData(imageData, 0, 0);
}

function checkFields()
{
	var themessage = "Please complete the following fields:";
	if (document.form.ptname.value=="") 
		{
		themessage = themessage + "\n     Patient's Name";
		}
	if (document.form.dob.value=="") 
		{
		themessage = themessage + "\n     Birthdate";
		}
	//alert if fields are empty and cancel form submit
	if (themessage != "Please complete the following fields:") 
		{
			alert(themessage);
			return true;
		}
		else
		{
			return checkdate(document.form.dob.value);
		}
}
function checkdate(input)
{
	
	var validformat=/^\d{2}\/\d{2}\/\d{4}$/ //Basic check for format validity
	var returnval=true
	if (!validformat.test(input))
		alert("Invalid Date Format. Format: (mm/dd/yyyy) \nPlease correct and submit again.")
	else
	{ //Detailed check for valid date ranges
		var monthfield=input.split("/")[0]
		var 

Select all Open in new window