C#

<br />
SQLDMO.SQLServerClass sqlServer = new SQLServerClass();<br />
//login<br />
sqlServer.Connect("MYSERVER", "username", "password");<br />
<br />
// go through databases list<br />
foreach (SQLDMO.Database db in sqlServer.Databases)<br />
{<br />
	if (! db.SystemObject)<br />
	{<br />
		if(db.Name=="Northwind")<br />
		{<br />
			// Northwind found <br />
			// go through tables list<br />
			foreach( SQLDMO.Table table in db.Tables )<br />
			{<br />
				if(table.Name=="Customers")<br />
				{<br />
					// table "Customers" found<br />
					// go through columns list<br />
					foreach(SQLDMO.Column column in table.Columns )<br />
					{<br />
						// print out column name<br />
						Console.WriteLine( column.Name );<br />
						// print out column length<br />
						Console.WriteLine( column.Length );<br />
						// print out column datatype<br />
						Console.WriteLine( column.Datatype );<br />
					}<br />
				}<br />
<br />
			}<br />
		}<br />
	}<br />
}		<br />

<br />
[DllImport("user32")]<br />
public static extern short GetKeyState (Keys VirtKey);<br />

<br />
bool lshiftpressed = ((GetKeyState(Keys.LShiftKey) & 256)==256);<br />
bool rshiftpressed = ((GetKeyState(Keys.RShiftKey) & 256)==256);<br />

static object dummy = 42; // needs some data in the heap to lock

lock (dummy) {
	MailBox box = new MailBox("username");
	box.AddMail(mail);
	box.Save();
}

static Hashtable boxes = new Hashtable();
boxes.Add(user1, 1);
boxes.Add(user2, 2);
...
lock(boxes[userX])
{
   MailBox box = new MailBox(userX);
   box.AddMail(mail);
   box.Save();
}