Ali Raza Zaidi Blog

how to get year from date in pl sql

how to get year from date in pl sql

pl Sql has function “Extract” this functions works wonders. I used it at many places in my application , i write some samples here Years select EXTRACT(YEAR FROM DATE ‘2008-3-17’)YEAR from dual; Months select...

how to send mail smtp with authentication with web.mail class

how to send mail smtp with authentication with web.mail class

hi i used following code MailMessage message = new MailMessage(); message.To = “myemailaccount@yahoo.com”; message.From = “myemailaccount@thecrystalrosary.com”; message.Subject = “Testing Internet SmtpMail”; message.BodyFormat = MailFormat.Html; message.Body = “body”; message.Fields.Add(“http://schemas.microsoft.com/cdo/configuration/smtpserver”, “smtp.thecrystalrosary.com”); message.Fields.Add(“http://schemas.microsoft.com/cdo/configuration/smtpserverport”, 25); message.Fields.Add(“http://schemas.microsoft.com/cdo/configuration/sendusing”, 2); //2...

How to resize image in .net

How to resize image in .net

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

Pl Sql Built in Functions

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

Composition and Aggregation in oops

Composition and Aggregation in oops

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