Getting System.Byte[] In Your MySql Query Results Through Connector v5.2.5

by Marvin 30. March 2009 07:39

This is a little thing, but I ran into it again today, forgot how I fixed it before, and had to figure it out again.  To save myself the grief (and maybe someone else), I am posting the solution here.  I had a query that worked fine when I ran it from MySql Administrator, but when I ran it in my ASP.NET application using the .NET Connector v5.2.5, I was getting System.Byte[] values.  More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Bookmark and Share
Permalink | Comments (1) | Post RSSRSS comment feed

Keeping DataSets To Yourself When Returning Data in your Web Service

by Marvin 5. March 2009 14:19

When I first starting developing web services, I just loved to use DataSets to return data from the service.  I mean, they are pretty easy to use, and I am all about the easy road.  Then I stumbled across Scott Hanselman's blog article where I learned that "returning DataSets from web services is the spawn of Satan and represents all that is truly evil in the world."  Oops.  While I found this and other articles which explained the problems with using DataSets as a container for returning data from a web service, I didn't really find that "for Dummies" walkthrough that I was looking for.  At least, not a walkthrough that met my particular needs and that my feeble brain could understand.  This article is intended to be that walkthrough I wish I could have found. More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

Bookmark and Share
Permalink | Comments (0) | Post RSSRSS comment feed

Create a Loading Indicator for AJAX Partial-Page Updates in ASP.NET

by Marvin 28. February 2009 04:02

I think one of the coolest things about ASP.NET v3.5 is that they've made it really easy to add AJAX functionality to your web pages.  I mean, hey, if I can pick it up and do it, it can't be too complex, right?  Sometimes, though, your partial-page updates take awhile because of network latency or a lot of processing on the server.  You need a way to let the user know to just be patient and wait a minute before getting overly-excited and clicking that "Submit" button again, and again, and again.  Here's how I do it.  More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

Web Development

Bookmark and Share
Permalink | Comments (0) | Post RSSRSS comment feed

Marvin is Going to Jail

by Marvin 9. February 2009 12:40

Sad, but true.  I am going to do time.  I have pleaded my case, but it was no use.  Authorities are coming to arrest me on March 24th.  During my incarceration, I will be separated from my family, and I will have no access to a computer.  Worst of all, I discovered that someone I know has turned me in.  I am not quite sure who it was yet.  They are under witness protection, but I am definitely going to find out.   

It's all for a good cause.  My work is particpating in the Muscular Dystrophy Association's 2009 Lock Up, so I am getting thrown in the slammer and trying to raise money for MDA as my bail bond.  If you have a soft spot for the work that MDA is doing and want to contribute, any contributions (even small ones) will be greatly appreciated.  It's pretty easy.  You can donate online at the following web-site:

https://www.joinmda.org/MyLockup/MyHomepage/tabid/50090/Participant/marvinpalmer/Default.aspx

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Bookmark and Share
Permalink | Comments (0) | Post RSSRSS comment feed

GoDaddy and your MySql Database

by Marvin 6. February 2009 19:39

I have been a customer of GoDaddy's for awhile now, and at this point, I have gotten pretty comfortable with their tools to manage my websites and databases.  I forget sometimes that it was VERY painful for me in the beginning.  I suppose I repressed the memory of how frustrated I was when I got my first ASP.NET website built and everything worked great locally only to fail miserably when uploaded to GoDaddy.  Things like how to get my site published, get my database up and running, connect my published pages to my remote database, etc - these were all tricky for me to figure out the first time.  So, I am going to put together some articles on the basic stuff that you have to know to be able to get your data-driven ASP.NET website up and running using MySQL on GoDaddy.  This article will cover setting up a MySql database on GoDaddy. It will be the first in a series that I will put in the category "GoDaddy Basics". More...

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

GoDaddy Basics | Web Development

Bookmark and Share
Permalink | Comments (1) | Post RSSRSS comment feed

Falling in Love With Objects

by Marvin 30. January 2009 17:39

I am about to show just how much of an amateur I am.  The lightbulb has finally come on in my head regarding the value of object-oriented programming.  It has taken awhile for it to sink in, and I most certainly don't have it all figured out yet, but I thought I would share some of the epiphanies I've had about it and how it's making my life as a programmer much easier.  More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

Web Development

Bookmark and Share
Permalink | Comments (0) | Post RSSRSS comment feed

Using Kellner's ASP.NET Membership Console with MySql

by Marvin 25. January 2009 08:35

At this point, I've done a few ASP.NET websites, hosted on GoDaddy, that have user accounts using the ASP.NET Membership and Role providers and all the great web controls that ship with ASP.NET.  Each time, I ended up wanting to give the admin users of the site an interface to be able to manage the site membership accounts, grant access privileges, create, edit and remove accounts.  ASP.NET doesn't come with that, but there are some open-source projects out there which can give you this.  I really like Peter Kellner's membership management console which you can download here.  However, when I tried to use it with MySql and the .NET Connector v5.2.3 and deployed to GoDaddy, I ran into some unique challenges that I hadn't encountered when using Sql Server in the past.  This article explains how I worked around the challenges and successfully implemented the tool in a web application using VS Pro 2008, .NET 3.5, MySql 5.0 and the .NET Connector v5.2.3.  More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , ,

Web Development

Bookmark and Share
Permalink | Comments (0) | Post RSSRSS comment feed

Remembering Joe

by Marvin 4. October 2008 15:28
This article has been moved to Marvin's personal blog. More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Bookmark and Share
Permalink | Comments (0) | Post RSSRSS comment feed

Ping.Fm (updated)

by Marvin 17. September 2008 02:24

9/17/08 Just an update to this post. Ping.Fm is now out of beta so anyone can go sign-up and get it. For all my fellow T-mobile users, I also learned that you can actually update your status from your T-mobile phone using SMS-to-email. I learned the details of how to do this here.

I just got my application key for the beta application Ping.Fm, and I have to say that I am very impressed with this application.  I stumbled across it while on Facebook.  I have been looking for a way to get my Twitter updates to populate to Facebook.  If you've tried any of the Twitter apps on Facebook, you know that they are buggy or don't work at all.  Then, I noticed an acquaintance of mine, Jeff Blankenburg, was using this thing called Ping.Fm.  Jeff is a developer evangelist for Microsoft, so I figure he's got the inside on the cool stuff which made me curious about this Ping.Fm thing.  More...

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Recommendations

Bookmark and Share
Permalink | Comments (15) | Post RSSRSS comment feed

Implement .NET Membership and Roles using MySql Connector 5.2.3 on GoDaddy

by Marvin 5. September 2008 14:47

I recently completed implementing .NET Membership and Roles on an application I have hosted on GoDaddy and using MySQL .NET Connector v5.2.3 and MySQL v5.0.  I ran into a few hitches along the way, and I figured I better get all this down while it's still fairly fresh in my head in case I ever need to do this again.  This article is intended to be a fairly comprehensive walkthrough of how I did it. More...

Currently rated 4.8 by 4 people

  • Currently 4.75/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , ,

Web Development

Bookmark and Share
Permalink | Comments (17) | Post RSSRSS comment feed

About the author

I am a junior-level C# .NET developer living in Nashville, TN.  I'm currently working in biomedical informatics, developing a web service, a MySql database, and a web application.  Every week or so, I spend hours trying to figure out how to do something, and after I find the solution, I really want to make sure I don't go through that exercise again.  I love to write.  It helps me to remember things.  So, I use this blog as a way to document those painful lessons as I learn them.  It has already helped me to be able to refer back to them.  I hope some of these will save someone else some time as well.