tag:blogger.com,1999:blog-42621045060107327912011-11-27T23:29:09.036ZThe results of several years' experience hacking websites together using ASP.NET, MySQL, VB.NET, C# and JavaScript.Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.comBlogger71100tag:blogger.com,1999:blog-4262104506010732791.post-59636777031626378182010-12-17T10:29:00.003Z2010-12-29T20:23:56.295Z

Using CDOSYS.DLL is a very convenient way to parse and extract content and attachments from an EML file. However, embedded images in the HTML part of the email do not appear as attachments. Solution: enumerate the BodyParts and look for BodyParts with a filename: this includes all the attachments and embedded images.  The syntax is a little tricky, but BodyParts work just the same as Attachments

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0tag:blogger.com,1999:blog-4262104506010732791.post-43767982607846080852010-12-17T10:23:00.003Z2011-01-09T16:43:12.972Z

Most probably due to the default value of 1M for max_allowed_packet.  Increase to 100M and problem will very likely go away.

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0tag:blogger.com,1999:blog-4262104506010732791.post-3844743415491394682010-11-20T21:18:00.002Z2010-11-23T09:12:03.941Z

You can do this 'properly' (certainly better than trying to parse it as a text file) by using the COM cdosys.dll ('Microsoft CDO for Windows 2000 Library'). You'll need to create a .Net wrapper for it by adding a reference: because it depends on ADODB.dll, you'll get Interop.CDO.dll and Interop.ADODB.dll created for you in your bin directory. There's a lot of information around for sending

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0tag:blogger.com,1999:blog-4262104506010732791.post-81878407424951627652010-08-31T11:43:00.021+01:002010-08-31T13:07:47.918+01:00

There's a small problem that affects any attempt to connect to a database through a connection string using WebMatrix : there's an error in the documentation that leads you to try to use Database.OpenConnectionString when you should be using the currently undocumented Database.Open (as shown below). If you install the MySql.Data.MySqlClient dll to the GAC then you won't need the 

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0tag:blogger.com,1999:blog-4262104506010732791.post-66758967240762015332010-08-29T12:28:00.001+01:002010-08-29T12:29:44.991+01:00

After researching this for some time I found an excellent article that provides a convenient solution from Matt Berseth: http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html Like most solutions to this problem, this article describes how to make ASP.NET re-render the GridView in a cleaned-up HTML format and then serve that rendering as a download. The downside to this is that it

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0tag:blogger.com,1999:blog-4262104506010732791.post-41699296669778885872010-08-27T15:29:00.009+01:002010-11-26T10:07:26.991Z

'ddlxxxxx' has a SelectedValue which is invalid because it does not exist in the list of items.Many people complain about this untrappable error, but if you search hard enough, you will eventually find the fix: http://forums.devx.com/showthread.php?t=155180 So, it turns out that it's very easy to create your own DropDownList control inheriting all the behaviour of the original except this error

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0tag:blogger.com,1999:blog-4262104506010732791.post-47045459057614412632010-08-27T11:16:00.001+01:002010-08-27T11:26:16.687+01:00

This is one of the craziest problems ever: 1. You have a database field called 'CustomerId' 2. so you refer to this field as myrow("CustomerId") 3. this works for all users worldwide but fails for Turkish users 4. change the code to refer to myrow("Customerid") and it works Reason:  Turkish has an i character without a dot. So, in Turkish, 'i' and 'I' are not related in any way: they are not

Davidhttp://www.blogger.com/profile/01511239714035057094noreply@blogger.com0