January 2011 Entries

Android - Create a custom multi-line ListView bound to an ArrayList

The Android HelloListView tutorial shows how to bind a ListView to an array of string objects, but you'll probably outgrow that pretty quickly. This post will show you how to bind the ListView to an ArrayList of custom objects, as well as create a multi-line ListView. Let's say you have some sort of search functionality that returns a list of people, along with addresses and phone numbers. We're going to display that data in three formatted lines for each result, and make it clickable. First, create ......

Technorati post

Post for Technorati tagging, ignore...

TYUF7KKQQG55

Getting SQL table row counts via sysindexes vs. sys.indexes

Among the many useful SQL snippets I regularly use is this little bit that will return row counts in a table: SELECT so.name as TableName, MAX(si.rows) as [RowCount] FROM sysobjects so JOIN sysindexes si ON si.id = OBJECT_ID(so.name) WHERE so.xtype = 'U' GROUP BY so.name ORDER BY [RowCount] DESC This is handy to find tables that have grown wildly, zero-row tables that could (possibly) be dropped, or other clues into the data. Right off the bat you may spot some "non-ideal" code - I'm using sysobjects ......

Android - passing data between Activities

(To follow along with this, you should understand the basics of starting new activities: Link ) The easiest way to pass data from one activity to another is to create your own custom bundle and pass it to your new class. First, create two new activities called Search and SearchResults (make sure you add the second one you create to the AndroidManifest.xml file!), and create xml layout files for each. Search's file should look like this: <?xml version="1.0" encoding="utf-8"?> <LinearLayout ......

What version(s) of Android should I be targeting?

If you're wondering about what screen sizes and flavors of Android are currently out in the wild, the Android Developers site has a handy little chart of both (each image below is hyperlinked to the page): So, as far as platforms go, there aren't many people still out there running less than 2.X... and you'd probably be safe not worrying about Small or Low Density screens. I'd be curious to know if any of the other app stores (Amazon, Archos, etc.) offer similar stats ......