If you want to create a corresponding SQL Server database table, from a ODBC table, you can use the following C# function: Note This function is not bullet proof, but gives you a simple example: public void ScriptODBCTable() { string outputFolderPath = @"C:\Temp"; string tableName = "MyTableName"; string fullTableName = …
I was getting the error: MyApplication.exe has encountered a problem and needs to close. We are sorry for the inconvenience, but I was not getting any unhandled exceptions in my “HandleGlobalExceptions” event: AppDomain.CurrentDomain.UnhandledException += HandleGlobalExceptions; After setting some MessageBox.Show("Step 1") statements, I could see that the application was …
If you want to extract the contents of a msi package to filesystem, you can use the following C# function: public void ExtractMsiPackage() { string parameters = string.Empty; parameters = string.Format(@"/a {0} /qb TARGETDIR=""{1}"" REINSTALLMODE=amus", "C:\Temp\Test.msi", "C:\Temp\Extract"); Process process = Process.Start("msiexec", parameters); process.WaitForExit(); } /a = Administrative mode /qb …
If you are using SqlCacheDependency in you’re ASP .NET website, the database must have SQL Server Broker enabled. To enable SQL Server Broker on a SQL Server 2005 database use: USE master GO ALTER DATABASE Dagstaten SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE GO The set enable_broker requires an exclusive lock on …
If you want to find and replace some text in all files of a given folder, including subfolders, you can use the following C# code: string rootfolder = @"C:\Temp"; string[] files = Directory.GetFiles(rootfolder, "*.*", SearchOption.AllDirectories); foreach (string file in files) { try { string contents = File.ReadAllText(file); contents = contents.Replace(@"Text …
If you want to execute an existing Microsoft SQL Server Agent Job in C# you an use the following function: The function uses SQL authentication to connect to the Microsoft SQL Server instance. using System; using System.Collections.Generic; using System.Linq; using System.Text; using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Smo.Agent; using Microsoft.SqlServer.Management.Common; using System.Data; …
I create a new VMWare development image and got the following error: Error loading TestPackage.dtsx: The component metadata for "component "SRC_TestTable" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. When opening the SSIS 2005 package in Microsoft SQL Server Business …
When you get the error: Error while trying to run project: ‘C:\…’ The debugger’s protocol is incompatible with the debuggee Check you’re supportedRuntime tag in you’re App.config or Web.config I ported a .NET 4.0 C# application back to .NET 3.5 and got that message, removing the startup tag: <startup> <supportedRuntime …
If you want to show the log4net logging direct in your application by using a textbox, you can use the following link: http://weblogs.asp.net/psteele/archive/2010/01/25/live-capture-of-log4net-logging.aspx I tried it and it works great: using System; using System.Collections.Generic; using System.ComponentModel; using System.Drawing; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using log4net.Appender; using …
If you want to concatenate all items in a generic List<string> in C# you can use the following code: List<string> itemsInGenericList = new List<string> { "Item 1", "Item 2", "Item 3", "Item 4" }; // Convert generic list of strings to an array of strings. string[] itemsInArray = itemsInGenericList.ToArray(); …
