My Content: Hubs, Answers, and Forums
3HTML5 ChannelMessaging Tutorial
This tutorial demonstrates how to implement the HTML5 channel messaging API using a sample application. The tutorial provide reference information on the API and also how to use WebWorkers.
0Web Server Server-Sent-Events (SSE) Tutorial
Discover the different technologies that provide push notification services to browsers like WebSockets and Comet. However there many more more mature protocols using TCP and HTTP.
0HTML5 Cross Document Messaging Tutorial
Learn how to use the HTML5 cross document API. This tutorial provides the complete code for a simple and easy example.
0Data Streaming Over The Internet
Several technologies, protocols and APIs in every modern programming languages allow for data streaming across networks. Datagrams, RSTP, RTP, HTTP, Peer-to-Peer, Telnet, TCP/IP, Sockets just to name a few. Discover the different options for media streaming and the different implementation from companies like Apple, Microsoft and Oracle.
2HTML5 Canvas Tutorial
Learn how to develop apps using the HTML 5 canvas element. This tutorial teaches how to raw using the API as well as using events to allow users to make their own drawings.
0HTML5 GeoLocation in Web App Tutorial
HTML5 includes a simple and powerful location based API called GeoLocation. Learn how to use this new API in your web applications and hybrid or web mobile applications.
2iOS 6 Storyboard Unwind Scene
Xcode 4.5 that was released with iOS 6 has implemented a new feature in the Storyboard to allow developers to transition back to the initial view controller without complex coding and memory management. This tutorial demonstrates how to implement the Exit object also known as the Unwind object or Unwinding.
0iOS Create Custom Buttons and Controls
Create custom UIControls using this tutorial for iOS apps using custom graphics, the UIKit and the Foundation classes. It is easy and requires very little code to create fully animated custom controls for iOS apps.
0How 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.
0Microsoft XAML Based Apps
Discover the types of XAML applications that can be built. XAML is the foundation for Windows Presentation Foundation and Silverlight. WPF is the framework for the Windows 7 Aero and Windows Metro 8 look.
5Develop a UISearchBar iPhone App
Learn how to perform SQLite database searches using the UISearchBar UIControl in the iOS 6 SDK. Complete code is provided.
0Create SAP Function Module to get KVGR1 from KNVV
How to create a function module to query the KNVV table using ABAP SQL.
6Create 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.
2iOS How To Open and View PDF Files
Open any PDF directly in an iOS application for reading. This simple sample iOS iPhone app provides the code and detailed instructions.
0Locate iOS iPhone Simulator Application Document Directory
Use this guide to locate an iOS app's sandbox on a Mac. This guide also provides an overview of an iOS app file structure.
7iOS Create PDF using 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.
0Create a Mobile Advertising iOS iAd App
Implement the ADBannerView and ADBannerViewDelegate to use the Apple iAd mobile advertising network and serve up top high quality advertisements in your iPhone, iPad, or iPod Touch mobile apps.
0Working 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 and UITextView UIControls.
0Video 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 and add it to the UIView.
3Store 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.
1How To Sell Android Apps on Amazon
Make more money selling Android App on Amazon. Developers earn as much money selling Android app in Amazon App Store as developers do in Apple iTunes App Store for iPhone and iPad.
6How To Publish Android Apps to Google Play
Use this handy guide to prepare your Android app as a signed apk archive that is required to publish your app to the Google Play store. This guide also provides the steps needed to publish the Android app in the Google Play web store.
16Android 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 productivity and monetization opportunities.
39Guidelines 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 with a good back chair and by having good posture while sitting.
2How-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.
2How 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.
4SQL 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 differenttype sof queries and storing those values in tables.
14A 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.
4How to Become an iPhone App Creator
Being an iPhone app creator is not only open to programmers, but also to marketers, web designers and other professionals in the creative arts. This guide explores the different options and provides the tools to help you realize your dream.
10How to Get iPhone Apps
List of online stores where you can get apps for iPhone and how to installed them on an iPhone
2Steps to Developing an iPhone App
Develop an iPhone app from market research to App Store deployment. Complete guide to build an iPhone app.
4SQL Business Intelligence Tools
SQL Server server includes tools for business intelligence in business. Included is SSIS, SSAS, SSRS, Excel, PowerPivot, MDX, DMX, XMLA, Microsoft SQL Server Management Studio and Microsoft Business Intelligence Studio and is now one of the leading BI platforms on the market.
7Places to Promote Your iPad App
How to promote your iPad, iPhone or iPod app. No matter how good your app, you must promote it to make money. Learn where and how to successfully promote your iPad app online.
2How To Backup Windows Registry with VB Script | JScript | command line
Use the CommandLine, VBScript or JScript to export a Windows Registry or keys
8How 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.
8Android vs. iOS
Android versus iOS. How are the platforms similar and what are the differences. How is Google and Apple keeping the app markets vibrant by maintaining the media hype about each platform. Also how much are developers actually making from their apps.
2How-To Reduce a Large Excel File | Compact | Shrink
Reduce Excel file size using this techniques like file compression, data management, switching to a binary format.
0Develop Core Data iPhone Apps
Using Core Data with View Controller or a Navigation Controller or even a Tab Bar Controller requires specialized coding requirements in didFinishLaunchingWithOptions method of the AppDelegate. This tutorial shows you how to code the NSManagedObjectContext for each launch type.
14Tutorial 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.
7How To Store and Display Images in a Core Data iPhone App | iOS | iPad | UIImage
Learn how to store UIImage (image) data in Core Data using this tutorial.
3iPhone | iPad | iOS | How To Customize the appearance of UIControls in an IPhone & iPad App using UIAppearance
Use the UIAppreance protocol to manage the appearance of UIControls for iOS apps.
29iOS | 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.
0iOS | 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.
2iOS 5 | How-To Tutorial on Creating Core Image Applications for iPad, iPhone or iPod Touch
The CoreImage Framework was introduced to the iOS SDK with version 5 although it has been available on Mac OSX for a few versions already. This tutorial demonstrates how to take a photo and apply filtering to create a new photo.
0iOS | How-To Develop an AVPlayer iPAD Application and AirPlay
Create AVPlayer applications for iPAD that uses AirPlay. This tutorial provides complete instructions
0iOS | 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 as Cocoa Touch classes.
71Tutorial | Make a SQLite Mobile Database App for iPhone | iOS | iPad
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 UITableViewController to a DetailViewController is provided.
0Transact-SQL | SQL Server | How-to Get the Week Endings for a Month
This Transact-SQL Multi-statement Table-valued Function demonstrates how to calculate the week endings for a given month and year. It can be used in most versions of SQL Server.
58iOS | 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.
14iOS | 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 detailed instructions and source code.
10iOS 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.
7iOS 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.
43iOS | 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.
2IOS 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.
2iOS | 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 Recognizer.
16iOS | A Beginner’s Guide to Storyboard Object Connections & Delegates | IBAction | IBOutlet
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 the resignFirstResponder.
5iOS | Code | How-To Program an iOS Twitter App
How to use the Twitter API in iOS 5; in particular the TWTweetComposeViewController "Tweet Sheet". It allows a user to enter text and to post a Tweet in their Twitter Account page. The iOS app use the dismissViewControllerAnimated method to dismiss the Tweet composer when finished.
169How To Develop an iPhone or iPad App using SQLite Data and an UITableView | iOS | Tutorial
Select and display data from a SQLite database in iOS Cocoa Touch UITableView. Complete source code included.
10iOS | SQLite | 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 would find with database server. This tutorial demonstrates how to use (attach) multiple databases with an IOS application.
0Objective-C Programming| The Conditional operator ? : | Ternary
The Conditional or ternary operator is an effective means to test a boolean expression in an inline setting and assign a value to a variable. This tutorial demonstrates how to use this often overlooked and misunderstood conditional operator.
6Objective-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.
7Objective-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.
0How 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
0IOS 5 | How-To Create and Configure an iCloud IOS 5 app
iCloud is one of the new services for IOS devices as well as other Apple device like the MacBook. iCloud enable apps enable the user to sync there content with an external server at an offsite data center run by Apple. iCloud offer several APIs to allow developers to iCloud enable their apps. This tutorial demonstrate the steps to create a Provisioning Profile and iCloud enable a new IOS app.
34iOS | iPhone | iPad | Tutorial on Developing 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.
0How 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.
9IOS 5 How To Create and Populate UITableViews | iPhone | iPad | iPod Touch
This tutorial teaches you how to create and display data in a UITableView using the new IOS 5 SDK. It is the first in a series
72iOS Tutorial: How-To Insert, Update, Delete with SQLite and Objective-C | iPhone | iPad | Apps
Perform Insert, Update and Delete (CRUD) in SQLite on an IOS 5 device like iPad, iPhone or iPod. This tutorial offers complete step by step instructions.
18How-To Read and Write to Files with iOS SDK (Objective-C) | iPad | iPhone | iPod Touch
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.
208Tutorial on Creating an iOS SQLite Database Application | iOS | iPhone | iPad
IOS SQLite Database is a tutorial that demonstrates how to create an iOS iPhone and iPad applications with a SQLite database.
22iOS Storyboarding Tutorial using Segues | Scenes | View Controllers | Navigation
This tutorial demonstrates how to create navigation between scenes with segues.
54Silent Connection with SAPLOGON with RFC SDK Example | RFC | Excel | VBA
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.
0Quick Tutorial on Storyboarding with IOS 5 for iPhone and iPad applications
This is a quick tutorial on using the Storyboard in the XCode 4.2 and IOS 5. The tutorial show how to create connections from the Storyboard and the header file. You will also learn how to set UI element properties with Objective-C or from the Attributes Inspector.
75How-To Use SAP Nco 3 Connector | .Net 4 | Visual Studio 2010
This is a tutorial on using the SAP .Net Connector, NCO 3.0.3.0 for .Net 4 and Visual Studio 2010.
3ActionScript Financial Math Utility Class Library | Business Math | ActionScript
This is an ActionScript utility class containing business math calculations. These include, GOGS, Inventory, Material, Labour and Overhead Cost, Loan Payments, Interest Rate calculations and much more.
3How-To Create an iPhone App in Minutes with AppMkr | No Programming | Android | Mobile
AppMkr is another framework which allows a developer, marketer or writer to create an iPhone, Android or Windows Mobile app to create an app from web content with no programming.
0Mobile (Offline) Web Applications Java Database Architecture
This article demonstrates an architecture to interface between JavaScript and Java using LiveConnect, Applet Scripting and the DOM API. The article shows how to create Offline Web Applications (OWAs) for both mobile devices and legacy devices alike.
0List 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.
0Tip: Integrate Microsoft Excel with SQL Server using OLEDB
Microsoft Excel is a great financial analysis software but it only makes a great client for SQL Server. This tutorial demonstrates two methods to write Excel data to SQL Server
0How-To Obtain Stock Information from Yahoo Finance | Actionscript | Adobe Flex
This is a tutorial on how to use Actionscript to query Yahoo Finance.
0How 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.
2Google Chrome | App Deployment Options
A review of the different deployments options for deploying Google Chrome applications.
4How-To Develop Four Kinds of Google Chrome Apps | Google Web Store
A review of the four types of Google Chrome apps that an be created in Chrome. A brief overview of the basic configuration required for each in the manifest.json file
4Free WebMatrix | Professional HTML Editor from Microsoft
An overview of Microsoft's WebMatrix HTML editor. Great tool for creating offline (web database ) web applications.
11Creating 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.
4How-To Create an iPhone or Android App With No Programming | Conduit
Create iPhone, iPad or Android apps with no programming It is a free service and you can monetize your app with inline advertising.
14How To Build a Mobile App using PhoneGap | No Programming | iPhone | iPad
The tutorial demonstrates how to create an ios app for iPhones or iPad using the PhoneGap platform and a HTML editor like Amaya (any other can be used as well). What is amazing is that entire app was created without doing any coding
- 0
How-To Copy and Paste Rows in Adobe Flex (Flash) DataGrid
How-to create (program or develop) a copy and paste functionality in the DataGrid
- 6
Tutorial on How-To Develop a Google Chrome App | HTML5
How-To article on creating offline apps and using web sql and new form features
0How-To Update Data in a 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.
0List: 3 Types of HTML 5 Database and Storage Options | HTML5 Database
This is guide of the various offline storage options available in HTML5. It also includes a short how-to on how to program with them.
0How-to Develop applications with MacRuby on XCode 4 | App for Mac
This is quick tutorial to demonstrate how to setup a MacRuby project in Xcode 4 to that it will compile correctly. To demonstrate MacRuby, this tutorial uses the SpeechSynthesizer in the AppKit framework in Cocoa
0How To Develop OS X Apps with MacRuby and Xcode 4.x
MacRuby is the latest incarnation of Ruby on a Mac. Like Objective-C, MacRuby uses XCode as a development environment. Learn the basics of MacRuby programming with this simple tutorial.
2How to Create an Ajax TreeView in Html
This example uses the HttpRequest to get data from a back end source (database) and generate an Ajax enabled Tree View. The most important part of the AJAX functionality is the code to connect with your back end system that allows asynchronous...
0Microsoft Office Productivity | Free Templates
There are a few possibilities. Since you didn't mention what kind of template you needed; will, divorce, contract, invoice, etc, I guess you want all kinds of templates. The second I will make is that you are looking for Microsoft Office templates....
- 2
How-To Develop Adobe Flex Web Services with Actionscript
Using XELement in .NET Linq, this tutorial demonstrates how to use actionscript to create a web service in Adobe Flex (Flash). To also shows how to populate an ArrayCollection in Actionscipt using XML
- 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
- 12
How To Create a Google Chrome Theme
Themes are a great way to personalize the Google Chrome browser. Â They can be published to the Google Web Store or deployed locally to your own browser. Theme, although for the most part are free, they can used to discreetly promote your own site...
2Android | How-To Install Android SDK in Eclipse on a MacBook Pro
The SDK for Mac contains some bugs in the file structure when compared to the Windows version. This article shows how easily fix these bugs and successfully install and configure the SDK in Eclipse on a MAC.
- 0
2 Business Intelligence Tools in Microsoft SQL Server | DMX | MDX
SQL Server as business intelligence platform offers two very powerful tools to perform both OLAP queries using the MDX language and also a data mining language DMX and editor. This article is a review of these two powerful tools.
2How-To Synchronize Data Between Excel and SQL Server | Linked 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
How-To Synchronize data Between Excel 2007 and SQL Server 2008 | 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...
- 2
How-To Synchronize Data Between Excel 2007 and SQL Server 2008 | OPENROWSET
For this next set of examples, I am going to use OPENROWSET to update my Excel file with data from SQL Server 2008. Before I get to the examples I am going to modify the Music table that I initial created in the previous example âHow-To...
- 0
How-To Synchronize Data Between Excel 2007 and SQL Server 2008
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 ...
- 0
How-To Add a T-SQL (transact-sql) CASE Expression to a WHERE Clause
This tutorial provides a very elegant and powerful way to use a CASE WHEN clause in the WHERE clause without using dynamic SQL.
2How To Add a Ribbon to Excel with C# Interop
This is Part 3 of a three part tutorial on creating an Excel SQL Server CRUD application using ADO.NET. You should read Part 1 and Part 2 first. Add code to load, update and save data back to the data store In order to save data back to the...
0How-To Integrate Excel Applications with SQL Server Apps | C# and Ado.Net
Using Visual Studio Tools for Office (VSTO), this tutorial demonstrate how to add an ado.net data source to your Excel application. C# is used to create an interface between your Excel file and a back-end data store like SQL Server, but other databases can be used | Oracle, MySQL, DB2
0How-To Add an Ado.Net Data Source to Excel and SQL Server | Visual Studio
Ado.net offers a powerful set of tools to allow Excel to connect to a database like Sql server or Oracle.This tutorial demonstrates the steps to setup and use Ado.net with Microsoft Office Excel.
0How To Execute Command Line Commands using T-SQL (Transact-SQL) and cmdshell | CLI | DOS
The Transact-SQL language has many far fetched functions and commands, lie cmdshell. The cmdshell function allows you to execute DOS command on the CLI from T-SQL. This tutorial show how to use cmdshell to execute DOS commands and insert the results into a table.
- 0
How To Query Windows OS with vbscripts, SQL and xp_cmdshell
klanguedoc @ 2010 xp_cmdshell is a system stored procedure in SQL Server that allows users to write queries exactly like using the Windows Command Shell. This jewel of technology opens immense doors of possibility for anyone who needs to extend...
11How-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.
2How-To Develop Excel Interop Applications with C# | Visual Studio Tools for Office | VSTO
This article demonstrates how to use C# to interact with the different sheets and workbook in an Excel 2007 application.
- 0
T-SQL (Transact-SQL) | MERGE (Inserting and Updating) | SQL Server
Tutorial and example on how to use the Merge function in Transact-SQL to perform inserts and updates.
0Excel and SQL Server Integration using OLEDB
Configure oledb (Microsoft.ACE.OLEDB.12.0) in SQL Server and use OPENROWSET to insert and select data in Excel 2007 and 2010
- 4
How-To Get First Day of the Month Using T-SQL (Transact-SQL)
This function gets the first day of the month. I use it a lot in my Select and Where clauses. I also use it to set parameters or variables. It is just one of those really useful functions that saves a lot of time. If I use this date as an example :...
- 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
T-SQL | How To Create Function to Get Date of Last Day of 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.
0How-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)
- 2
How To Install and Setup FluorineFX in Visual Studio 2008
The documentation on FluorineFX site is geared towards VS2005. FluorineFX doesn't behave the same way with VS2008. This article shows you how.
4How-To Develop CrossTab Queries in T-SQL(Transact-SQL) with Dynamic Columns
This articles provides examples on how to use the pivot function in t-sql, dynamic sql and xml to create dynamic (programmatic) columns in a cross tab or pivot query similar to olap.
0Blazeds Configuration on Apache Geronimo Web Server | Tutorial | Sample App
Setup Adobe Blazeds on Apache Geronimo Web Server to build Adobe Flex (Flash) applications.
