IIS Server Installation on Windows 7

1. Open Control Panel  –> Choose Programs and Features

2. On the top of the left hand side pane, you can find Turn Windows features on or off. Click that option.

3. Expand Internet Information Services and check all the options. Make sure all the options are checked with Tick Mark. 

 

4. And Click OK Button. It will take some time install IIS Server on your machine.

5. Finally to check whether the IIS is installed on your machine, follow the instructions given below.

i.    Open the Browser

ii.    Type “http://localhost” on the Address Bar.

iii.    If you can see the following screen, then the IIS Server is successfully installed on your machine.

6. To open IIS Management Console, type inetmgr in Run Prompt.

7. IIS Server Management Console will appear as given in the following screen.

8. We should configure the website on this IIS Server Console, for the web application deployment. I will post the steps in another post guys.

---

 

Wish You All Success!!! ~ Jeyakumar Kandasamy

---

Can we have two main() methods in a Java Program

Hi…Greetings to Everyone!!!!

I am Jeyakumar.K, Asst. Professor, Dept. of CSE, Kumaraguru College of Technology-Coimbatore.  Here I am gonna discuss about calling main() from another main() in a single Java Program.

Don’t be too much surprised guys. Yes we can use two main() methods in a same program but not in the same class. But however, any one main() method would be the starting point of the program execution.

For Example:

import java.lang.*;

class SampleClassOne

{

public static void main(String[] args)

{

System.out.println(“SampleClassOne main() method is the starting point of Program Execution…”);

//To call another main() method

String[] strArray={“Java”,”Program”,”With”,”Two”,”Main”,”Methods”};

SampleClassTwo.main(strArray);

}

}

class SampleClassTwo

{

public static void main(String[] arg)

{

System.out.println(“\nSampleClassTwo main() method act like a normal method of the class…\n”);

for(int i=0;i<arg.length;i++)

{

System.out.println(arg[i]);

}

}

}

Execution Procedure:

— Save the above program in your local drive as SampleClassOne.java

— Compile the program by using: javac SampleClassOne.java

— Run the program by using: java SampleClassOne

— Then the output will be:

So Guys!!! Just go through the article alone is not enough…. Please try it out and Wish you all good luck!!!! ~ Jeyakumar.K

“Education is learning what you didn’t even know you didn’t know.~Daniel J Boorstin”

Java Program without main() method

Hi Friends….Greetings to Everyone….

Can we able to write and execute a java program without writing a main() method? Any guesses….?

Yes friends…Its possible with the help of static block in java.

We all knew that, the heart and soul of the program execution is main() in java. But its true only in the case when you are not having static block in your java program.

Because static block of statements are getting executed at the first instant by the Java Interpreter.

For Example – Program with both static block and main():

class StaticBlockDemo
{
//Static Block Definition
static
{
System.out.println(“Statements inside Static Block……”);
System.out.println(“Statements inside Static Block……”);
}//End of static block

public static void main(String[] args)
{
System.out.println(“You are in Main Function – Starting Point of Program Execution”);
}
}//End of class

When you are executing the above program, you can find that static block of statements getting executed first and then the main() method starts its execution.

Java Program: Without writing main()

import java.lang.*;  //Optional
class StaticBlockWithoutMainDemo
{
//Static Block Definition
static
{
System.out.println(“Statements inside Static Block……”);
System.out.println(“Statements inside Static Block……”);
System.exit(0);
}//End of static block
}//End of class

Save the above program with StaticBlockWithoutMainDemo.java in your local drive.Then compile and run the program in a normal way.

Thank You Friends!!!

 

DBMS Concepts General Introduction

Hi Friends!!!Greetings to Everyone!!!!

I am posting this general introduction about the ADO.NET concepts in short description, based on .NET point of view.

IDE Used:
–Microsoft SQL Server 2005/2008

Introduction:
–File System Concepts — Drawback is Redundancy Problem
–DBMS Concept is evolved.

General Phenomenon:

• Relation Schema — refers to the tables
• Record — value of particular field
• RecordSet — Entire row values of particular tuple
• Attribute — refers to the column
• Tuple — refers to the row values
• Instance  — refers to the database object or instance

Main Properties of DBMS:
A – Atomicity   — Either all transactions or none of the transactions executed
C – Consistency —  Updates has to be done parallel
I – Isolation  — All the transactions executed as an isolated manner [Separate]
D – Durability — Once the changes has been made, it cant be undone

CRUD Operations:
C- CREATE
R – RETRIEVE [SELECT]
U – UPDATE
D – DELETE

Statements in ADO.NET:
1. DDL [Data Definition Language]
2. DML [Data Manipulation Language]
3. DCL [Data Control Language]
4. TCL [Transaction Control Language]
5. DQL [Data Query Language]

DDL Statements:

• Statements which are affecting the physical structure of database objects.

Example:

CREATE
DROP
TRUNCATE
ALTER

DML Statements:

• Statements which are performing manipulations of records on the database objects.

Example:

INSERT
UPDATE
DELETE

DQL Statements:

• Statements which are retrieving the recordset values from database objects.

Example:

SELECT

DCL Statements:

• Statements that are used to set and reset the access privileges.

Example:

GRANT

REVOKE

TCL Statements:

• Statements that are used to perform operations based on the transactions.

Example:

COMMIT

ROLLBACK

SAVEPOINT

Constraints:

1. Key Constraint

—Super Key — Combination of fields which are having ability to become primary key
—Candidate Key — Minimal subset of super key is called as candidate key
—Primary Key — One from candidate key is called as primary key
–which is used to uniquely identify the recordset
—Alternate or Secondary Key — Remaining in the candidate keys [Candidate Key – (Minus) Primary Key]
—Composite Key — [Super Key-Candidate Key]
—Foreign Key — Primary key of another table

2. Not Null Constraint — will not allow null values, but will allow the duplicate values.

3. Unique Constraint — will not allow duplicate values, but will allow the null value once.

4. Check Constraint — will check the values to be in the specified range. Example: For Gender, only the possible values are Male/Female. Check Constraint will not allow any other values.

5. Default Constraint  — If the value is not supplied while inserting a column values, default value will be inserted.

HTMLEditorExtender Control in ASP.NET

Hi Friends. Greetings to everyone!!!!

When I was in my client’s place, I was having problems when adding HTMLEditorExtender control. That’s why I am posting the solution with successful one after trying number of times.

• Download the file AjaxControlToolkit.Binary.NET4 from Internet. You can dowload from http://ajaxcontroltoolkit.codeplex.com/releases/view/43475
• Remove the previously added AjaxControlToolkit.dll from the references of your asp.net web application if exists.
• Then add the reference of the downloaded AjaxControlToolkit.dll and the following dll’s under SanitizerProviders folder: SanitizerProviders.dll, HtmlAgilityPack.dll.
• Wherever you want the HTMLEditorExtender add the following lines of code in your *.aspx page:

Add the following  below your page directive <%@Page..%> tag:

<%@ Register Assembly=”AjaxControlToolkit” Namespace=”AjaxControlToolkit” TagPrefix=”ajax” %>

Add the following wherever you want the HTMLEditorExtender on your aspx page:

<asp:TextBox runat=”server” ID=”TextBoxCommitment” TextMode=”MultiLine” Columns=”50″ Rows=”10″ Width=”98%” BackColor=”White”/>
<ajax:HtmlEditorExtender ID=”HtmlEditorExtender1″ TargetControlID=”TextBoxCommitment” DisplaySourceTab=”true” runat=”server”>
<Toolbar>
<ajax:Undo />
<ajax:Redo />
<ajax:Bold />
<ajax:Italic />
<ajax:Underline />
<ajax:StrikeThrough />
<ajax:Subscript />
<ajax:Superscript />
<ajax:JustifyLeft />
<ajax:JustifyCenter />
<ajax:JustifyRight />
<ajax:JustifyFull />
<ajax:InsertOrderedList />
<ajax:InsertUnorderedList />
<ajax:CreateLink />
<ajax:UnLink />
<ajax:RemoveFormat />
<ajax:SelectAll />
<ajax:UnSelect />
<ajax:Delete />
<ajax:Cut />
<ajax:Copy />
<ajax:Paste />
<ajax:BackgroundColorSelector />
<ajax:ForeColorSelector />
<ajax:FontNameSelector />
<ajax:FontSizeSelector />
<ajax:Indent />
<ajax:Outdent />
<ajax:InsertHorizontalRule />
<ajax:HorizontalSeparator />
<ajax:InsertImage />
</Toolbar>
</ajax:HtmlEditorExtender>

• Open your web.config file and do the following guidelines:

Add the following code below your <configuration> starting tag:

<configSections>
<sectionGroup name=”system.web”>
<section name=”sanitizer”
requirePermission=”false”          type=”AjaxControlToolkit.Sanitizer.ProviderSanitizerSection,AjaxControlToolkit”/>
</sectionGroup>
</configSections>

Add the following code under the <system.web>starting tag and </compilation> ending tag:

<sanitizer defaultProvider=”HtmlAgilityPackSanitizerProvider”>
<providers>
<add name=”HtmlAgilityPackSanitizerProvider” type=”AjaxControlToolkit.Sanitizer.HtmlAgilityPackSanitizerProvider” />
</providers>
</sanitizer>

• Build your application and run. The HTMLEditorExtender Control will be displayed on your web application.

Thank You!!! Your valuable comments would be really appreciated….