tag:blogger.com,1999:blog-89085452788419364502011-11-10T01:43:06.247-08:00Dave Of BrainDavehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.comBlogger581100tag:blogger.com,1999:blog-8908545278841936450.post-74338077298458120792011-03-17T13:46:00.000-07:002011-03-17T13:59:48.161-07:00

Ran into an error in IE6 on a site I was developing:"Attribute only valid on v:image"The error message popped up on a Google Map canvas I had embedded in the page whenever a user interacted with the map.The culprit was a combination of DD_belatedpng and a rule included by default in html5boilerplate where all tags were being fixed by DD_belatedpng when the page loaded. Removing the img selector

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-67295617752286169722009-08-25T12:23:00.000-07:002009-08-25T12:37:44.780-07:00

FusionCharts' JavaScript file makes use of innerHTML to replace a placeholder <div>'s content with the generated SWF. However, on IE6, this causes an "Unknown runtime error".I am working with version 1.2.4. I have jQuery 1.3 loaded on the site, so I replaced four instances of innerHTML calls with $().html() syntax:Line 237:{ n.innerHTML = obj.getSWFHTML(); },false );became{ $(n).html(

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com43tag:blogger.com,1999:blog-8908545278841936450.post-13217900514173790712009-07-25T19:56:00.000-07:002009-07-25T19:58:05.682-07:00

If you need to run JavaScript that's based on some attribute of a loaded image (e.g. height or width), use a callback with $(window).load() instead of $(document).ready().

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com3tag:blogger.com,1999:blog-8908545278841936450.post-52265127289516925332009-06-05T14:03:00.001-07:002009-06-05T14:04:35.126-07:00

Awesome post by Joe Finsterwald (http://www.wtfdeveloper.com/Default2.aspx) shows how to implement geographical distance calculation functionality in pure T-SQL.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-71737345498613084762009-04-27T13:56:00.001-07:002009-04-27T14:00:12.179-07:00

I needed a way to convert a BIGINT containing a date in SSE (seconds since epoch - 1/1/1970) format into a DATETIME. The following query does the trick:SELECT DATEADD(DAY, CAST(sse_value AS BIGINT)/86400000, CAST('19700101' AS DATETIME))Thanks to some guy named Steve Kass for pointing this out on DevelopmentNow.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-90453232629575789832009-04-11T21:45:00.000-07:002009-04-11T21:46:40.812-07:00

If you're experiencing color issues with your images in Safari, make sure that an embedded color profile was not saved with the image. Open the image in Photoshop; File --> Save As; uncheck Embed Color Profile; save image.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-11433321088813436052009-01-07T13:55:00.000-08:002009-01-07T13:57:03.688-08:00

If you're having trouble getting z-indexes to work right in IE, the order of your style declarations in your css file might matter. Try putting the style code for the element you want to stack on top at the bottom of your css file and see if the problem persists.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-2747657678564635172008-12-29T12:00:00.001-08:002008-12-29T12:03:23.301-08:00

I, like many others, ran into the issue of <a> links not being click-able when they sit on top of an element upon which the alpha fix has been run.A hint I got off of this site gave me the answer I was looking for: The element containing the filtered png must not have a position set, and the links within that element must have a position set.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-10546719888616685632008-12-04T20:48:00.000-08:002008-12-04T20:51:14.595-08:00

Ran across this beautiful CSS example of a perfectly centered <div>:#mydiv{ position:absolute; top: 50%; left: 50%; width:30em; height:18em; margin-top: -9em; /*set to a negative number 1/2 of your height*/ margin-left: -15em; /*set to a negative number 1/2 of your width*/}

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-26876148818709014282008-11-19T07:58:00.001-08:002008-11-19T08:01:02.145-08:00

This was a helpful article in understanding connectivity issues when attempting to use FTPS through a NATed firewall:http://geekswithblogs.net/Lance/archive/2005/08/23/50912.aspxI'm using FileZilla Server to receive files from someone else and needed to set up FTPS. Specifying a particular port, and then opening that port, solved the problems I was having (i.e. 425 errors).

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-61606647293118936322008-10-27T11:30:00.001-07:002008-10-27T15:06:42.834-07:00

Another necessary hack, this time to overcome IE6's non-support of the hover pseudo-class for LI elements.This is to be used in situations where navigation is structured using UL, LI, and A elements and styled via CSS.  Please note that additional selectors will be required when implementing this solution: the standard selector (using li:hover notation) and the alternate selector (using li.over

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-46782819307045414312008-10-27T11:27:00.000-07:002008-10-27T11:29:58.120-07:00

I know a bazillion solutions have been posted to the interwebs to solve this problem, but I wanted to make a note of one that I found to work quite well:http://www.twinhelix.com/css/iepngfix/

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-63859456888500058552008-09-25T10:45:00.000-07:002008-09-25T10:50:45.915-07:00

Found this neat trick on another blog (http://lunarmedia.com/blogs/lunarmedia_blog/archive/2006/10/23/120405.aspx) to escape characters for presentation in HTML:function escapeHTML (str){   var div = document.createElement('div');   var text = document.createTextNode(str);   div.appendChild(text);   return div.innerHTML;}; 

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com2tag:blogger.com,1999:blog-8908545278841936450.post-85324705337566320942008-09-18T06:58:00.000-07:002008-09-18T07:01:27.814-07:00

I was tasked with moving an ASP.NET 3.5 website from one web server to another.  Everything worked great on the second server, except I was getting 404 errors anytime an embedded resource was requested with a WebResource.axd URL.I went all over Google looking for the answer, and found a workaround that works, but is absolutely ridiculous:Place an empty WebResource.axd file at the location that is

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-38744953783996439592008-08-01T07:40:00.000-07:002008-08-01T07:50:27.344-07:00

I'm calling an ASP.NET web service from an ASP.NET web application. The two applications are on different servers. The web service requires SSL and presents the application with a self-signed certificate. Since this is an internal app, I want the client application to trust the web service and its self-signed cert.There are lots of suggestions on how to do this in your code by coding a

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com4tag:blogger.com,1999:blog-8908545278841936450.post-25402627227163029902008-07-29T07:20:00.000-07:002008-07-29T07:27:00.818-07:00

The Event Log on our MOSS 2007 server was filled with alternating error codes 6482 and 6398.6482:Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (dc8cedfd-9340-42bb-adee-57e75040cdf6).Reason: Retrieving the COM class factory for component with CLSID {3D42CCB1-4665-4620-92A3-478F47389230} failed due to the

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-61728377011505267322008-07-24T13:27:00.001-07:002008-07-24T13:34:15.646-07:00

I spent a little bit of time trying to figure this one out. I'm playing with the exposed web services that MOSS 2007 provides, trying to figure out how to manipulate lists via this API. My web reference is set to http://company.com/Clients/_vti_bin/Lists.asmx, but I am getting the same response as if the web reference were set to the site root (i.e. http://company.com/_vti_bin/Lists.asmx).

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-4673635727693507932008-06-16T12:11:00.000-07:002008-06-16T12:15:39.703-07:00

I ran across the following T-SQL function to calculate the number of workdays between a given start date and end date. (This does not exclude non-weekend non-workdays such as holidays.) Thanks to Jeff Moden for this function, which I found at http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/:SELECT (DATEDIFF(dd, @StartDate, @EndDate) + 1) -(DATEDIFF(wk, @

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-35794638315282395452008-06-12T10:55:00.000-07:002008-06-12T11:00:25.562-07:00

I ran into this fix when trying to get an ASP.NET 2.0 Menu control to render correctly on Safari. It turns out that ASP.NET thinks Safari is a downlevel browser (meaning incapable of rendering XHTML), so it sends a funky (and generally non-functioning) rendering of the Menu control down to the browser. This isn't guaranteed to work in all cases, but in my case, adding the following Page

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-9384075351695019312008-06-11T20:06:00.000-07:002008-06-11T20:09:02.025-07:00

This obscure error occurred when using PHP ODBC to retrieve values from a stored procedure. It turns out this occurs when the stored procedure SELECTs data from one or more TEXT columns. Convert these columns to VARCHAR(8000) and you're good to go.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-30144431086499766332008-06-09T07:05:00.000-07:002008-06-09T07:10:10.358-07:00

I have been fighting this one for days: my computer is currently joined to our corporate domain, but I am logged in as a local user. I've used "Manage network passwords" to add all of the relevant credentials for domain access. However, I still get the following error when logging in via Windows Authentication in SSMS:Login failed for user ''. The user is not associated with a trusted SQL

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-11335271714291470072008-04-23T10:52:00.001-07:002008-04-23T10:53:55.277-07:00

Another blog ripoff, this time from Janne Mattila, on how to trick XP or Vista machines into thinking that WSS 3.0 is installed so that you can install WSS 3.0 Tools for Visual Studio 2005:http://blogs.msdn.com/jannemattila/archive/2007/08/16/how-to-install-windows-sharepoint-services-3-0-tools-to-xp-or-vista.aspxDetails: it's a registry hack...[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-32612134322543907802008-04-22T12:38:00.001-07:002008-04-23T10:51:47.701-07:00

Wonderful series of posts by Tony Zink outlining exactly what you need to do to set up Microsoft Office SharePoint Server 2007 on a Virtual PC with a SQL Server 2005 backend and full e-mail capabilities:http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=28

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-83331807228795596392008-04-03T08:00:00.000-07:002008-04-03T08:07:30.017-07:00

A DataGridView control won't bind directly to an IEnumerable object, so two options are:1. Create a BindingSource, set its DataSource to the IEnumerable object, then set the DataGridView.DataSource property to the BindingSource.2. Bind the DataGridView.DataSource property to the IEnumerable object's ToList() method.Thanks to Ken Tucker on Microsoft Forums for this tip.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com2tag:blogger.com,1999:blog-8908545278841936450.post-7021426667165888012008-03-03T10:20:00.000-08:002008-03-03T10:24:42.921-08:00

Thanks to Julien Pinquié:When I ran across this, I found that I'd closed a <script> tag referring to an external .js file with /> notation instead of <script></script>; the <script> tag doesn't accept this notation for whatever reason.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com9tag:blogger.com,1999:blog-8908545278841936450.post-70633694493619500862008-02-17T08:46:00.000-08:002008-02-17T08:51:58.347-08:00

The following function will check to see if connectivity is enabled for a particular host on a particular port via TCP/IP:Function ScanPort(ByVal strHost As String, ByVal intPort As Integer) As Boolean    Dim aobjIPs() As System.Net.IPAddress = System.Net.Dns.GetHostEntry(strHost).AddressList    If aobjIPs.Length > 0 Then        Dim objEndpoint As New System.Net.IPEndPoint(aobjIPs(0), intPort)

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-20835362111437858972008-01-31T08:55:00.000-08:002008-01-31T09:00:17.740-08:00

When an ASP.NET server-side button is given client-side JavaScript code to execute when handling onclick, the button no longer posts back by default. However, there is a small piece of code you can add to the onclick attribute of the button to re-enable the postback behavior.Adding this code in the Page_Load method will remove a server-side button's postback call:btnConfirm.Attributes.Add("

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-31872880468307350032008-01-31T08:48:00.000-08:002008-01-31T08:55:30.548-08:00

By nature, FileUpload controls require an entire page postback to submit the file contents, so they are explicitly excluded from support within an UpdatePanel...however, if you put the Submit button that performs the postback intended to upload the file into a PostbackTrigger, you can place your FileUpload control within the UpdatePanel.<asp:UpdatePanel runat="server">    <ContentTemplate>

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com7tag:blogger.com,1999:blog-8908545278841936450.post-35526220930934928302008-01-09T11:31:00.000-08:002008-01-09T11:38:03.833-08:00

To do this, create a new class file containing a Partial Class declaration with the name of your table adapter. Add this code to the class:Private _transaction As SqlTransactionPrivate Property Transaction() As SqlTransaction Get Return Me._transaction End Get Set(ByVal Value As SqlTransaction) Me._transaction = Value End SetEnd PropertyPublic Sub BeginTransaction()

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-90693958004171941112007-12-03T07:16:00.000-08:002007-12-03T07:18:09.688-08:00

Blatantly plagiarized from http://www.dustindiaz.com/min-height-fast-hack/:selector { min-height:500px; height:auto !important; height:500px;}

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-5592787374178317272007-11-05T19:42:00.001-08:002007-11-05T19:45:32.790-08:00

Found a neat piece of T-SQL that can be used to separate the octets of an IP address:Declare @IP varchar(20)Select @IP = '239.147.8.165'select @IP AS IP, cast(substring(@IP, 1, charindex('.', @IP) - 1) as int) AS Octet1, cast(substring(@IP, charindex('.', @IP) + 1, charindex('.', @IP, charindex('.', @IP) + 1) - charindex('.', @IP) - 1) as int) as Octet2, cast(reverse(

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-72109567978548287732007-10-18T11:27:00.000-07:002007-10-18T11:31:22.341-07:00

This is especially useful when using a master page but you don't want every page using the master page to refresh.In the Page_Load() event handler, add this code: 'Refresh the page every 30 seconds. Dim lit As New LiteralControl("<meta equiv=""refresh"" content=""30"" />") Header.Controls.Add(lit)

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-12845650053274866502007-10-14T08:39:00.000-07:002007-10-14T08:42:09.627-07:00

If you're reusing a form and are trying to make it the main form of an application, and you get this error, ensure that the constructor for the form takes no arguments.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-33207055172380785852007-08-21T06:15:00.001-07:002007-08-21T06:17:04.043-07:00

Just a note on one way of accomplishing this:Dim objAccess As Object = CreateObject("Access.Application")objAccess.OpenCurrentDatabase(strFileName)objAccess.Visible = TrueobjAccess.DoCmd.Maximize()objAccess.DoCmd.OpenTable(strTableName)

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-52753189567824223022007-08-15T19:47:00.000-07:002007-08-15T19:51:33.314-07:00

I recently needed to write a program that had an attended and unattended mode:1. Create a console application in Visual Studio .NET.2. Use this as a template:Module Module1    Sub Main()        If Command$() = "-winform" Then            Dim frm As New testform()            Windows.Forms.Application.Run(frm)        Else            Console.WriteLine("this is the console option")        End If    

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-30082066639799987032007-08-15T08:44:00.001-07:002007-08-15T10:01:12.301-07:00

This is useful for saving window position and size when an application closes and then restoring these settings when the application starts again.1. In app.config, create three new settings:- IsMaximized (Boolean)- MainFormPosition (System.Drawing.Point)- MainFormSize (System.Drawing.Size)2. In the form's Load event handler, add the following code:If My.Settings.MainFormPosition <> Nothing _

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-39689181926222681742007-08-15T08:29:00.000-07:002007-08-15T08:44:22.563-07:00

I was running into an issue where I didn't want the grid to auto-scroll or change the selected row when the underlying DataSource property was changed. Here's what I came up with:' dgv is a DataGridView control with SelectionMode set to FullRowSelect and MultiSelect set to False.Dim intSelectedIndex As Integer = 0If dgv.SelectedRows.Count > 0 Then    intSelectedIndex = dgv.SelectedRows(0).

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-91599743541017178912007-07-31T06:54:00.000-07:002007-07-31T07:19:16.534-07:00

An easy way to implement a Recent menu in your application is to use the My.Settings namespace and store the recently opened items in a StringCollection setting.1. Create a setting called RecentDocuments of type System.Collections.Specialized.StringCollection.2. Add the following methods to your form class:Private Function GetRecentDocuments() As StringCollection 'StringCollection can be

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-33887912950029406172007-07-31T06:34:00.000-07:002007-07-31T06:42:40.327-07:00

Here's what needs to happen to get an MDI application up and running:1. Set the form's IsMdiContainer property to True.2. Create a menu strip for the form.3. Create a Window menu in the menu strip.4. Set the menu strip's MdiWindowListItem property to the name of the Window menu.Always refer to the topmost window with a reference to the main form's ActiveMdiChild property.When a new child window

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-34637813181629460942007-07-13T07:12:00.000-07:002007-07-13T07:20:32.805-07:00

On calls to Range.InlineShapes.Add("C:\blah.jpg") and Range.Shapes.Add("C:\blah.jpg") I kept getting a very helpful, precise error:The server threw an exception.(Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))Thanks for that!After playing around with the code for awhile, I found that my particular problem was being caused by how I instantiated the Word.Document object. My code read:Dim

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com2tag:blogger.com,1999:blog-8908545278841936450.post-85234296375487584412007-06-29T07:20:00.001-07:002007-06-29T07:23:56.837-07:00

I wrestled with this one for awhile, but discovered (via Google) that you can use StringBuilder to allocate a fixed-length string, then pass the StringBuilder in by value to the exported function/method in the unmanaged DLL. Strings don't work in this case because they are not fixed length, and access violation errors can (and usually) occur.Declare Ansi Function Function_Name Lib "lib.dll" (

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-79496375677851818562007-06-29T06:32:00.000-07:002007-06-29T06:33:49.397-07:00

Open a Visual Studio Command Prompt, navigate to the directory of the DLL to inspect, and use the following command:dumpbin /export whatever.dll

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-28761503676462678402007-06-15T11:13:00.001-07:002007-06-15T11:14:03.533-07:00

Another useful command in looking at Oracle execution plans is:set autotrace traceonly explain

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-37395246897257216182007-06-15T09:51:00.000-07:002007-06-15T09:52:40.184-07:00

Discovered this article when looking up how to view a query plan in Oracle.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-7355806013520912072007-06-14T11:02:00.001-07:002007-06-14T11:16:29.976-07:00

I recently needed to find out the schema names of certain Oracle tables that belonged to schemas other than the connecting user. This is because the four-part queries in SQL Server require the schema/owner name of the tables referenced. This query (run in SQL*Plus) lists the owners and names of all tables that can be seen by the connecting user:SELECT OWNER, TABLE_NAME FROM ALL_TABLES;A full

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-61659054000116397842007-06-01T14:36:00.000-07:002007-06-01T14:43:37.460-07:00

Found this neat tidbit on some other guy's blog. Basically, NUMERICs/DECIMALs are exact numeric types and cannot contain the E notation in their representations. FLOATs are approximate numeric types and can contain the E notation. FLOATs can also be CASTed to NUMERIC/DECIMAL with no problems (other than a loss of precision).For example, take the VARCHAR value X = '10000000E-2'. To cast it to

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-8041276212782345262007-06-01T12:45:00.000-07:002007-06-01T12:50:02.958-07:00

Use FileStream.SetLength():Dim strFile As String = "C:\Path\To\File.txt"Dim fi As New FileInfo(strFile)Dim fs As New FileStream(strFile, FileMode.Open, FileAccess.Write)fs.SetLength(fi.Length - n)fs.Flush()fs.Close()

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-69485231543103721752007-05-24T06:20:00.001-07:002007-05-24T06:22:29.827-07:00

Use Process.Start:Dim ps As New ProcessStartInfo("explorer")ps.Arguments = "C:\Directory\to\open"Process.Start(ps)

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-42233653441556887432007-05-18T11:53:00.000-07:002007-05-18T12:00:59.226-07:00

\w - matches any word character\W - matches any non-word character\s - matches any whitespace character\S - matches any non-whitespace character\n - newline\f - formfeed\r - carriage return\t - tab\v - vertical tab\0x0020 - space\d - digit^ - beginning of string$ - end of string

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-64280866092661443282007-02-13T10:11:00.000-08:002007-01-25T13:14:19.522-08:00

Suppose you have a unique integer column i in a table T. i may contain gaps. i contains m rows.Suppose you wish to insert n values into i starting at some value x0 and incrementing. Let x equal the first integer greater than or equal to x0 not found in i.In general, this can be solved by performing the following:SELECT TOP n * 2 IDENTITY(INT, x, 1) AS jINTO #tempFROM T T1CROSS JOIN T

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-31999375276106778792007-01-25T13:13:00.000-08:002007-01-25T13:14:19.632-08:00

A simple solution for getting system icons into a PictureBox control at runtime is to set the PictureBox's Image property to SystemIcons.xxxxxx.ToBitmap().

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-81813470405083414492006-12-11T07:05:00.000-08:002006-12-11T07:09:35.424-08:00

To iterate a command over all databases on a server, the undocumented sp_msforeachdb stored procedure fits the bill nicely. For example, I was given the task to set all databases on a particular server to a bulk-logged recovery model; this was easily accomplished with a single command:master..sp_msforeachdb 'exec sp_dboption ''?'', ''select into/bulkcopy'', ''on'''Note that this procedure

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-60572785194753534872006-12-04T08:28:00.000-08:002006-12-04T08:35:36.671-08:00

It turns out that an OleDbDataAdapter can be used to fill an ADO.NET DataTable object from an ADODB.Recordset object:Imports System.Data.OleDb...Public Function RecordSetToDataTable(ByVal objRS As ADODB.RecordSet) As DataTable    Dim objDA As New OleDbDataAdapter()    Dim objDT As New DataTable()    objDA.Fill(objDT, objRS)    Return objDTEnd Function

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com2tag:blogger.com,1999:blog-8908545278841936450.post-52582171066130037882006-11-30T10:02:00.000-08:002006-11-30T10:05:13.298-08:00

This is a list of all of the possible values for the xtype column in the sysobjects table of a SQL Server database:C - CHECK constraintD - Default or DEFAULT constraintF - FOREIGN KEY constraintL - LogP - Stored procedurePK - PRIMARY KEY constraintRF - Replication filter stored procedureS - System tableTR - TriggerU - User tableUQ - UNIQUE constraintV - ViewX - Extended stored procedure

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-60280395518857689922006-11-28T10:05:00.000-08:002006-11-28T10:21:31.207-08:00

I ran across this automation exception message sporadically in a project I'm working on where I'm trying to place a large string on the Clipboard and paste it into an Excel 2002 spreadsheet (object) using Interop in VB.NET 2005. It probably happened one time out of every five attempts to paste.Previously, my code read:'objWorksheet is an Excel.Worksheet automation objectDim strClipboard As New

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com2tag:blogger.com,1999:blog-8908545278841936450.post-21544449306266738492006-11-20T17:11:00.000-08:002006-11-20T17:14:21.371-08:00

This neat little SQL Server statement allows you to view/edit properties of the identity value of a table.Syntax: DBCC CHECKIDENT ('table_name' [ , { NORESEED { RESEED [ , new_reseed_value ] } } ])[ WITH NO_INFOMSGS ]For example, if I want to reset the identity value of the table FOOBAR to 55, I run the following SQL statement:DBCC CHECKIDENT('FOOBAR', RESEED, 55).If FOOBAR already has rows,

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com1tag:blogger.com,1999:blog-8908545278841936450.post-91769061329203124422006-11-20T17:09:00.000-08:002006-11-20T17:10:47.840-08:00

The whole point of this blog is so I don't have to attempt to remember programming tips and tricks I find. Hopefully I can help other developers at the same time. This is merely intended to be extra brain space.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0tag:blogger.com,1999:blog-8908545278841936450.post-90112696802262733242006-11-20T17:06:00.000-08:002006-11-20T17:07:37.741-08:00

So, I'm a blogger. How sad.

Davehttp://www.blogger.com/profile/02365594340981258761noreply@blogger.com0