July 17, 2002

Saving an array to a SQL Server table with VB and ADO

Persisting an array of data in a SQL Server DB is usually considered quite difficult. The common solution is to use a master detail table, but this leads to a waste of space and overall decreases performance. Here we’ll see how to save an array with VB and ADO.Create the

GetHtmlPageSource – Download the HTML at a given URL

‘ Download the HTML source code at the specified URL’ You can optionally specify the username/password credentials,’ in case the page uses Basic Authentication’ Returns a null string if any error occursFunction GetHtmlPageSource(ByVal url As String, Optional ByVal username As _ String = Nothing, Optional ByVal password As String =