Visual Studio 2013 ~ C# and Microsoft Access | Add, Edit and Delete Functionality

I am refreshing my knowledge in C# and only to find out that the new Visual Studio is way too far from Visual Studio I used to work on during my college days.

Using Visual Studio 2013, and MS Access 2010, I created a 'Manage Customer Details' form where I can ADD, UPDATE and DELETE customer profile in / from the database.

Before I start my code snippets, here's the quick demo of the application.

Demo:

I'll gonna post some snippets later on this page in a few.

Read more

UFT Datatables | Accessing Datatables

In this blog, I am assuming that you have a background in Recording using Unified Functional Test (UFT). If you don't have any, you can always roam around google search and try to understand some.

First post I will be doing is about Data table. This is the collection of data you will be needing all throughout your automation testing and placed in a table form (exactly like excel sheet).

Simple and straightforward:

Figure 1.1 Getting the data from datatable

Figure 1.2 The actual datatable

Brief Explanation:

• Dim strFirstName : This is a variable declaration.
• ':' (colon) : This is denoting that the line after the colon (:) will be treated as the next line of code. This is the same when you write the code like the ff:

               

• DataTable("strFirstName",dtLocalSheet) : This is the syntax for the data retrieval. The first parameter is the data column name in the actual datatable (see Figure 1.2), the 2nd parameter specifies which Datatable are you referring (dtLocalSheet refers to the 'CodeSnippetsbyRain' sheet in Figure 1.2)

Data table contains two sheets, the Global Sheet where all actions in the same script can access, while the other is the Local Sheet, and only the action can access its own script.

Read more

Welcome to my Blog!

This blog is all about some helpful code snippets when it comes to programming. 

Just a disclaimer, I am not an expert of all programming languages, but I will be providing some snippets that is helpful in some ways.

Just a head's up, the code snippets that I will be providing is more on Automation Scripting specifically on Unified Functional Testing (UFT). I will also give some snippets on other languages like Java, PHP, VBScripts and C# (Visual Studio 2013)

Once again, WELCOME TO

Read more