Ok, I’ve been hacking around this particular problem for a month now, but think I’ve got a bead on how to stop it. So, I hope this helps someone! The Situation I’ve got a TableAdapter in C# and I’m using a Query to return a scalar value that ultimately becomes a double data type. The [...]
About byron
C# – NullReferenceException with TableAdapter and Scalar Values
by byron on December 6, 2011 in ASP.NET/C#, Programming
iOS 5 – Problem Setting an Image for UINavigationBar Background
by byron on December 3, 2011 in iOS
iOS 5 has made it much, MUCH easier to set an image as the background of your UINavigationBar. There are dozens of tutorials out there that will get you there, and I tried a half dozen of them, but still couldn’t get it to work. The code itself is very simple, and here it is: [...]
C# / VSTO – Using Excel Ranges
by byron on November 28, 2011 in ASP.NET/C#, Microsoft Excel
Using Visual Studio Tools for Office (VSTO) with Excel lets you use C# (or your other favorite .NET language to leverage the power of Excel. But you will have to learn how the syntax for the Excel object model as opposed to just using VBA syntax. This post shows you how to use Excel ranges [...]
C# – VSTO – Get Last Used Row or Cell in Excel Spreadsheet
by byron on October 25, 2011 in ASP.NET/C#
I have had the opportunity to get my fingers dirty with Visual Studio Tools for Office, at long last. My project brought me back to an old familiar problem in Excel, finding the last used row in a spreadsheet. This applies equally to C#, VB, and VBA. You just have to get access to the [...]
SAP – AUTH – How to Find Users who have Access to a T-code
by byron on August 15, 2011 in SAP
In the Business Analyst role in an SAP shop, it may be helpful to know what Roles or Users have access to a particular transaction code. Here’s a little tip that lets you do all sorts of queries about the authorizations in your SAP system. Use T-code: AUTH to Access “Infosystem Authorizations” Menu To get [...]
iOS – FMDB is THE End to Your SQLite Nightmares
by byron on August 4, 2011 in iOS, Programming, SQL
When you’re writing apps for iPad or iPhone, you’ve got a couple of options for you database solutions. By far the best options (if it fits your app’s data needs) is Apple’s own Core Data which can use SQLite as it’s database store. Core Data is fast, efficient, an object store, and provides some great integration [...]
OS X 10.7 Lion – How to Fix Trackpad and Mouse Scrolling to Normal
by byron on July 21, 2011 in Mac
I’m not sure if they are just messing with our minds or what, but Apple changed one of the most automatic navigation functions you do. Scrolling is the computer equivalent of breathing. You do it automatically, without thinking. Except now in Mac OS X 10.7, aka Lion, you have to breathe out to breathe in. [...]
iOS – Get the NSIndexPath for a UITableViewCell by Row and Section
by byron on July 13, 2011 in iOS, Programming
Here’s a newby tip for iPhone and iPad developers…I am noob too I was trying to build an indexPath based on a row # and section, but none of the constructors I tried seemed to work…stuff like indexPathWithIndex: or indexPathWithIndexes:length. Back to the class reference for more reading. I found the answer in the NSIndexPath [...]
SAP: F110 Problem – Company Codes #/# do not Appear in Proposal
by byron on June 9, 2011 in SAP
In SAP, T-code F110 allows to you process Payment Proposals and Payment Runs. Sometimes you might come across the error message “Company codes ####/#### do not appear in proposal [date] [proposal ID]; correct”. This basically means that the Proposal run isn’t finding any invoices that can be paid. In some cases, you may not get [...]
WordPress – Tips on Creating and Updating Tables with dbDelta
by byron on April 23, 2011 in PHP, Programming, WordPress, WordPress Plugins
One of the reasons I LOVE WordPress is that it makes some mundane programming chores very easy, particularly working with the database. WP uses a modified version of the ezSQL to interact with the database, and provides a number of data cleansing functions, both of which are huge time savers. One other thing that WP [...]
Recent Posts
Popular Posts
- Excel Spreadsheet of US States
- Get ASP.NET DropDownList Selected Value with jQuery
- Javascript: How to get an Object's ID
- ASP.NET - Get User Name Under Windows Authentication
- SAP: Deciding about SAP-BPC (nee Outlooksoft)
- PHP: What is the & Ampersand Preceding Variables
- WordPress: Get Category ID for a Category Page
Tags
Categories
- Accounting (1)
- adobe air (1)
- ASP.NET/C# (16)
- Blogging (8)
- Books/Movies (1)
- Food/Travel (1)
- Google (1)
- iOS (3)
- iTunes/iPod (1)
- Javascript Frameworks (3)
- jQuery (3)
- Mac (4)
- Microsoft Excel (7)
- Microsoft Outlook (1)
- Miscellany (13)
- PHP (8)
- Productivity (6)
- Programming (7)
- SAP (52)
- Software (2)
- SQL (2)
- Web (5)
- Web Development (13)
- WordPress (18)
- WordPress Plugins (3)
- WordPress Themes (3)
- Words/Quotes (1)
- Worksoft Certify (6)
- YouTube (2)


