Technical discussions about .NET and J2SE Concepts

.NET Concepts

IIS Server Installation on Windows 7

  1. Open Control Panel  –> Choose Programs and Features
  1. On the top of the left hand side pane, you can find Turn Windows features on or off. Click that option.
  1. Expand Internet Information Services and check all the options. Make sure all the options are checked with Tick Mark. 1

 

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

2

  1. 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.

3

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

4

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

5

  1. 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



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!!!!

Image

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….