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;
}
}
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;
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])
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; } }
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!”);
}
?>