How to select an element with its name attribute in jQuery

November 26, 2015

To select an element with its name attribute in jQuery you can use the snippet below.

Samples

Javascript Sample

$('div[name="de.Fesslersoft.Testname"]').css({"border-color": "#000000", "border-width":"15px", "border-style":"solid"});

1	$('div[name="de.Fesslersoft.Testname"]').css({"border-color": "#000000", "border-width":"15px", "border-style":"solid"});

if you remove the div in div[name=”de.Fesslersoft.Testname”] you will get all elements with the specific name.

You can also have a look at this JSFiddle.

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

Related links:

Attribute Equals Selector [name=”value”]

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

Administrator

November 20, 2015

0 Comments

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

SELECT * FROM master.dbo.sysmessages ORDER BY error ASC

1	SELECT * FROM master.dbo.sysmessages ORDER BY error ASC

C# Sample

private static void MySqlMethod()
{
	SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder
	{
		DataSource = "localhost",
		InitialCatalog = "Northwind",
		IntegratedSecurity = true
	};

	try
	{
		using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
		{
			connection.Open();
			using (SqlCommand command = connection.CreateCommand())
			{
				//inserting invalid sql (for example: column not exists)
				command.CommandText = "SELECT InvalidColumnName FROM Customers";
				command.ExecuteNonQuery();
			}
		}
	}
	catch (SqlException ex)
	{
		// Log the original exception here
		foreach (SqlError sqlError in ex.Errors)
		{
			switch (sqlError.Number)
			{
				case 207: // 207 = InvalidColumn
					//do your Stuff here
					break;
				case 547: // 547 = (Foreign) Key violation
					//do your Stuff here
					break;
				case 2601: // 2601 = (Primary) key violation
					//do your Stuff here
					break;
				default:
					//do your Stuff here
					break;
			}
		}
	}
}

private static void MySqlMethod()

{

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder

{

DataSource = "localhost",

InitialCatalog = "Northwind",

IntegratedSecurity = true

};

try

{

using (SqlConnection connection = new SqlConnection(builder.ConnectionString))

{

connection.Open();

using (SqlCommand command = connection.CreateCommand())

{

//inserting invalid sql (for example: column not exists)

command.CommandText = "SELECT InvalidColumnName FROM Customers";

command.ExecuteNonQuery();

}

catch (SqlException ex)

{

// Log the original exception here

foreach (SqlError sqlError in ex.Errors)

{

switch (sqlError.Number)

{

case 207: // 207 = InvalidColumn

//do your Stuff here

break;

case 547: // 547 = (Foreign) Key violation

//do your Stuff here

break;

case 2601: // 2601 = (Primary) key violation

//do your Stuff here

break;

default:

//do your Stuff here

break;

}

VB.NET Sample

Private Sub MySqlMethod()
	Dim builder As New SqlConnectionStringBuilder() With { _
		.DataSource = "localhost", _
		.InitialCatalog = "Northwind", _
		.IntegratedSecurity = True _
	}

	Try
		Using connection As New SqlConnection(builder.ConnectionString)
			connection.Open()
			Using command As SqlCommand = connection.CreateCommand()
				'inserting invalid sql (for example: column not exists)
				command.CommandText = "SELECT InvalidColumnName FROM Customers"
				command.ExecuteNonQuery()
			End Using
		End Using
	Catch ex As SqlException
		' Log the original exception here
		For Each sqlError As SqlError In ex.Errors
			Select Case sqlError.Number
				Case 207
					' 207 = InvalidColumn
					'do your Stuff here
					Exit Select
				Case 547
					' 547 = (Foreign) Key violation
					'do your Stuff here
					Exit Select
				Case 2601
					' 2601 = (Primary) key violation
					'do your Stuff here
					Exit Select
				Case Else
					'do your Stuff here
					Exit Select
			End Select
		Next
	End Try
End Sub

Private Sub MySqlMethod()

Dim builder As New SqlConnectionStringBuilder() With { _

.DataSource = "localhost", _

.InitialCatalog = "Northwind", _

.IntegratedSecurity = True _

}

Try

Using connection As New SqlConnection(builder.ConnectionString)

connection.Open()

Using command As SqlCommand = connection.CreateCommand()

'inserting invalid sql (for example: column not exists)

command.CommandText = "SELECT InvalidColumnName FROM Customers"

command.ExecuteNonQuery()

End Using

Catch ex As SqlException

' Log the original exception here

For Each sqlError As SqlError In ex.Errors

Select Case sqlError.Number

Case 207

' 207 = InvalidColumn

'do your Stuff here

Exit Select

Case 547

' 547 = (Foreign) Key violation

'do your Stuff here

Exit Select

Case 2601

' 2601 = (Primary) key violation

'do your Stuff here

Exit Select

Case Else

'do your Stuff here

Exit Select

End Select

End Try

End Sub

Compatibility:

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 4.5

.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:

How to get all types that implement a specific Interface in C# and VB.NET

Administrator

March 17, 2015

6 Comments

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.

Methods

C# Version

Assembly myAssembly = Assembly.LoadFrom(@"C:\Codesnippets.Fesslersoft.de\Fesslersoft.dll");
            
//Gets all referenced Types of the current Assembly that implement a specific interface
IEnumerable<Type> currentAssemblytypes = AppDomain.CurrentDomain.GetAssemblies().SelectMany(x => x.GetTypes()).Where(y => typeof(MyInterfaceName).IsAssignableFrom(y) && !y.IsInterface);
            
//Gets all referenced Types of an assembly that implement a specific interface
IEnumerable<Type> otherAssemblyTypes = myAssembly.GetTypes().Where(y => typeof(MyAbractClassName).IsAssignableFrom(y) && !y.IsInterface);

//You can also change IsInterface to IsAbstract if you are checking for types that implement an Abstract Class.
IEnumerable<Type> otherAssemblyTypesAbstract = myAssembly.GetTypes().Where(y => typeof(MyAbractClassName).IsAssignableFrom(y) && !y.IsAbstract);

Assembly myAssembly = Assembly.LoadFrom(@"C:\Codesnippets.Fesslersoft.de\Fesslersoft.dll");

//Gets all referenced Types of the current Assembly that implement a specific interface

IEnumerable<Type> currentAssemblytypes = AppDomain.CurrentDomain.GetAssemblies().SelectMany(x => x.GetTypes()).Where(y => typeof(MyInterfaceName).IsAssignableFrom(y) && !y.IsInterface);

//Gets all referenced Types of an assembly that implement a specific interface

IEnumerable<Type> otherAssemblyTypes = myAssembly.GetTypes().Where(y => typeof(MyAbractClassName).IsAssignableFrom(y) && !y.IsInterface);

//You can also change IsInterface to IsAbstract if you are checking for types that implement an Abstract Class.

IEnumerable<Type> otherAssemblyTypesAbstract = myAssembly.GetTypes().Where(y => typeof(MyAbractClassName).IsAssignableFrom(y) && !y.IsAbstract);

VB.NET Version

Dim myAssembly As Assembly = Assembly.LoadFrom("C:\Codesnippets.Fesslersoft.de\Fesslersoft.dll")

'Gets all referenced Types of the current Assembly that implement a specific interface
Dim currentAssemblytypes As IEnumerable(Of Type) = AppDomain.CurrentDomain.GetAssemblies().SelectMany(Function(x) x.GetTypes()).Where(Function(y) GetType(MyInterfaceName).IsAssignableFrom(y) AndAlso Not y.IsInterface)

'Gets all referenced Types of an assembly that implement a specific interface
Dim otherAssemblyTypes As IEnumerable(Of Type) = myAssembly.GetTypes().Where(Function(y) GetType(MyAbractClassName).IsAssignableFrom(y) AndAlso Not y.IsInterface)

'You can also change IsInterface to IsAbstract if you are checking for types that implement an Abstract Class.
 Dim otherAssemblyTypesAbstract As IEnumerable(Of Type) = myAssembly.GetTypes().Where(Function(y) GetType(MyAbractClassName).IsAssignableFrom(y) AndAlso Not y.IsAbstract)

Dim myAssembly As Assembly = Assembly.LoadFrom("C:\Codesnippets.Fesslersoft.de\Fesslersoft.dll")

'Gets all referenced Types of the current Assembly that implement a specific interface

Dim currentAssemblytypes As IEnumerable(Of Type) = AppDomain.CurrentDomain.GetAssemblies().SelectMany(Function(x) x.GetTypes()).Where(Function(y) GetType(MyInterfaceName).IsAssignableFrom(y) AndAlso Not y.IsInterface)

'Gets all referenced Types of an assembly that implement a specific interface

Dim otherAssemblyTypes As IEnumerable(Of Type) = myAssembly.GetTypes().Where(Function(y) GetType(MyAbractClassName).IsAssignableFrom(y) AndAlso Not y.IsInterface)

'You can also change IsInterface to IsAbstract if you are checking for types that implement an Abstract Class.

Dim otherAssemblyTypesAbstract As IEnumerable(Of Type) = myAssembly.GetTypes().Where(Function(y) GetType(MyAbractClassName).IsAssignableFrom(y) AndAlso Not y.IsAbstract)

Compatibility:

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 4.5

Do you have an alternate or better method for this task?
If you have any questions or suggestions feel free to rate this snippet, post a comment or Contact Us via Email.

Related links:

How to disable comments on posts older than date X in WordPress

Administrator

February 23, 2015

3 Comments

To disable comments on posts older than date X in WordPress you can use the snippet below.

Sample mySQL

UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2013-01-01' AND post_status = 'publish'

How to open external links in new window in Javascript

Administrator

June 27, 2014

2 Comments

To open external links in new window in Javascript you can use the following snippet.

Sample Javascript

$('a[rel="externalLink"]').click( function() {
	window.open( $(this).attr('href') );
	return false;
});

How to open a pdf at a specific page using AcroRd32Info in C# and VB.NET

Administrator

June 7, 2014

1 Comment

To open a pdf at a specific page using AcroRd32Info in C# and VB.NET you can use the following snippet.

Sample C#

public static void OpenPdfAtPage(string document, int page) 
{
	object myProcess = new Process();
	object startInfo = new ProcessStartInfo();
	startInfo.FileName = "AcroRd32Info.exe";
	startInfo.Arguments = string.Format("/A \"page={0}\"{1}", page, document);
	myProcess.StartInfo = startInfo;
	myProcess.Start();
}

Sample VB.NET

Public Shared Sub OpenPdfAtPage(document As String, page As Integer)
	Dim myProcess = New Process()
	Dim startInfo = New ProcessStartInfo()
	startInfo.FileName = "AcroRd32Info.exe"
	startInfo.Arguments = String.Format("/A ""page={0}""{1}", page, document)
	myProcess.StartInfo = startInfo
	myProcess.Start()
End Sub

CODE SNIPPETS

CODESNIPPETS FOR .NET, SQL, JAVASCRIPT, JQUERY and more

specific

How to select an element with its name attribute in jQuery

Samples

Javascript Sample

How to get all types that implement a specific Interface in C# and VB.NET

Methods

C# Version

VB.NET Version

How to disable comments on posts older than date X in WordPress

Sample mySQL

How to open external links in new window in Javascript

Sample Javascript

How to open a pdf at a specific page using AcroRd32Info in C# and VB.NET

Sample C#

Sample VB.NET