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 »
Posted in songs on October 9, 2008 | Leave a Comment »
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 »
Posted in PL Sql on October 8, 2008 | Leave a Comment »
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 »