Feeds:
Posts
Comments

Archive for October, 2008

hi the main Query to get sequence number is follow

select JOB_ID_SEQ.NEXTVAL from dual;

i get the required Sequence number value form following method

public int GetOracleSequenceValue(string _SequenceValue)
{
OdbcCommand _command = new OdbcCommand();
[...]

Read Full Post »

hi use this regular expression for email address validation
^[A-Za-z0-9](([_\.\-]?[a-zA-Z0-9]+)*)@([A-Za-z0-9]+)(([\.\-]?[a-zA-Z0-9]+)*)\.([A-Za-z]{2,})$
Regular expression validator in asp.net would be like
Chears…

Read Full Post »

Main hoon naa

Read Full Post »

use follwing Code change image path at load event method for downloading Code

Imports System
Imports System.Drawing
Imports System.Drawing.Imaging
Imports System.Drawing.Drawing2D
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim WorkingDirectory As String = “c:\AliPicture”
‘create a image object containing a verticel photograph
Dim imgPhotoVert As Image = Image.FromFile(WorkingDirectory + “\pravs-j-the-first-step.jpg”)
Dim imgPhoto As Image = Nothing
imgPhoto = [...]

Read Full Post »

Pl Sql Built in Functions

hi find these build in function for orcale pl sql , These are really usefull

Function
Description

String Functions

upper(s), lower(s)
convert string s to upper/lower-case

initcap(s)
capitalise first letter of each word

ltrim(s), rtrim(s)
remove blank char. from left/right

substr(s,start,len)
sub-string of length len from positionstart

length(s)
length of s

Date Functions

sysdate
current date (on Oracle server)

to_date(date, format)
date formatting

Number Functions

round(x)
round real number x to integer

mod(n,p)
n modulus p

abs(x)
absolute value of x

dbms_random.random()
generate a random integer

Type Conversion Functions

to_char()
convert to string

to_date()
convert to date

to_number()
convert to [...]

Read Full Post »

Composition and Aggregation are basically whole/part relationship.
When the lifetime of the part is dependent on or controlled by the whole, the relationship between the whole and part is Composition. 
Which simply means that the part is no more existing when the whole is destroyed.
example : car and engine.
Aggregation : 
When the lifetime of the part is not [...]

Read Full Post »