If using SQL Server, SqlBulkCopy.WriteToServer(DataTable) SqlBulkCopy.WriteToServer Method (DataTable) Or also with SQL Server, you can write it to a .csv and use BULK INSERT BULK INSERT (Transact-SQL) If using MySQL, you could write it to a .csv and use LOAD DATA INFILE LOAD DATA INFILE Syntax If using Oracle, you can use the array binding … Read more
Under Linux, deamons are simple background processes. No special control methods (e.g start(), stop()) are used as in Windows. Build your service as a simple (console) application, and run it in the background. Use a tool like daemonize to run a program as a Unix daemon, and remember to specify mono as the program to … Read more
This is useful since string implements ICloneable, so you can create a copy of clones for a collection of ICloneable items. This is boring when the collection is of strings only, but it’s useful when the collection contains multiple types that implement ICloneable. As for copying a single string it has no use, since it … Read more
Use the insert method of the combobox to insert the “Please select item” in to 0 index, comboBox1.Items.Insert(0, “Please select any value”); and add all the items to the combobox after the first index. In the form load set comboBox1.SelectedIndex = 0; EDIT: In form load write the text in to the comboBox1.Text by hardcoding … Read more
You have to specify which method you want: class SomeType { void Foo(int size, string bar) { } void Foo() { } } SomeType obj = new SomeType(); // call with int and string arguments obj.GetType() .GetMethod(“Foo”, new Type[] { typeof(int), typeof(string) }) .Invoke(obj, new object[] { 42, “Hello” }); // call without arguments obj.GetType() … Read more
You’ll have to implement custom logic using xmlreader. xmlreader does not load the full XML into memory before using it, which means you can read it from a stream and process it as such.
Take a look at the ConfigurationManager.OpenExeConfiguration function to load in your configuration file. Then on the System.Configuration.Configuration class that you’ll get back from ConfigurationManager.OpenExeConfiguration you’ll want to look at the SectionGroups property. That’ll return a ConfigurationSectionGroupCollection in which you’ll find the applicationSettings section. In the ConfigurationSectionGroupCollection there will be a Sections property which contains the … Read more
This is a bug. I have seen it too. It happens because your .resx file is pointing to 4.0.0.0 version of System.Drawing where one does not exist. To overcome this problem i usually edit the .resx in notepad to change 4.0.0.0 to 2.0.0.0. The bug is introduced by following the exact steps that you have … Read more
First, I would review my SQL 2000 code and get to the bottom of why this deadlock is happening. Fixing this may be hiding a bigger problem (Eg. missing index or bad query). Second I would review my architecture to confirm the deadlocking statement really needs to be called that frequently (Does select count(*) from … Read more
Using has virtually the same syntax in VB as C#, assuming you’re using .NET 2.0 or later (which implies the VB.NET v8 compiler or later). Basically, just remove the braces and add a “End Using” Dim bitmap as New BitmapImage() Dim buffer As Byte() = GetHugeByteArrayFromExternalSource() Using stream As New MemoryStream(buffer, false) bitmap.BeginInit() bitmap.CacheOption = … Read more