How to export Gridview data to Excel using devexpress XtraGrid

To export Gridview data to Excel using devexpress XtraGrid have a look at the sample below.

Samples

C# Sample

VB.NET Sample

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

Please rate this snippet

How to catch specific MS-SQL SQLExceptions in C# and VB.NET

To catch specific SQLExceptions using Microsoft.NET and Microsoft Sequel Server you can use the snippet below. You also need to look for the specific error numbers/codes you want to catch. To do this you can either execute the following query in the SQL Management Studio or you can use this
List of SQLException Numbers/Codes (Direct-DL around 15mb).

Samples

T-SQL Sample

C# Sample

VB.NET Sample

Compatibility: working .NET 2.0 working .NET 3.0 not tested .NET 3.5 not working .NET 4.0 not working .NET 4.5not working .NET 4.6

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

Please rate this snippet

How to extract a password protected zip file using DotNetZip in C# and VB.NET

To extract (unzip) a password protected zip file using the Ionic DotNetZip Library, you can use the snippet below.

Samples

[tab name=”C# Sample”]

[/tab]
[tab name=”VB.NET Sample”]

[/tab]

[end_tabset]

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

Please rate this snippet

How to use a specific encoding using XDocument in C# and VB.NET

To use a specific encoding when working with XDocument, you can create an XDeclaration.

Samples

C# Sample

VB.NET Sample

If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

Please rate this snippet

Top 10 reads of July 2015

These are our Top 10 reads of July 2015.

  • How to match strings using wildcards in C# and VB.NET
  • IsSmallerThan generic extension method for C# and VB.NET
  • How to prevent your IOS app from going into sleeping mode using Objective-C
  • How to convert Color to Hex and Hex to Color using C# and VB.NET
  • How to read a embedded resource to String in C# and VB.NET
  • How to convert a Securestring to String using C# and VB.NET
  • How to change the encoding of a String using C# and VB.NET
  • How to get focusedrow cell value using Devexpress XtraGrid in C# and VB.NET
  • How to get the selected row index in Devexpress Xtragrid Control using C# and VB.NET
  • thanks to all visitors, bookmark us, share us, talk about us, Follow us!, Like us! let’s grow bigger! You can even participate in our Github Projects!

    Please rate this snippet

    IsSmallerThan generic extension method for C# and VB.NET

    This is the IsSmallerThan generic extension method, this extension method which is part of the Fesslersoft.Extensions. It should only work with numeric values.

    Samples

    Sample C#

    Sample VB.NET


    If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

    Related links:

    Please rate this snippet

    IsLargerThan generic extension method for C# and VB.NET

    This is the IsLargerThan generic extension method, this extension method which is part of the Fesslersoft.Extensions. It should only work with numeric values.

    Samples

    Sample C#

    Sample VB.NET

    If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

    Related links:

    Please rate this snippet

    How to change the encoding of a String using C# and VB.NET

    To change the encoding of a String using .NET you can use this Extension Method which is part of the Fesslersoft.Extensions. This method needs a source and a target encoding. Some people might find the source encoding parameter needless, but as Joel stated in his excellent blogpost

    “It does not make sense to have a string without knowing what encoding it uses” (Joel Spolsky)

    Samples

    Sample C#

    VB.NET Sample

    If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

    Related links:

    Please rate this snippet

    How to convert a String to Securestring using C# and VB.NET

    Here is an example on how to convert a String to Securestring using C# and VB.NET.
    Please remember that the plain string which will be converted to SecureString beats the whole point of using SecureString. This method should only be used for testing purposes.
    This Extension Method is now part of the Fesslersoft.Extensions.

    Samples

    C# Sample

    VB.NET Sample

    If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

    Related links:

    Please rate this snippet

    How to Remove duplicates from a IEnumerable using C# or VB.NET

    To Remove duplicates from a IEnumerable using C# or VB.NET you can use the snippet below.

    Sample .NET 3.5 and newer

    Sample C#

    using System;
    using System.Collections.Generic;
    using System.Linq;
    
    namespace de.Fesslersoft.DistinctIenumerbable
    {
        class Program
        {
            static void Main(string[] args)
            {
                var myList = new List<string>
                {
                    "1A", "1A", "1B", "1C", "1C", "1D", "1D"
                };
    
                myList = myList.Distinct().ToList();
    
                foreach (var item in myList)
                {
                    Console.WriteLine(item);
                }
                Console.Read();
            }
        }
    }
    

    Sample VB.NET (autogenerated)

    Imports System.Collections.Generic
    Imports System.Linq
    
    Namespace de.Fesslersoft.DistinctIenumerbable
    	Class Program
    		Private Shared Sub Main(args As String())
    			Dim myList = New List(Of String)() From { _
    				"1A", _
    				"1A", _
    				"1B", _
    				"1C", _
    				"1C", _
    				"1D", _
    				"1D" _
    			}
    
    			myList = myList.Distinct().ToList()
    
    			For Each item As var In myList
    				Console.WriteLine(item)
    			Next
    			Console.Read()
    		End Sub
    	End Class
    End Namespace
    

    Sample .NET 2.0

    Sample C#

    using System;
    using System.Collections.Generic;
    
    namespace de.Fesslersoft.DistinctIenumerbable
    {
        class Program
        {
            static void Main(string[] args)
            {
                List<String> myList = new List<string>();
                myList.Add("1A");
                myList.Add("1A");
                myList.Add("1B");
                myList.Add("1C");
                myList.Add("1C");
                myList.Add("1D");
                myList.Add("1D");
    
                var newList = new List<String>();
                foreach (var item in DistinctIenumerable(myList))
                {
                    newList.Add(item);
                }
    
                foreach (var item in newList)
                {
                    Console.WriteLine(item);
                }
                Console.Read();
            }
    
            internal static IEnumerable<T> DistinctIenumerable<T>(IEnumerable<T> input)
            {
                var passedValues = new Dictionary<T, bool>();
                foreach (T item in input)
                {
                    if (!passedValues.ContainsKey(item))
                    {
                        passedValues.Add(item, false);
                        yield return item;
                    }
                }
            }
        }
    }
    

    Sample VB.NET (autogenerated)

    Imports System.Collections.Generic
    
    Namespace de.Fesslersoft.DistinctIenumerbable
    	Class Program
    		Private Shared Sub Main(args As String())
    			Dim myList As List(Of [String]) = New List(Of String)()
    			myList.Add("1A")
    			myList.Add("1A")
    			myList.Add("1B")
    			myList.Add("1C")
    			myList.Add("1C")
    			myList.Add("1D")
    			myList.Add("1D")
    
    			Dim newList = New List(Of [String])()
    			For Each item As var In DistinctIenumerable(myList)
    				newList.Add(item)
    			Next
    
    			For Each item As var In newList
    				Console.WriteLine(item)
    			Next
    			Console.Read()
    		End Sub
    
    		Friend Shared Function DistinctIenumerable(Of T)(input As IEnumerable(Of T)) As IEnumerable(Of T)
    			Dim passedValues = New Dictionary(Of T, Boolean)()
    			For Each item As T In input
    				If Not passedValues.ContainsKey(item) Then
    					passedValues.Add(item, False)
    					yield Return item
    				End If
    			Next
    		End Function
    	End Class
    End Namespace
    

    Please rate this snippet