I was working with Will Knox of Big Blue Bear Consulting on a small ASP.NET project. I had written the code and created the master page template for a site, and Will was adding the content necessary to drive the client’s search engine rankings and on-line marketing efforts. In order to make it easier for [...]
Browsing Posts in .NET
I recently came upon a situation in which I needed to copy data from one database to another in ADO.NET. I found a couple of helpful tips on the way, and thought that I’d share them. The Task I was copying production data from a table to its twin in a development database. Many RDBMSes [...]
I was working on an application that dumps data out of a database into files. It’s a batch application (meaning that it runs multiple extractions in batches) and until recently only supported outputting the data as delimited files. However, I ran into an instance where I needed to export to native Excel files instead, because [...]
After rebuilding my PC a few months ago, I reinstalled all of my software. When I went to use Visual Studio 2008 to create a couple of applications that need to access databases. One of the tools that one usually uses for working on database applications is the Server Explorer (View -> Server Explorer). For [...]
As I mentioned before, I’ve been building a little desktop .NET application that allows my client to collect some information and store it in a simple Access 2007 database. When it came time to test the application on their production system, the error “The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.” appeared. I had [...]
I’ve been working on a small application for a client that saves records in a database. I’m building it to run on .NET 3.5 using Visual Studio 2008. Only one table was needed, but the data needed to be easily accessible for importation into Word and Excel by users with no programming or database abilities. [...]
