Tag: How to
How to handle Null Column values of SQLDataReader in C# ?
If you want to handle the Null column values of the sqldatareader object in C#, you can use the SqlReader.IsDBNull method to validate for it. If the SqlReader.IsDBNull returns true then , the value is considered to be a null value and you can take the ction accordingly. How to handle Null Column values of SQLDataReader in C# ?
Unix Shell Script Program to display "Hello, World!"
Problem Write a program in Unix Shell Script to display “Hello, World!”. Unix Shell Script Program to display “Hello, World!” This is a simple Unix Shell Script program that displays “Hello, World!”.
How to read a key from the Web.Config file in ASP.NET app using C# ?
If you want to read the values based on the key from the web.config file in your ASP.NET application using C# , you can use the WebConfigurationManager to do it. How to read a key from the Web.Config file in ASP.NET app using C# ? Assume that the configuration file contains the below values If you want to read the value of the key (“UserName”)…
SQL Server 2014 Tutorial – Open SQL Server Instance Port in Windows Firewall
Problem Statement You need open the SQL Server Instance port number in Windows Firewall so that you can connect to SQL Server from another machine. Solution When you try to connect to the SQL Server instance from another machine , you might receive the connection timeout error . To allow the users of other machine to connect to your SQL Server instance , you need…
Getting all the Foreign Key constraints list of a table in SQL Server
You might need to write a T-SQL Query to retrieve all the foreign key constraints of a given table in SQL Server. For these cases , you can use the sp_fkeys stored procedure. How to get all the Foreign Key constraints list of a table in SQL Server ?
How to Get a value to a Variable in SQL Server ?
When you use the declare a variable using the DECLARE statement. The same variable can be used to store a value retrieved from the database and later can be used in your SQL Query. How to Get a value to a Variable in SQL Server ? For example , you want to retreive the value of the column JobTitle and store it in the variable…
How to decode a base64 string in C#?
Here’s a sample code snippet demonstrating how you can easily decode a base64 encoded string in C#. How to decode a base64 string in C#?
How to Create Pivot Data using LINQ in C#?
Are you looking forward to create a pivot data using LINQ in C#, here we go. How to Create Pivot Data using LINQ in C#? Below is a sample code snippet that demonstrates the creation of the Pivot Data using LINQ and C#?
How to Get Necessary Information from the Exception in C# ?
There are times when you want to get the necessary information from the exception to identify the error better in C# . The Exception class contains various properties which can be used to retreive the necessary information from the error. Some of the properties includes Message – The Message property provides the brief description of error. Source – The Source property provides information about the…
C Program to display full pyramid using *
Problem Write a program in C to print full pyramid using * as shown below.The program should take the number of rows as input. * * * * * * * * * * * * * * * * How to create and display full pyramid pattern in C using * ? Output Abundantcode.com Coding samples Enter the limit: 4…
How to Get Directions in Map in Windows Phone 8 using C#?
Below is a sample code snippet that demonstrates How to Get Directions in Map in Windows Phone 8 using C#? The Start point is not specified for the MapsDirectionsTask object and hence takes the users current location. How to Get Directions in Map in Windows Phone 8 using C#?
How to create a new Windows Azure Mobile Service?
Want to know how to create a Windows Azure Mobile Service, a cloud based backend service for your iOS, Windows Phone, Android / Windows 8 App? This article will explain how to create one. Note: You need a Windows Azure account and have the Windows Azure Mobile Services enabled for your account. Know more about getting Windows Azure Account here. How to create a new…