TechSapphire Wednesday, 2017-11-22, 4:29 AM
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
  • 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 »

    Category: Programming | Views: 1060 | Added by: Admin | Date: 2016-09-15 | Comments (0)

    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 »

    Category: Programming | Views: 1990 | Added by: Admin | Date: 2016-03-06 | Comments (0)

    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 »

    Category: Database | Views: 2065 | Added by: Admin | Date: 2015-10-05 | Comments (0)

    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:

    Category: Programming | Views: 1856 | Added by: Admin | Date: 2015-09-18 | Comments (0)

    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.

    Category: Programming | Views: 1868 | Added by: Admin | Date: 2015-07-15 | Comments (0)

    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 »

    Category: Programming | Views: 749 | Added by: Admin | Date: 2015-07-09 | Comments (0)

    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

    Category: Database | Views: 1997 | Added by: Admin | Date: 2015-05-26 | Comments (1)

    Show data or details in horizontal layout in SSRS

    To show data in horizontal layout like mentioned below:

    Click here to continue

    Category: SSRS | Views: 1931 | Added by: Admin | Date: 2015-05-18 | Comments (0)

    SSIS Row Number

    Generating Row Number in SSIS for each record. 

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

    Category: Database | Views: 1767 | Added by: Admin | Date: 2015-05-05 | Comments (0)

    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

    Category: Database | Views: 1766 | Added by: Admin | Date: 2015-04-23 | Comments (0)

    1 2 3 ... 6 7 »
    Categories
    Programming [27]
    Tips for programming
    Security [2]
    Security Tips
    Google [1]
    Use google faster then ever you use
    Project [14]
    HTML [2]
    Electronics [0]
    Data Structure [0]
    Database [16]
    SQL SERVER
    SSRS [1]
    Sql Server Reporting Services
    Copyright MyCorp © 2017