Tag: Visual Studio
-
SQL project flag Invalid objects when run from Azure Pipelines
—
For most of my .Net solutions, I define the database in a database project (SQL Server Data Tools or SSDT) in the solution and use that to deploy to database server(s). For additional QA, using Azure Pipelines, I often spin up a localdb instance and deploy the database to it, after which I can run…
-
ReSharper Postfix Templates plugin
—
Developers: ever notice how you often, when typing some piece of code, most often a variable or other class reference, have to track back your keystrokes to surround it or prefix it with something else? The Postfix Templates extension for ReSharper by Alexander Shvedov (@ControlFlow) minimizes the times you have to backtrack what you typed,…
-
Update to SQL server tooling for Visual Studio
—
MS recently released the “March 2014” update to the SQL Server tooling for Visual Studio 2013, which was named SQL Server Data Tools for previous Visual Studio versions. Among the most notable new features are support for SQL Server 2014 and several productivity updates that simplify development and testing, also on SQL Azure. Read more…
-
Downloading UTF-8 filenames from an FTP-server that does not support them, with System.Net.FtpWebRequest
—
I have written a windows service in .Net that monitors an FTP location for new files, which it then downloads to a local folder for processing. To be precise, the tool first renames the file before downloading it. It uses the .Net standard FtpWebRequest class from System.Net. Every once in a while, a file could…
-
The case of the blank Visual Studio properties window — part 2
—
Earlier this year I suffered from a case of a Visual Studio properties window that appeared to get “stuck” in the middle of developing an application. It would show up blank and the only way to get it to work was to fix the project and restart Visual Studio (not just close and reopen the…
-
Error when compiling .resx file – Attempt to load a program with an invalid structure
—
I have seen this before and fixed it, but ran into it again today and could not remember what is was. When compiling a WinForms application in Visual Studio 2010, I got an error message stating “Kan bestand of assembly (…) of een van de afhankelijkheden hiervan niet laden. Poging om een programma te laden…
-
Initializing a combobox to a blank value might be harder than you think
—
Combobox troubles again today. No matter how hard I tried to have Comboboxes in my dialog form to initially display blank (SelectedIndex = -1), as soon as the dialog was displayed, the combos would always show the first item in the List that populated it. Despite being set to -1 explicitly. It was driving me…
-
SP1 for SQL server 2008R2 brings back Intellisense to SMSS
—
in GeneralYay! Installed Service Pack 1 for SQL Server 2008 R2 today. Among other fixes, it brought back IntelliSense support in SQL Server Management Studio, which had been broken since I installed SP1 for Visual Studio 2010 on that machine. So those of you that were bothered by the same issue, are advised to install the…
-
Jet OleDB 4.0 provider not registered on the local computer
—
I have a C# WinForms program that attempts to import some data from Excel into a SQL Server database using the Ole DB provider. Today the import suddenly failed with an error message saying that the Jet Ole DB provider was not registered on the local computer. Well, I was pretty sure that it was.…
-
WinForms ComboBox does not always fire SelectionChangeCommitted
—
Today I ran into the problem that a ComboBox in my project did not always fire the SelectionChangeCommitted event when I expected it to. To be specific, if a user dropped down the list, used the arrow keys to move to an item, and then TABbed to the next control, the new item would be…