Thursday, December 30, 2010

Difference between T SQL and PL SQL

*

SQL is a query language to operate on sets.

It is more or less standartized, and used by almost all relational database management systems: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Informix, etc.

* PL/SQL is a proprietary procedural language used by Oracle
* TSQL is a proprietary procedural language used by Microsoft in SQL Server.

Procedural languages are designed to extend the SQL's abilities while being able to integrate well with SQL.

They are used to write stored procedures: pieces of code residing on the server to manage complex business rules that are hard or impossible to manage with pure set-based operations.

Procedural Language/Structured Query Language

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension language for SQL and the Oracle relational database.

You can find more info about PL SQL in bellow link:

http://plsql-tutorial.com/

Thursday, December 23, 2010

Validating User Input in ASP.net

* All validation controls are derived from the BaseValidator class
* Validation controls always perform validation checking on the server
* Validation controls also have complete client side implementation that allows browsers that support DHTML to perform validation on the client

Validation controls are:-
RequiredFieldValidator Control
CompareValidator Control
RangeValidator Control
RegularExpressionValidator Control
CustomValidator Control
ValidationSummary Control

ASP.net Web Forms Components

ASP.net Web Forms Components Consists of
User interface (.aspx extension)
Programming Logic (.aspx.cs or .aspx.vb)

Web Forms server controls:-
HTML server controls
HTML elements that can be used in server code
ASP.NET server controls
Traditional form controls
Validation controls
Used to validate user’s input
User controls
Created from existing Web Forms pages and can be used in other Web Forms pages

ASP.NET Web Forms

* Used to create programmable Web pages that are
Dynamic
Fast
Interactive
* Browser independent
* Designed using RAD tools
* Support rich set of controls and are extensible
* Any of the .NET Framework language can be used to program the ASP.NET Web Forms page
ASP.NET uses the Common Language Runtime of the .NET Framework

Advantages of ASP.net

Advantages:-
* Simplifies Web Application Development
* Improved Performance
* Flexibility
* Configuration Settings (xml format)
* Security

Introduction to ASP.net

Introduction:-
* Next Version of ASP
* A programming framework, used to create enterprise-class Web applications
* Integrated with Visual Studio .NET, which provides a GUI designer, a rich toolbox, and fully integrated debugger
* Unlike the ASP runtime, ASP.NET uses the Common Language Runtime provided by the .NET framework

Tuesday, December 21, 2010

Calculator code in C# sharp

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
bool plus = false;
bool minus = false;
bool multiply = false;
bool devide = false;
bool equal = false;
public Form1()
{
InitializeComponent();
}

private void button5_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 4;
}

private void button1_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 7;
}

private void button3_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 9;
}

private void button4_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
return;
}
else
{
devide = true;
textBox1.Tag = textBox1.Text;
textBox1.Text = "";
}
}



private void button6_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 5;
}

private void button9_Click(object sender, EventArgs e)
{
checkifequal();


textBox1.Text = textBox1.Text + 1;

}

private void checkifequal()
{
if (equal)
{
textBox1.Text = "";
equal = false;
}
}

private void button10_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 2;
}

private void button11_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 3;
}

private void button7_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 6;
}

private void button2_Click(object sender, EventArgs e)
{
checkifequal();
textBox1.Text = textBox1.Text + 8;
}

private void button15_Click(object sender, EventArgs e)
{
if (textBox1.Text.Contains("."))
{
return;
}
else
textBox1.Text = textBox1.Text + ".";
}

private void button16_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
return;
}
else
{
plus = true;
textBox1.Tag = textBox1.Text;
textBox1.Text = "";
}
}

private void button14_Click(object sender, EventArgs e)
{
equal = true;
if (plus)
{
decimal dec = Convert.ToDecimal(textBox1.Tag) + Convert.ToDecimal(textBox1.Text);
textBox1.Text = dec.ToString();
}
if (minus)
{
decimal dec = Convert.ToDecimal(textBox1.Tag) - Convert.ToDecimal(textBox1.Text);
textBox1.Text = dec.ToString();
}
if (multiply)
{
decimal dec = Convert.ToDecimal(textBox1.Tag) * Convert.ToDecimal(textBox1.Text);
textBox1.Text = dec.ToString();
}
if (devide)
{
decimal dec = Convert.ToDecimal(textBox1.Tag) / Convert.ToDecimal(textBox1.Text);
textBox1.Text = dec.ToString();
}
}

private void button12_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
return;
}
else
{
minus = true;
textBox1.Tag = textBox1.Text;
textBox1.Text = "";
}
}

private void button8_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
return;
}
else
{
multiply = true;
textBox1.Tag = textBox1.Text;
textBox1.Text = "";
}
}

private void button18_Click(object sender, EventArgs e)
{
plus = minus = multiply = devide = false;
textBox1.Text = "";
textBox1.Tag = "";
}


}

}

Login Program In c# sharp

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplicationLogin
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "Username" && textBox2.Text == "Password")
{
MessageBox.Show("Correct");
}
else
MessageBox.Show("Invalid");
}
}
}

Wednesday, December 15, 2010

Sri Annapurna Ashtakam :-Nithyaananda kari,Varaa abhya karee Lyrics

Nithyaananda kari,Varaa abhya karee,
Soundarya rathnaakaree,
Nirddhotahakila ghora pavaanakaree,
Prathyaksha Maheswaree,
Praaleyachala vamsa pavavakaree,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree.

Naana rathna vichitra bhooshana karee,
Hemaambaradambaree,
Mukthaa haara vilamba maana vilasa,
Dwakshoja kumbaan dharee,
Kasmeera garu vasithaa ruchi karee,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree


Yogaanandakaree ripu kshyakaree,
Dharman artha nishtaakaree,
Chandrarkaanala bhasa maana laharee,
Trilokya rakshaa karee,
Sarvaiswarya samastha vaanchithakaree,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree

Kailaasaachala kandharaa laya karee,
Gowree , umaa sankaree,
Kaumaree nigamartha gochara karee,
Omkara beejaksharee,
Moksha dwaara kavata patana karee,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree






Drusyaa drusya vibhootha vahana karee,
Brhmaanda bhando dharee,
Leelaa nataka suthra kelana karee,
Vijnana deeptham guree,
Sree viswesa mana prasaadhana karee,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree

Urvee sarva janeswaree bhagawathee,
Maatha krupaa sagaree,
Venee neela samaana kunthala dharee,
Ananda dhaneswaree,
Sarvanandakaree bhayaa shubhakaree,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree






Aadhi kshaantha samastha varna nikaree,
Shabho tribhaava karee,
Kasmeeraa tripureswaree trilaharee,
Nithyaamakuree sarvaree,
Kamaa kamksha karee janodhaya karee,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree

Devee sarva vichitra rathna rachithaa,
Dakshayanee sundaree,
Vama swadu payodhara priyakaree,
Sownhagya maaheswaree,
Bhakthaabhishtakaree, sadaa shubhakaree,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree






Chandrakaanala koti koti sadrusaa,
Chandramsu bhimbaan dharee,
Chandrakaagni samaana kunthala dharee
Chandrarka varneshwaree,
Maala pustaka pasasangusa dharee,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree

Kshatrathraanakaree, mahaa bhayakaree,
Mthaa krupaa sagaree,
Sakshaan mokshakaree sadaa shiva karee,
Visweshwaree sridharee,
Daksha krundha karee niraa mayakaree,
Kasi puraadheeswaree,
Bhikshaam dehi, krupaa valambana karee,
Mathaa Annapurneswaree






Annapurne sadaa purne,
Sankara praana vallabhe,
Jnana vairagya sidhyartham,
Bikshaa dehee cha parvathy.

Mathaa cha Parvathy Devi,
Pithaas cha Maheswara
Bandhawa Shiva Bhakatamscha,
Swadesho Bhuvana Trayam.

Sunday, December 12, 2010

Program to Display current Date and time

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DateandTime
{
public class Time
{
public void DisplayCurrentTime()

{
Console.WriteLine("{0}/{1}/{2} {3}:{4}:{5}", Month, Date, Year, Hour, Minute, Second);

}
//declaring constructor
public Time(System.DateTime dt)
{
Year = dt.Year;
Month = dt.Month;
Date = dt.Day;
Hour = dt.Hour;
Minute = dt.Minute;
Second = dt.Second;
}
int Year, Month, Date, Hour, Minute, Second;
}
public class tester
{
static void Main()
{
System.DateTime currentTime = System.DateTime.Now;
Time t = new Time(currentTime);
t.DisplayCurrentTime();
}
}
}

Life Insurance quotes

Everyone needs life insurance today to protect him or her as well as all family members financially. Therefore, life insurance should be designed in order to be able to accommodate the needs of all people from any socio economic level. It means that life insurance should offer the most affordable premium rate. Anyway, as customers, we should not wait for until they lower the premium rate.

Requesting life insurance quotes from several life insurance companies can give the best choice because we can compare them before we buy their life insurance policy. For those of you who stay in Australia, www.xlife.com.au can help you get the life insurance quotes from top life insurance companies.

Monday, December 6, 2010

Guide to eating from a banana leaf


It’s interesting how a simple banana leaf, most commonly used in India by Hindus to serve food and globally by the Filipinos and some Buddhist cultures, lends an air of celebration akin to finery worn on special occasions. In fact, many a times the banana leaf is also used for cooking. Rice, meat or dough is wrapped in the leaf and steamed or cooked on low flame. This is very common in Kerala, Thailand, Caribbean islands and other coastal countries across the world.

Those who have been brought up in traditional South Indian homes would be quite familiar with the usage of this ubiquitous leaf. But for tourists who have never tried this before, eating from a banana leaf could be a cultural extravaganza. So here’s a guide to those unaware on why and how to eat from a banana leaf.

Whys
• Hot food served on a banana leaf takes nutritional and medicinal values of the banana tree.
• Eating from a banana leaf is like eating on a fresh plate for each meal.
• The leaf is bio-degradable unlike plastic plates.
• Ghee and oil do not stick to the banana leaf and so enjoying their flavors is easier.

Dos and Don’ts
• Place the leaf in such a way that the broader side of the leaf is the lower part. It gives you a wider space for more items.
• Sprinkle water on the leaf and wipe the leaf before you start.
• Don’t begin eating as soon as the food is served. Wait to start together with others.
• In India, meals are served on a banana leaf in a particular order starting with the daal, sambar, a kuzhambu (gravy either red gravy or coconut based), rasam (made with tamarind extract, tomato and pepper), curds and payasam (sweet kheer) afterwards. This order though basic might vary in different regions.
• Your skills are best tested when trying to slurp the rasam or payasam with your fingers / palms. You should not let this drip so it would be helpful to hold the lower part of the leaf slightly up.
• As this leaf is auspicious, don’t smoke or consume alcohol during a meal served on a banana leaf, especially if it is a special occasion.
• In some places, only vegetarian food is served on a banana leaf whereas in Tamil Nadu and Andhra Pradesh non-vegetarian is also served. So be aware of the customs of a community.
• Vegetables are placed on the top half of the leaf, and rice, sweets, and snacks on the other half.
• Avoid using cutlery while eating from a banana leaf. Eat with your fingers.
• It is not necessary to taste every dish served on the banana leaf, but you must finish everything as it is considered respectful.
• After finishing your meal, express appreciation for the meal.
• Using a finger bowl is not encouraged after a meal but now this is given for the sake of convenience in most restaurants. However, during weddings or functions at home, this is avoided.
• The banana leaf should not be left open after finishing the meal. It should be folded with the top half covering the bottom half which signifies that you have enjoyed your meal and you will visit again. If the bottom half is folded over the top, it is usually considered disrespectful as this is done only in solemn functions such as death.
• Do not leave the table until others have finished or until the host requests you to. If you must, ask permission from the host before leaving.

The next time you are in South India, try not to miss a celebration that gives you a chance to savor traditional South Indian food on a fresh banana leaf. But if there are no occasions during your visit, you can always try traditional South Indian eating joints in Chennai such as Amaravathi, Karaikudi, Zameendar, Anjappar, Saravana Bhavan, Ente Keralam etc. It’s an experience that you must try!