System.Data.SqlClient.SqlException was unhandled - Timeout expired | Sync time between 2 systems using NET TIME command | Email chinese character - C# source code | What is RSS? | JayceOoi.com on the first page of Google!!! | Samsung announces NX10 camera with interchangeable lens system | Google's Chrome browser overtakes Apple's Safari | Google's New Year treat! | iPhone Outdoors: Ordnance Survey mapping for walkers | Welcome to the future: the flying car arrives!

System.Data.SqlClient.SqlException was unhandled – Timeout expired

Posted by Jayceooi
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.Do you face this error during SQL query in C#? Fear no more, my friend. All you need to do is put the timeout period more then default value – CommandTimeout. Follow the code below… SqlConnection EDCConnectionString = new SqlConnection(“ConnectionString”);
EDCConnectionString.Open();
string SQLTesterStats = “StoredProcedure”;
SqlCommand cmdTesterStats = new SqlCommand(SQLTesterStats, EDCConnectionString);
cmdTesterStats.CommandType = CommandType.StoredProcedure;
cmdTesterStats.Parameters.AddWithValue(“@s[...]
Continue Reading

Sync time between 2 systems using NET TIME command

Posted by Jayceooi
Below code will help to keep the time synchronized between 2 systems. Just open command prompt and run these code.net time \\TimeServer /set /yesReplace TimeServer with the system name that you want to sync. After running this command, your current system will follow the TimeServer’s time.Related topics:
Launch System Configuration Utility at Run – shortcut
Launch Remote Desktop Connection at Run – shortcut
Guide to change folder ownership[...]
Continue Reading

Email chinese character – C# source code

Posted by Jayceooi
Below is the source code that will send email in Chinese or other character than English.using System.Net.Mail;MailMessage oMsg = new MailMessage();
oMsg.From = new MailAddress(�Email�, �Name�);
oMsg.To.Add(new MailAddress(�Email�,�Name�));
oMsg.Subject = �subject�;
oMsg.Body = �Chinese character�;
oMsg.BodyEncoding = System.Text.Encoding.GetEncoding( “utf-8″ );
SmtpClient c = new SmtpClient(�SMTP�);
c.Send(oMsg);You can find more character set recognition at Microsoft page here.Related topics:
Send email with attachment c# source code[...]
Continue Reading

What is RSS?

Posted by Jayceooi
[...]
Continue Reading

JayceOoi.com on the first page of Google!!!

Posted by Jayceooi
Yeah… Finally, Jayce Ooi’s Paradise manages to get itself listed on the first page on Google when search using keyword – ‘jayce’. It started at page 6. Then after few weeks when I checked again. Jayce Ooi’s Paradise already reach 2nd page at 2nd place. Today, I checked again. It reach first page already!!! While 3rd page on MSN and 7th page on Yahoo. Thanks everyone that link to Jayce Ooi’s Paradise. It makes Jayce Ooi’s Paradise manages to be listed on Google first page. I will keep posting valuable post. Share knowledge that I have to everyone. Target == 1st place, 1st page on every search engine.
1st page on Google
3nd page on MSN
7th p[...]
Continue Reading

Samsung announces NX10 camera with interchangeable lens system

Posted by Wirefresh
Claiming to have the ‘heart of a DSLR embedded inside the compact frame of a digital camera’, Samsung’s new NX10 digital camera integrates an APS-C size CMOS sensor with a...[...]
Continue Reading

Google’s Chrome browser overtakes Apple’s Safari

Posted by Wirefresh
Boosted by an expensive advertising campaign which included� full size billboard posters (the London tube’s plastered with ‘em), newspaper, magazine and TV adverts, Google’s Chrome browser has overtaken Apple’s Safari...[...]
Continue Reading

Google’s New Year treat!

Posted by Wirefresh
Google have slipped in a nice little treat for the New Year. Go to�Google.com or Google.co.uk today and click �I�m Feeling Lucky� (without entering a search term) and see what...[...]
Continue Reading

iPhone Outdoors: Ordnance Survey mapping for walkers

Posted by Wirefresh
There’s not much we like more than stomping through the British countryside, navigating a path through remote terrain to reach a welcoming pub. Naturally, an Ordnance Survey map is an...[...]
Continue Reading

Welcome to the future: the flying car arrives!

Posted by Wirefresh
There’s been loads of attempts to create practical flying cars, but most of them have ended up as unholy bodges that made the Titanic seem a more agreeable transport option....[...]
Continue Reading

No comments:

Post a Comment