Contoh Database, C++, visual basic, java: 2011

Wednesday, October 12, 2011

Function AccessShowReport

The function below can be used to preview a report created in MS Access. 'Purpose : Preview an Access Report from VB 'Inputs : sAccessDBPath The path and filename of the access database containing the report to show ' ...

Monday, August 29, 2011

Connection Type

Microsoft Excel is a component of MS Office application, which is useful to create spreadsheet. This Office utility is fruitful to create and maintain huge lists easily and effortlessly. It is used for storing contacts, doing statistical analysis, performing...

SQL ODBC connection

SQL ODBC connection stringsStandard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Uid=Your_Username;Pwd=Your_Password;" Trusted connection:< br> "Driver={SQLServer};Server=Your_Server_Name;Database=Your_Database_Name;Trusted_Connection=yes;"...

Sunday, August 28, 2011

SQL Functions

SQL Functions Keyword DescriptionCreate Function Ext_Orders(parmWhere CHAR(5)) CREATE FUNCTION names the UDTF and registers it with SQL. This function is called Ext_Orders (external orders). This name will be referenced by SQL statements using the function. You...

C, C++ and Java Assignment Operators

C, C++ and Java Assignment Operators = -- simple assignment += -- add rhs, then assign to lhs -= -- subtract rhs, then assign to lhs *= -- multiply by rhs, then assign to lhs /= -- divide lhs by rhs, then assign to lhs &= -- bitwise and, then...

import java.sql

import java.sql.*; public class DataTransfer { private static String[] tableNames = new String[]{"SOME_TABLE_NAME"}; private static final int FETCH_SIZE = 100; public static void main(String[] args) throws ClassNotFoundException, SQLException { Connection...

Tuesday, August 23, 2011

Simple Database

A Simple Database Backup: You can use mysqldump to create a simple backup of your database using the following syntax. mysqldump -u [username] -p [password] [databasename] > [backupfile.sql] [username] - this is your database username [password]...

Central Management Service

The CMS store is used by the Central Management Service to maintain a current Lync Server 2010 Topology for the entire Lync deployment (Topology, Policies, Voice Routes, etc…). Here is what you need to know about the CMS: The database used for this purpose...

Tuesday, August 16, 2011

Visual Basic

Visual Basic is an event-driven language. So, when you talk about events, we're talking about things that happen in the program which cause little events to occur (similar idea to IRQ stuff you learned hopefully in 455). An example of this could be clicking...

Tuesday, August 9, 2011

SQL (Structured Query Language)

SQL (Structured Query Language) is a computer language aimed to store, manipulate, and query data stored in relational databases. The first incarnation of SQL appeared in 1974, when a group in IBM developed the first prototype of a relational database....

Friday, July 29, 2011

Java database applications

This tutorial only shows briefly the steps the construction of Java database applications that connect to the MySQL server. To be able to connect to MySQL from Java is necessary JDBC driver for MySQL. Please download at the website mysql.com, obtained...

Monday, July 11, 2011

Microsoft Visual C++

Steps to create DLL The following steps illustrate how to create a Microsoft Visual C++ DLL project and then add and export the talkToObject() routine. Create a new Microsoft Visual C++ 5.0 "MFC AppWizard (dll)" project named "vcvbdll" and accept...

void

Visual Basic is a programming language. It started out as a very simple one (called BASIC) in the days of dos and early windows/macs. As it evolved, and other languages were developed, it was usually relegated to first-time programmers. It is still recommended...

Visual C++

Instructions Now, let's go to work. Please follow the following steps: (Please skip the steps 1 to 8 if you don't have Visual C++ installed on your computer) Click Start, if you have Windows 9x, click Programs, and if you have Windows XP, click All...

Sunday, July 10, 2011

CGI programming

CGI or Common Gateway Interface is a means for providing server-side services over the web by dynamically producing HTML documents, other kinds of documents, or performing other computations in response to communication from the user. In this assignment,...

Sunday, July 3, 2011

Visual Basic 6

Public Function getAgePhrase(ByVal age As Integer) As String If age > 60 Then Return "Senior" If age > 40 Then Return "Middle-aged" If age > 20 Then Return "Adult" If age > 12 Then Return "Teen-aged" If age > 4 Then Return "School-aged" If...

Monday, June 13, 2011

Visual Basic

HTML server controls are of two slightly different types. The HTML elements most commonly used in forms are available as individual HTML server controls, such as HtmlInputText, HtmlInputButton, HtmlTable, and so on. These HTML server controls expose...

Monday, June 6, 2011

procedure is a block of program code designed to solve common problems

procedure is a block of program code designed to solve common problems. Suppose the pascal programming language known as Writeln procedures, clrscr, textbackground, textcolor, readln, etc.. The invitation to these procedures vary from one procedure to...

Pascal triangle

Pascal triangle shape can be arranged as below: 1 121 1331 14641 15101051 ................ To facilitate understanding of each element of the above can we put in the matrix as follows: - Number 1 in row 1 column 1 - Number 1 in row 2 column 1, number...

The data type is a limit value that can be saved

The data type is a limit value that can be saved. In MS-Access there are different kinds of data types include: - Byte - Integer - Text - Date / Time - Number Suppose you want to keep track student's name. Names of the students to like "Rita", "Ahmad...

Arithmetic Statement

Arithmetic Statement Unknown 3 (three) pieces of numbers A, B and C. Make a visual basic program to solve the following arithmetic equation: P = A + B Q = B-A X = A + BC R = (A + B) * C S = (A + B) * (A-C) M = A Mod 2 N = B-A + C ^ 2 - user interface...

Arithmetic operations

Arithmetic operations Arithmetic operation is an operation involving arithmetic operators. Arithmetic Operators in Visual Basic is: - plus (+) - minus (-) - times (*) - for (/) - rank (^) - residual for (mod) Arithmetic operators generally operate...