Tag: query

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 get all Description Attributes of an Enum using C# or VB.NET you can use the snippet below. Sample C# – Class Usage C# Sample VB.NET – Class Usage VB.NET…

To get the selected row index in Devexpress Xtragrid Control using C# and VB.NET you can use the snippet below. Samples Sample C# int selectedRowIndex = gridView1.FocusedRowHandle; Sample VB.NET Dim…

To get current Domain of the PC in C# and VB.NET you can use the snippet below. Sample C# Sample VB.NET

To retrieve a IEnuemerable of all types in the current or another Assembly that implement a specific Interface / Abstract class and so on, you can use the snippets below.…

To get the class of an element using jQuery you can use the snippet below.

To get the size of all tables using MSSQL you can use the snippet below. Sample MSSQL

To use a select statement in a update statement using MSSQL you can use the snippet below. Sample SQL

To get the Month name of a Datetime in C# and VB.NET you can use the following snippet. Sample C# Sample VB.NET

To query a DataTable using LINQ in C# and VB.NET you can use the snippet below. In order to use the snippet, you need to reference System.Data.DataSetExtensions. Sample C# Sample…