Craig's Utility Library

1) Added XOr extension to string class (Utilities.Encryption.ExtensionMethods)

Weird bug in NuGet where it doesn't recognize the package once it's been installed. Trying to fix it.

To be honest, I have no idea what you're trying to do without seeing code. But generally speaking using the SQLHelper class usually looks like this:   using(SQLHelper Helper=new SQLHelper("SQL Command","ConnectionString",CommandType)) { ... [More] Helper.AddParameter("ParamName",DataValue); Helper.ExecuteReader(); . . . Helper.Command="NewCommand"; Helper.AddParameter("ParamName",DataValue); Helper.ExecuteReader(); . . . Helper.Command="NewCommand2"; Helper.AddParameter("ParamName",DataValue); Helper.ExecuteReader(); . . . } As far as dbtypes, you can either use the generic AddParameter that I have above. Those functions will automatically convert them to an appropriate DbType. Or you can use another function AddParameter(string ID,SqlDbType Type, object Value=null,...) or AddParameter(string ID,DbType Type, object Value=null,...) if you're not using SQL Server if you need to set the type yourself. [Less]

Moved tag Github/master to changeset 3750b1f2b424 (from changeset 97db0f369563)

1) Updated HttpContext extensions to use HttpContextBase instead. 2) Added extension method to Dictionary and NameValueCollection classes to export the values as a query string (Utilities.Web.ExtensionMethods) 3) Added UserIPAddress and ... [More] IfModifiedSince extension methods for HttpRequest class (Utilities.Web.ExtensionMethods) 4) Added ToStringFull extension for TimeSpan, which exports the TimeSpan to a string using the Year, Month, and DaysRemainder extension methods (Utilities.DataTypes.ExtensionMethods). 5) Added HasDefaultConstructor extension to Type (Utilities.Reflection.ExtensionMethods). 6) Added RelativeTime extension to DateTime which expresses the difference between it and an Epoch (usually today) expressed as a string (Utilities.DataTypes.ExtensionMethods) [Less]

Yes I found that all my parameters are gone after i use the command method, but if I have to add the parameters again may I ask why should I create a "dummy" helper in the first place?    anyway, tks for the response, very generous of you for the library.

Set the Command property to whatever query you need. However it's going to clear out the parameters. So you're going to have to add any parameters after you set the Command property. Note that until you dispose of the Helper object (or call Close) ... [More] , it's going to keep that connection to the database alive. So what I'll routinely do is create the object and set the initial command text to "" and then run through 4 or 5 commands by setting the Command property, adding my parameters, and calling the appropriate execute function. [Less]

I am using the helper to create a dynamic sql command text. When I use the helper to create the helper class, I do not have the sql command text. How can I create the helper and add parameters, then add the command text later?  

1) Updated BlogML code a bit more (fixed bugs that were found).

1) Updated BlogML code to allow for exporting. 2) Updated a number of comments on various files.