Code snippets and steps to create custom code snippets

Code snippets are meant as small region of reusable code. Which allow you to use intellisense to insert set of code N number of times. Below are the content you will cover in lecture. Using code snippets can save a lot of time and effort. Also help in distributing common standard code among team.

• Code Snippets – Introduction
• Ways to insert code snippets
• Custom Code Snippets
• XML File walkthrough
• Examples
• Using the custom snippets

• Ready made code fragments
• Two types
   • Expansion code snippet
   • Surround with code snippet

Custom code snippets:
• Steps to create custom code snippet
• Create an XML file w ... Read more »

Keypress event in WPF to validate integer input is replaced by PreviewTextInput in C#

In WPF we don't have keypress event, generally people used keypress event in windows forms application to validate text input. Now in this example I have showed how you can validate input from textbox using PreviewTextInput event. In this example I validated input to accept float values, you can use this to validate integer or any other number type validation.

Code used in example is:

XAML:

<Window x:Class="TestApplication.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
      ... Read more »

SQL server 100% CPU usage fix

This issue is very common and commonly faced by DBA, developers and server management team on production server i.e. ... Read more »

C# Best Practices

In this article I have focused on practical aspect more, and also I have not included basic practices as you can learn them from any article available online. I have tried to cover basic practices which will minimize your coding effort as well as it will make your code more manageable and also will reduce run time exceptions.

Topics covered in today’s lecture are:

• Common Coding Guidelines
• SQL Helper Class
• Using Lamda expression or LINQ
• Some common tips
• Cross resolution design
• LINQ operators and operations

To read full article click below:

Error: Subreport could not be shown. RDLC using with ASP.NET.

This exception is thrown only in 3 cases:
1. Parameter is not passed to sub report
2. Parameter which is been passed is not been created on sub report
3. Data type of parameter on main report and sub report is not matching up.

To view complete article click here.

Uploading and downloading file on SFTP using private key in .NET using SharpSSH

Topic to cover:

Connecting SFTP using Private Key using .NET console App
• Downloading and Uploading File

For complete SFTP operation in detail check link below:
Article: http://www.techsapphire.in/index/sftp_download_upload_and_delete_file_using_sharpssh_library/0-150
Video: https://youtu.be/VVqh0BCgFpM

Library used Sharpssh. To install:

• Got to Tools:>Library Package Manager:>Manage NuGet Pankages for solutions

• Search SharpSSh

• Install

To view comple ... Read more »

SQL for Beginners

SQL (Structured Query Language)

• It is high level language which provide you capability to query data from any structured data source (Tables). 
• High level language means language which is used by us to communicate (English). 
• For learning, we will be using online SQL editor provided by W3C.
• http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

SQL script:

SQL Queries:

Using Wild Card (*) :
Selecting all data 
SELECT * FROM CUSTOMERS

Specific Columns:
SELECT CustomerName, ContactName,Address,
 City FROM CUSTOMERS

Click to continue

Show data or details in horizontal layout in SSRS

To show data in horizontal layout like mentioned below:

Click here to continue

SSIS Row Number

Generating Row Number in SSIS for each record. 

Steps for Generating Row Numbers are: Click to Download Project.

PIVOT:
•Convert your output from (values)vertical order to horizontal(making columns) one

Topic to cover:
•PIVOT example
•PIVOT syntax
•Interview Question
•PIVOT on northwind
•Dynamic PIVOT query

Click to continue