day 43 and I write poetry

today (in particular)
I miss speaking the language
that we created,
learned,
and in which only we are fluent,
the one comprised of sound effects, hand effects,
the one reserved for perfectly communicating
thoughts that are like
unfinished sentences, tongue clicks, stuffed animal psyche,
a language like a try/catch block,
collecting thoughts mildly ignorant, conjecture and insecure,
unspeakably offensive and intoxicating,
(but today, its)
a language that feels like
a short-term memory, like
being stuck
(without you)
in a jar of peanut butter
(with which to speak it)

how to query duplicate records in SQL

SELECT *
FROM Person.Address A
INNER JOIN (SELECT AddressLine1, City
FROM Person.[Address]
GROUP BY AddressLine1, City
HAVING COUNT(*) > 1) AS A1
ON A.AddressLine1 = A1.AddressLine1
AND A.City = A1.City
ORDER BY A.AddressLine1, A.City, A.AddressID

how to get a list of tables in a database using C#

Unsurprisingly, if a table doesn't exist in a database, you can't use a select query to determine whether it exists. But using GetSchema() with no parameters, you can obtain a schema table, which is essentially a list of tables you can specify to get more specific schema information. In this case, I wanted to get a list of tables in the database. After transforming the results into a list of strings, I could then safely search the list to determine whether it exists.

SqlConnection con =
new SqlConnection("connection_string");
con.Open();
DataTable tbl = 
con.GetSchema("Tables");

Schema and metadata retrieval using ADO.NET

this also works, depending on whether you need these extra parameters, but its a big uglier:

DataTable tables = 
con.GetOleDbSchemaTable
(OleDbSchemaGuid.Tables,
new object[]{null,null,null,"TABLE"});

Get all table names

fixed my "Restore failed...The file cannot be overwritten. It is being used by database..." error

The "Database -> Restore Database... -> Options pane -> Restore the database files as" file names in the "Restore As" fields were not "Test1Copy1" as entered into the "General pane -> Destination for restore -> To database" field as the database restore destination. The file names were in fact "Test1," the same name of the "General pane -> Destination for restore -> From database" field. Basically, the file names should be Test1Copy1, but for some reason default to Test1.

The... error is resolved by clicking into the "Options pane -> Restore the database files as" file names in the Restore As fields and manually changing the file names...

FROM: Test1.mdf
TO: Test1Copy1.mdf

and

FROM: Test1_log.ldf
TO: Test1Copy1_log.ldf

This could be a SQL Server Management Studio bug, but it is just as likely a misunderstanding by a user who is just realizing he not only doesn't know his @ss from a hole in the ground; he didn't even know there was a hole in the ground ;-)

<%= Clinton Gallagher

Slightly scathing at the very end, Clinton Gallagher, very sneaky, but I do appreciate the apparent concern for my virgin eyes and for the bug fix :-P

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic12008.aspx

fixed my " TypeLoadException: Could not load type from string value" error

3.2.4.1. Object creation of generic types via constructor invocation
The following examples shows the definition of simple generic types and how they can be created in Spring's XML based configuration file.

namespace GenericsPlay
{
    public class FilterableList<T>
    {
        private List<T> list;        
        private String name;

        public List<T> Contents
        {
            get { return list; }
            set { list = value; }
        }

        public String Name
        {
            get { return name; }
            set { name = value; }
        }
        
        public List<T> ApplyFilter(string filterExpression)
        {
            /// should really apply filter to list ;)
            return new List<T>();
        }
    }
}

The XML configuration to create and configure this object is shown below

<object id="myFilteredIntList" type="GenericsPlay.FilterableList&lt;int&gt;, GenericsPlay">
  <property name="Name" value="My Integer List"/>
</object>

Chapter 3. Objects, Object Factories, and Application Contexts

MJ
3:41 PM
I am actually surprised
3:42 PM
because I realized over the weekend
3:42 PM
it would be really nice to live with you

how to add a Global.asax code behind file

One of the subtle differences I've found while working with web projects in Visual Studio 2005 is the Global.asax code is placed in script tags within the actual .asax page, not a codebehind file, as it was with .NET 1.1. This article describes how to set up the Global.asax file to utilize the Global.asax.cs codebehind file.

First off, go to files->add new and select the "Global Application Class" file. You'll notice right off the bat that the option to put the code in a separate file is grayed out. Ignore this and click "Add".

Next, go back to files->add new and select a "Class" file. Type in the name "Global.asax.cs" and click "Add". Visual Studio will prompt you to add this file to the App_Code directory, select "Yes" and continue.

Now that the files are in place, we need to do some slight manipulation of the existing code to get this solution to compile.

To start, the Global class in the Global.asax.cs file needs to implement HttpApplication.

public class Global : System.Web.HttpApplication

Next, move the code within the script tags from the Global.asax file to the Global.asax.cs file -within the Global class.

void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
}

...snip...

void Session_End(object sender, EventArgs e)
{
// Code that runs when a session ends.
}

Once the code has been moved, remove the script tags from Global.asax:



Add the following to the Application directive at the top of the same page:

CodeBehind="Global.asax.cs" Inherits="Global"

The entire contents of the Global.asax file should look like:

<%@ Application Language="C#" CodeBehind="Global.asax.cs" Inherits="Global" %>

The solution should compile and the Global events should fire correctly as well.

http://www.xerratus.com/2006/10/20/NET20GlobalasaxCodeInSeparateFile.aspx