Detecting and Deleting Duplicate Records in SQL Server 2005 and Above

Submitted by tamizhventhan on
Most of the time, we encounter duplicate records in our database. And it's not easy to delete it if you don't have enough knowledge about SQL Statement. This code will help you detect and delete duplicate records in SQL Server 2005 and above. (These commands only works on sql server 2005 or higher) Create table create table example(id int identity(1,1),name varchar(20),class varchar(20)); (Here

Converting Java Applet to Application

Submitted by mehfuza on
Applets are programs which run on web browser and Application means the stand alone program in a computer. In Java we can convert Applets to Application and Application to Applet. Using this idea we can make any program run as either applet or as an application. Following are the steps for converting applets to Application. Step 1: Change init() method's name to the constructor. Java Applets contains init() method which is used for initializing the applet, this method should be changed to constructor for that class.

Part IV: Improving of Code using Modules in Visual Basic.Net

Submitted by joken on
This tutorial is a continuation of Part III: Update and Delete Specific Data in MySQL Database using Visual Basic. Net. But this time we're going to focus on how we can improve the design of our existing code using Code Refactoring. Refactoring is the process of changing a software system in such a way that it hasn't altered the external behavior of the code, yet improves its internal structure.

Creating simple Calculator in Java

Submitted by mehfuza on

Introduction

This tutorial is about creating simple calculator which performs only four operations. For creating a simple Calculator we require two JTextFields where the user can enter two numbers, four JButton for four operations namely addition, subtraction,multiplication and division, a JLabel for displaying the result.

Implementation

Step 1: Creating a class which extends JFrame because we are going to create an Application. After this we have to define the constructor of the class as follows. Super() is used to give title to the frame.

Part III: Update and Delete Specific Data in MySQL Database using Visual Basic.Net

Submitted by joken on
In this lesson we will focus on completing the user CRUD tutorial or the Create, Read, Update and Delete user. So to start with, Open our last tutorial called "Part II: Inserting and Reading of Data in MySQL Database Using Visual Basic.Net" and select the Manage User form and add two buttons in it.

Visual Basic Proxy Checker

Submitted by Yorkiebar on
Introduction: This tutorial will be on how to create a proxy checker which will test a list of proxies and report if they respond within 3000ms/3seconds (can be changed using .Timeout). Steps of Creation: Step 1: First we will need to Import two packages, one to use StreamReader and StreamWriter and another to use HttpWebRequest and HttpWebResponse

Oracle Released MySQL Workbench 6.0

Submitted by navajocodetalker on
The world's leading software company Oracle has released a new version of MySQL Workbench with a revamped user interface and more database management support. The new MySQL Workbench 6.0 combines data modeling, SQL development, and server administration tools. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. It also supports