jQuery Keypress Events List

Introduction

In this article I would like to list out most common jQuery keypress events.

Basics

You can bind keypress events in document.ready function like

$(document).ready(function () {

    $("#id" or ".class").keypress(function (e) {
        //key press requirement goes here
    });
});

Inside the event, you can identify key pressed from e.which  property, which will report the actual ASCII code for the character pressed. Continue reading “jQuery Keypress Events List”

Save C# DataTable to Sql Server Table

Introduction

In this article, I would like to explain the fastest way to save c# data table into sql server table using user defined table type.

👉 Download project from : http://goo.gl/418AKF

🎞 video tutorial : watch from here

Basics

I have created a demo table product.

Save c# datatable to sql server table Continue reading “Save C# DataTable to Sql Server Table”

Joins in Sql Server

Introduction

This is an article about joins in sql server . The article covers all aspects of joins using proper examples and Venn diagrams.

What is meant by joins in SQL server ?

Joins are the commands used to combine data from two or more tables based on relation between them. The relation between them is specified using columns from each tables and relational operators like  =,<,> and <>.

General Syntax : –

SELECT <column_list>
FROM table_1 type_of_join table_2
ON table_1.column_name Operator table_2.column_name
--Valid Operators =,<,>,<>

Continue reading “Joins in Sql Server”

String Vs string in C#

Introduction

In this post I would like to discuss about String Vs string in c#.It is a common interview question for c# beginners.

🎞 video tutorial : watch from here

String vs string

String is a class in .Net library while string is a c# alias or keyword for String class.

String is a .Net Framework date type.Both String and string refers to the same class String in .Net Library. In a c# program you can use both String and string interchangeably. After compilation, both of them will be converted into System.String in IL(Intermediate Language).

string = System.String Class

Continue reading “String Vs string in C#”

Interesting C# Interview Questions

Introduction

In this article, I would like to discuss some of the interesting c# interview questions,This post will be updated with new interesting c# interview questions.

Question and Answer

Q1 . Consider following code snippets

int i=5;
i=(i++)+i+(++i);

what will be the value of variable i after these two lines?

Continue reading “Interesting C# Interview Questions”