Category Archives: Information Technology

My IT consulting fields.

Pattern search using SQL

Posted on by
Reply

Instead of exact matching, the following code allows you to do a pattern search by joining two table using like operator.

SELECT *
FROM Table1
INNER JOIN Table2 ON Table1.col LIKE '%' + Table2.col + '%'

GoDaddy SMTP Server

Posted on by
Reply

snippet of how to send email from within GoDaddy web hosting

mail.From = new MailAddress(fromAddress);
mail.To.Add(toAddress);
mail.Subject = subject;
mail.IsBodyHtml = true;
mail.Body = htmlconvert(bodytext);
 
//Connect to server and send message.
SmtpClient smtp = new SmtpClient();
smtp.Host = "relay-hosting.secureserver.net";
smtp.Send(mail);

PWSK- Handler.ashx

Posted on by
Reply

The Handler.ashx is used to dynamically return a image from a query string. Http handler is similar to regular web form, only faster (~10%, compare with web form) with less functionality.
IsReusable property is usually set to be true to reduce memory footprint and improve performance.
In the sample application pictures are taken from a database. If one prefer to use file system instead then the handler can be changed to.
HttpResponse r = context.Response;
r.ContentType = "image/png";
r.WriteFile("Logo1.png");