93Apprenticeship Alum
- 0
4 Ways to How to Export Data from Power BI
While Power BI has the technology to allow users to import data from many data sources easily, many data analyst and business users don't realize that it is just as easy to export data from Power BI. I will show you how.
- 0
Easily Import and Export Excel Data to SQL Server
Adding a few lines of VBA code to Excel will allow you to dynamically export your data in a Worksheet to a Microsoft SQL Server without the need of a programmer.
- 0
10 Tips for Working With Large Excel Files
In our world of advanced analytics and big data, there is no getting away from our beloved data crunching and wrangling tool: Excel. However, with large datasets, Excel starts to huff and puff. These 10 tips will help crunch your data for the last minute meeting like a pro.
- 0
How To Backup SQLite Database on iOS
A critical component of any iOS application with a database is implementing a backup strategy. This how-to article provides many options for backing up a SQLite database, which is the standard database choice for iOS apps.
- 0
Create SAP Function Module to get KVGR1 from KNVV
How to create a function module to query the KNVV table using ABAP SQL.
- 22
Create Radio Buttons and Checkboxes for iOS Applications
Create beautiful custom control radio buttons and checkboxes for your iOS (iPhone, iPad) applications. Follow this simple tutorial to create radio buttons and checkboxes that fit the style of your app and requires very little code.
- 2
How to Open and View PDF Files in iOS
Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.
- 31
Create PDF using iOS UIKit
Learn to create PDF documents using the APIs in the iOS UIKit. Use the UIGraphicsBeginPDFContextToFile and the UIGraphicsBeginPDFContextToData to quickly create and save PDF files with this sample iOS iPhone app.
- 0
Working with UITextView with SQLite iPhone App
Step forwards and backwards though data in SQLite database. Learn how to browse data in a SQLite database using this iPhone app which uses a UITextField and an UITextView to capture and display data to and from the database. The tutorial also shows how to dismiss the keyboard from the UITextField...
- 0
Disable Blinking Cursor in iOS UITextField
This sample code and example iPhone app demonstrates a solution to remove the blinking cursor from an UITextField in an iOS app. This is handy as the app demonstrates to use with an UIDatePicker to allow a user to select the UITextField with no cursor and trigger the app to load the UIDatePicker...
- 5
Store Binary Data in an iPhone SQLite Database App
Learn how to store binary data like image in a SQLite database from an iPhone iOS app. You will also learn how to convert the uiimage to binary data for storage and retrieval in an UIImageView using an UIPickerView as a selector.
- 24
Android SQLite App Development with Flash Builder and Flex
Learn how easy it is to develop Android App with SQLite using Adobe Flash Builder and Flex. Adobe's Flash APIs have native support for SQLite making developing Android apps easy. Using Adobe Air and the ADT in Flash Builder you can make an Android app in a few hours, thus greatly increasing your...
- 41
Guidelines for Good Posture at a Computer Desk
Sitting postures to avoid back pain while sitting at a computer workstation or desk starts with an office ergonomic chair. Choosing the right office chair to lower pain is key to good posture for computer use. Lower your lower back pain from sitting while sitting by selecting a good office chair...
- 2
How-To Use iOS NSString Format Specifiers
Easy examples on string format specifiers in iOS NSString objective-c programming. Add values of different data types to strings using c code that conforms to IEEE c printf. Examples for all supported string formaters specifiers.
- 2
How to Make an iPhone App with Flash Builder
How to make an iOS app using Flash. Learn to make Flash Builder apps for Flash iOS development. With Flash app development, you can create iOS apps for App Store. Adobe Air will convert to native iOS code for great mobile apps.
- 4
SQL Shell Commands
Run WMI queries and process or another DOS or Windows process from SQL Server using the SQL xp_cmdshell function. This tutorial walks you through how to setup xp_cmdshell on the server and execute different types of queries and storing those values in tables.
- 15
A Tutorial on Making a UIPickerView Sample App
iOS UIPickerView is a versatile UI control in the UIKit of the Cocoa Touch Framework. Learn how to create single and multi-column UIPickerViews with this tutorial.
- 2
How to Backup Windows Registry With VB Script or JScript
Use the CommandLine, VBScript, or JScript to export a Windows Registry or keys.
- 20
How to Write a Software Development Proposal
A free and complete software development proposal template with budget, ROI and CAGR formulas and instructions. Detailed instructions to help you prepare a winning software development proposal.
- 16
How to Reduce a Large Excel File
Reduce Excel file size using this techniques like file compression, data management, switching to a binary format and using PowerPivot or PowerQuery.
- 19
Tutorial on How-To Add Core Data to a New or Existing iOS App | iPhone | iPad
This tutorial provides all the steps to manually add Core Data to an existing application or to an iOS application, like a Single View Application, without using a pre-existing Core Data template. This tutorial assume that no Navigation Controller or Tab Bar Navigator is used.
- 16
How To Store and Display Images in a Core Data iPhone App
Learn how to store UIImage (image) data in Core Data using this tutorial.
- 35
iOS | How To Create a SplitViewController iPad Application using a Storyboard
Develop a SplitViewController iPad in Xcode 4.3.2 and iOS 5.1. This tutorial provides complete instructions.
- 2
iOS | How-to Tutorial on Developing iPad & iPhone Apps using the OpenGL and GLKit Frameworks
Develop 2d and 3d graphics using the GLkit and the open GL ES frameworks. This tutorial provides a great introduction on GLKBaseEffect, GLKSkyBoxEffect, GLKTextureLoader and how to setup a basic animation in iOS.
- 0
iOS | How-To Develop an AVPlayer iPAD Application and AirPlay
Create AVPlayer applications for iPAD that uses AirPlay. This tutorial provides complete instructions
- 2
iOS | How-to Use Property List Files to Store Data in iPad or iPhone App
iOS Property List files, or plist files, are a great way to store data and to use them to store config setting specific to your app or even to use them instead of global variables. This tutorial teaches you how to create plist files and read and write to them using Core Foundation classes as well...
- 81
Tutorial on How to Make an iOS SQLite Mobile Database App for iPhone
iOS SQLite Database for iPhone and iPad is a tutorial demonstrating how to Insert, Update, Delete, Select (CRUD) data from a UIViewController into a SQLite database in an iPhone or iPad application. Display data from a SQLite database in UITableViewcontroller. How to push selected data from the...
- 69
How-To Pass Data from UITableView to Detail View Controller
This tutorial demonstrates how to display data in a detail view controller for an iOS app, based on the selection in the UITableView.
- 20
iOS | How - To Share Data Between View Controllers using a Singleton
iOS, what is the best ways the make data globally available? One possible solution is to use a Singleton as this tutorial demonstrates. Using a Singleton to pass data between multiple view controllers and other objects is a fairly safe way of transferring data. This tutorial shows you how with...
- 10
iOS 5 | How-To Use Global Variables with the AppDelegate for iPhone and IPad Apps
With iOS 5 and ARC, the #define keyword is frown upon and creates linkage issues with the compiler. You still can create Global Variables, but without the #define macro. This tutorial shows you how.
- 8
iOS 5 | How To Use the UIAlertView in iPad or iPhone Application
The IOS 5 UIAlertView is a versatile popover that offers several styles. Logins, Prompts, Text Messages. This tutorial offers several examples on how to implement the UIAlertView for iPad and iPhone or iPod Touch.
- 43
iOS | iPhone | Tutorial on How-To Pass Data Between Two View Controllers
IOS, send data from one View Controller (scene) to another View Controller (scene) using a segue and the prepareForSegue. This is a simple tutorial with clear steps.
- 11
IOS 5 | Tutorial on How-To Increment and Decrement a Global Counter Variable
This is a tutorial on how to implement an incrementing or decrementing counting as forward or back buttons to retrieve values from an Array using Objective-C and display the values in a label on a View Controller in an IOS Storyboard.
- 2
iOS | How -To Programmatically Dismiss the UI Keyboard on IPhone or iPad Apps
This is a tutorial to demonstrate how to dismiss the contextual keyboard that displays when a user enters a UITextField. This tutorial demonstrates how to make the keyboard dismiss when a field loses focus, or when a button is press and how to make the keyboard dismiss using a Swipe Gesture...
- 18
A Beginner’s Guide to Storyboard Object Connections & Delegates on iOS
This Storyboard Connections tutorial provides insight on how to create connection in a Storyboard, set delegates, add code to interact with the different objects. It is designed for new programmers or at least programmers just learning the technology. It also show how to dismiss the keyboard suing...
- 190
How To Develop an iOS iPhone or iPad App using SQLite Data and an UITableView
Select and display data from a SQLite database in iOS Cocoa Touch UITableView. Complete source code included.
- 10
How-To Create a Multi Database iOS App with SQLite
SQLite is a great technology for data storage and persistence for mobile applications and web applications. Although not a database server, it offers nevertheless the possibility to group several databases together, for lack of a better explanation, and to allow for multi database queries like you...
- 6
Objective-C Programming | if...else Logical Expressions
Objective-C if examples. If expressions in Objective-C work the same as in C or any other language. This tutorial is a good mix between theory and complete code examples. It also show how to create objects and methods that can be used to evaluate Boolean expressions.
- 11
Objective-C Course | How-To Use Objective-C Instance Variables
Objective-C instance variables and constant. In addition to the types, C variables and constants, Objective-C also adds instance variables. This tutorial offers a comprehensive review of how to use instance variables and constants in Objective-C and how to implement them in your own code.
- 0
How to Use Objective-C Variables, Constant & Types to Develop iPhone and iPad Apps
Variables, constants and their types are some of the main building blocks in programming. This tutorial covers variables in C in regards to Objective-C. This is a second installment in a complete course on C and Objective-C
- 33
Tutorial on Developing iOS Core Data Applications for Beginners
IOS 5 Core Data offers a simple development model for applications that require data persistence. This tutorial offers a developer new to IOS 5 how to create and use Core Data with their applications.
- 3
How To Develop a Standalone (EXE) C# Application
It is easy to create standalone application using C# or even VB.Net. This tutorial provides the step by step instructions on how to create your own.
- 23
How-To Read and Write to Files with iOS SDK (Objective-C)
There are several ways to use Objective-C to read, write and create files and directories. This tutorial presents one way, which is adapted for the IOS 5 SDK.
- 258
Tutorial on Creating an iOS SQLite Database Application for iOS, iPhone, or iPad
(c) klanguedoc 2010. iOS SQLite Database is a tutorial that demonstrates how to create an iOS iPhone and iPad applications with a SQLite database.
- 69
Silent Connection with SAPLOGON with RFC SDK Example
This tutorial demonstrates how to make a silent connection using VBA (or Visual Basic), either from an Excel worksheet or VB client. The tutorial uses the BAPI Control and SAP Logon Control, both of which, are included with the SAPGui and RFC SDK.
- 131
How to Use SAP Nco 3 Connector:.Net 4 and Visual Studio
This is a tutorial on using the SAP .Net Connector, NCO 3.0.3.0 for .Net 4 and Visual Studio
- 0
List of 27 Offline (Standalone) Web and Native Application Databases | Google Chrome | Apple Safari | Mozilla Firefox
This is a reference of most of the free and or open source databases that can be used for mobile and web applications that require to be operated offline.
- 0
How To Customize the Ribbon in Excel 2007 or Excel 2010 | ooxml | RibbonX | Open Office XML
This a tutorial on creating Excel CustomUI controls for the RibbonX UI element.
- 11
Creating Mobile Apps with This List of 22 Free and Open Source Mobile App Development Frameworks
Over 22 free and open source development frameworks and other software tools to create mobile apps for most major smartphone and tablet devices and platforms.
- 0
How-To Update Data in an Adobe Flex DataGrid Cell using e4x | ActionScript | XML | Flash
This tutorials demonstrates a very easy and effective method of manipulating data in a Adobe Flex DataGrid using XML and e4x in an ArrayCollection.
- 4
How-To Use HTML5 File System Access API
This is a how-to article to demonstrate the html5 api to access files on a computer through a browser.
- 0
How To Create a Servlet (ashx) in .NET using Visual Studio C#
Creating a servlet is very simple, once you know the mechanics. Just like a Java Servlet is just a bunch of methods to handle HTTPRequests and HTTPResponses so is the Generic Handler class in Microsoft (dot) Net which implements the IHTTPHandler...
- 2
Adobe Flex | ActionScript | How to Find an Item in ArrayCollection Without getItemIndex()
Since getItemIndex doesn't return a match lookup value,instead always returns -1, this solution is a great workaround, even on long lists
- 2
How-To Synchronize Data Between Excel and SQL Server
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
- 2
SQL Server and Excel Integration using OPENDATASOURCE
Opendatasource provides the means to create adhoc connections. It uses a linked server object. You can access server locally or remotely. You can add the same kind of parameters as a linked server object including username and password. If you need...
- 0
How-To Synchronize Data Between Excel and SQL Server using LinkedServer
Linking Excel with SQL Server with sp_addlinkedserver You can use the sp_addlinkedserver stored procedure to create the same Linked Server Object. Here is some sample code that you can use: CREATE PROCEDURE dbo.CreateXlsMusicLink AS BEGIN ...
- 2
How to Execute Command Line Commands Using T-SQL
The Transact-SQL language has many far fetched functions and commands. This tutorial show how to use cmdshell to execute DOS commands and insert the results into a table.
- 16
How-To Program with Microsoft Office Excel and C# using a Ribbon and Interop
How to Develop an Excel App using the VSTO Interop services (com) and C#. This hub also demonstrates how to add a ribbon and interact with the app from the ribbon.
- 0
Use Openrowset to Import Excel Data Into Sql Server
Configure oledb (Microsoft.ACE.OLEDB.12.0) in SQL Server and use OPENROWSET to insert and select data in Excel 2007 and 2010
- 0
How-To Get Last Day of a Month using T-SQL (Transact-SQL)
This tutorial demonstrates how to obtain the last day of any given month using Transact-SQL in SQL Server. It is a perfect solution for a function call.
- 0
How to create a T-SQL function to get last day of the week
T-SQL has many function data time functions that can be combined to calculate other missing date time functions like getting the last day of the week.
- 0
How-To Use VBScript with T-SQL (Transact-SQL) | xp_cmdshell
Transact-SQL boast many specialized stored procedures, enabling the developer or administrator to interface with every part of the Microsoft platform. This tutorial presents some example on how -to use vbscript to obtain information about the file system (files, directories, attributes)