Archive for August, 2008

C-sharp WebBrowser with progress bar

private void WebBrowser1_ProgressChanged(object sender, System.Windows.Forms.WebBrowserProgressChangedEventArgs e) {

ProgressBar1.Visible = (!(e.CurrentProgress<=0 || e.CurrentProgress==e.MaximumProgress));
if (ProgressBar1.Visible) {

ProgressBar1.Value = ((float)e.CurrentProgress/(float)e.MaximumProgress) * 100;
} else {

ProgressBar1.Value = 0;
}
}

Advertisements

August 13, 2008 at 1:04 pm Leave a comment

Sql fetch cursors

DECLARE
slip_Update CURSOR FOR
SELECT * FROM SlipsTEST, SlipdetailsTEST
WHERE SlipsTEST.SlipIdOld = SlipdetailsTEST.SlipIdOld
FOR UPDATE;
BEGIN
OPEN slip_Update;
FOR slip_Update IN slip_Update
LOOP
UPDATE SlipdetailsTEST
SET SlipdetailsTEST.SNO = SlipsTEST.SNO
WHERE CURRENT OF slip_Update;
END LOOP;
CLOSE slip_Update;
END;

August 13, 2008 at 12:59 pm Leave a comment

A smart join with union

SELECT m.MonthName, COALESCE(c.MonthCost, 0)
FROM CostTable c
RIGHT JOIN (
 SELECT 1 As MonthNumber, 'January' As MonthName
 UNION
 SELECT 2, 'February'
 UNION
 ...
 SELECT 3, 'December'
) m
ON m.MonthNumber = MONTH(c.[Month])

August 13, 2008 at 12:54 pm Leave a comment

Sql insert in Csharp

public int insertdata(string forname, string lastname, string email, DateTime birthdate, string country, string username, string pword)
        {

            String select = "select * from Player where username='" + username+"'";
            SqlCommand cmd = new SqlCommand(select, conn);
            conn.Open();
            SqlDataReader rows = cmd.ExecuteReader();

            if (rows.HasRows)
            {
                return -1;
            }
            conn.Close();
            String insert = "insert into player (forname,lastname,country,email,birthdate,username,password,lastlogin) values (@forname,@lastname,@country,@email,@birthdate,@username,@password,@lastlogin)";

            cmd = new SqlCommand(insert, conn);
            cmd.Parameters.Add("@forname", System.Data.SqlDbType.VarChar).Value = forname;
            cmd.Parameters.Add("@lastname", SqlDbType.VarChar).Value = lastname;
            cmd.Parameters.Add("@country", SqlDbType.VarChar).Value = country;
            cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = email;
            cmd.Parameters.Add("@birthdate", SqlDbType.DateTime).Value = birthdate;
            cmd.Parameters.Add("@username", SqlDbType.VarChar).Value = username;
            cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = pword;
            cmd.Parameters.Add("@lastlogin", SqlDbType.DateTime).Value = DateTime.Now;

            conn.Open();
            int numRows = cmd.ExecuteNonQuery();
            conn.Close();
            if (numRows == 1)
            {

                return 0;
            }
            else
            {

                return -2;
            }

        }

August 13, 2008 at 12:51 pm Leave a comment

Php script for email form

<?php
$fileatt
= ""; // Path to the file
$fileatt_type = "application/octet-stream"; // File Type
$fileatt_name = ""; // Filename that will be used for the file as the attachment

$email_from = “”; // Who the email is from
$email_subject = “”; // The Subject of the email
$email_message = “”; // Message that the email has in it

$email_to = “”; // Who the email is too

$headers = “From: “.$email_from;

$semi_rand = md5(time());
$mime_boundary = “==Multipart_Boundary_x{$semi_rand}x”;

$headers .= “\nMIME-Version: 1.0\n” .
“Content-Type: multipart/mixed;\n” .
” boundary=\”{$mime_boundary}\””;

$email_message .= “This is a multi-part message in MIME format.\n\n” .
“–{$mime_boundary}\n” .
“Content-Type:text/html; charset=\”iso-8859-1\”\n” .
“Content-Transfer-Encoding: 7bit\n\n” .
$email_message . “\n\n”;

/********************************************** First File ********************************************/

$fileatt = “”; // Path to the file
$fileatt_type = “application/octet-stream”; // File Type
$fileatt_name = “”; // Filename that will be used for the file as the attachment

$file = fopen($fileatt,‘rb’);
$data = fread($file,filesize($fileatt));
fclose($file);

$data = chunk_split(base64_encode($data));

$email_message .= “–{$mime_boundary}\n” .
“Content-Type: {$fileatt_type};\n” .
” name=\”{$fileatt_name}\”\n” .
//”Content-Disposition: attachment;\n” .
//” filename=\”{$fileatt_name}\”\n” .
“Content-Transfer-Encoding: base64\n\n” .
$data . “\n\n” .
“–{$mime_boundary}–\n”;
unset(
$data)
unset(
$file)
unset(
$fileatt)
unset(
$fileatt_type)
unset(
$fileatt_name)

/********************************************** Second File ********************************************/

$fileatt = “”; // Path to the file
$fileatt_type = “application/octet-stream”; // File Type
$fileatt_name = “”; // Filename that will be used for the file as the attachment

$file = fopen($fileatt,‘rb’);
$data = fread($file,filesize($fileatt));
fclose($file);

$data = chunk_split(base64_encode($data));

$email_message .= “–{$mime_boundary}\n” .
“Content-Type: {$fileatt_type};\n” .
” name=\”{$fileatt_name}\”\n” .
//”Content-Disposition: attachment;\n” .
//” filename=\”{$fileatt_name}\”\n” .
“Content-Transfer-Encoding: base64\n\n” .
$data . “\n\n” .
“–{$mime_boundary}–\n”;
unset(
$data)
unset(
$file)
unset(
$fileatt)
unset(
$fileatt_type)
unset(
$fileatt_name)

/********************************************** End of File Config ********************************************/

// To add more files just copy the file section again, but make sure they are all one after the other! If they are not it will not work!

$ok = @mail($email_to, $email_subject, $email_message, $headers);

if($ok) {
echo
“<font face=verdana size=2>The file was successfully sent!</font>”;
} else {
die(
“Sorry but the email could not be sent. Please go back and try again!”);
}
?>

August 13, 2008 at 12:45 pm Leave a comment


August 2008
M T W T F S S
« Jul   Sep »
 123
45678910
11121314151617
18192021222324
25262728293031