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

Java Cinema/Theatre Reservation System

Submitted by javalearner on
Hello All, I would like a JAVA source code to a cinema/theatre reservation system that allows a customer to make a booking to view a movie, select the seating in the cinema room, and also be able to cancel a booking as well. The cinema reservation system must be able to allow an assigned manager to make updates to bookings. The cinema reservation system I want is very much similar to a hotel
Subscribe to