How to Read and Write XML File using VB.NET

Submitted by admin on
In this example you’ll learn on how to read and write into XML file using VB.NET. XML file is useful if you want to store simple data like storing database name and server information so that your application will remember what server and or database your program is connected in last session. An example of storing your database and server info: Where “server” is the name of your computer that run

File Upload using PHP

Submitted by argie on
In this code you will learn on how to upload and download file using php. The system has the capability to record the download details, such as the time and date of download, the person who download the file and automatically save directly to database. database name: br username: admin password: admin

Invalid object name in Stored Procedure Alter Command

Submitted by admin on
If you are working with stored procedure using SQL Server Management Studio Tools (SSMS), you will encounter a problem (well, not really a problem) “ Invalid object name” on the name of your stored procedure. Please see screenshot below: This error is not made by SQL Server but rather by SSMS. The solution to this problem is to clear the intelliSense cache. Click on Edit menu => IntelliSense =>

Number Subsets Calculator in Java (Applet using AWT)

Submitted by onyx_ash08 on
Guys, here is a problem given to us by our professor during our class in Object-Oriented Programming. Here, I used the AWT library of Java to design the interface. Problem: Given an array containing some integers (there may be duplicates), write a routine or method that returns all the possible sums that can be formed by using numbers in the array. For instance, if the array contains 4 and 6, the

How to Cancel Delete in BindingNavigator

Submitted by admin on
When you add a DataSet to your Windows Form a BindingNavigator is automatically created with navigation to your record and it also includes Delete and Add button. When you click the Delete button there is no confirmation if you want to cancel the operation. The solution to this is to set the DeleteItem to None.

Decimal to Hexadecimal Conveter in Java (Console-Based)

Submitted by onyx_ash08 on
Hi guys! I'm here again. Today, I will show you a Java program I made that can convert a Decimal Number to its equivalent Hexadecimal Value. It is very easy to do this because I just followed the rules in converting from decimal to hexadecimal number in number system. Take note that there are 16 values or digits used in hexadecimal number system which is the number from 0 to 9, and the first six

Get the ID of Last Inserted Record in SQL Server

Submitted by admin on

Sometimes you need to know the value of your Primary Key when you insert record in your table. This is true if you have a Master/Detail form and you need to know the Primary key value of the parent table so that you can insert rows in the related table.

Consider the following scenario:

Sample Invoice with Master/Detail Form

Submitted by admin on
In this sample you’ll learn on how to save record programmatically using VB.NET. A DataGridView is used to save record in the related table. You will also learn on how to get the last value of the primary key in order to save the related record. This is a very simple program that can be used to expand your knowledge on database programming. I am using SQL Server Express 2008 for my database