swclassdotcom

[swclassdotcom]

7 ways to insert data into Sql Server table

1). Simple Sql INSERT Query

2). Simple Sql INSERT INTO Query

3). Simple Sql INSERT INTO with selected columns Query

4). Simple Sql INSERT INTO with multiple values Query

5). Sql INSERT Rows from another table

6). Sql INSERT INTO With Multiple Data Using UNION ALL Query

7). Sql Query to Move Rows From One Table into Another Row By Row Using While Loop

to learn more..

https://swclass.com/Article/37/Different-ways-to-insert-data-into-Sql-Server-table

[swclassdotcom]

SQL Server UNION, UNION ALL, EXCEPT and INTERSECT Operator

Sql Set Statements are used to combines the results of two or more queries into a single result set.

The following are basic rules for combining the result sets of two or more queries:

1) The number and the order of the columns must be the same in all queries.

2) The data types must be compatible

.For more visit: https://swclass.com/Article/55/sql-server-union-except-and-intersect

[swclassdotcom]

JavaScript code with OOP like concept encapsulation and abstraction.

Object Literal, Which has limitations that is public properties and methods. The module pattern overcomes some of the limitations of the object literal. It offers privacy for variables and functions as well as exposing a public properties and methods if desired.

For more visit: https://swclass.com/Article/16/JAVASCRIPT-Code-Organization-Module-Pattern

[swclassdotcom]

Why use delegate in c#?

1) Most important use of  delegate is you can pass methods as an parameters to an event or method.

2) you can use delegate for defining callback methods.

3) you can make a chin of delegates like passing different methods to an single event.

4) you can encapsulate both an object instance and a method by using delegates.

More: https://swclass.com/Article/31/CSharp-Delegates-References-To-Methods

[swclassdotcom]

5 Minutes for JavaScript best practice

JavaScript Code Structure When you are adding simple functionality to your website with javascript or jQuery at client side, you need to plan, how to organize code. I'll take a look at various code organization design and patterns you can use in your javascript or jQuery application.

The Object Literal The simplest way to encapsulate related code. It does not support any privacy (like public and private) for properties and methods, but it is useful for get rid off anonymous functions from your code, centralizing configuration options.

for more visit: https://swclass.com/Article/15/JAVASCRIPT-Code-Organization-The-Object-Literal

[swclassdotcom]

7-Main differences between dataset and datatable in C#

A DataTable is an table which is collection of columns and rows representing with in memory.

DataSet is a collection of DataTables representing in memory. Whenever you want to fetch data from database, it connects indirectly to the database and create a virtual database in local system and then disconnected from database.

for more visit: https://swclass.com/Article/75/Difference-between-dataset-and-datatable-in-CSharp

[swclassdotcom]

2 Minutes for types of commands in SQL Server

One of the most important question asked in interview, you might know with in 2 minute session only.

T-SQL is abbreviation of Transact-Structured Query Language (SQL).

Data definition language (DDL)

Data Manipulation Language (DML)

Data control language (DCL)

Transactional Control Language (TCL)

Database Console Command (DBCC)

for more visit: https://swclass.com/Article/14/What-is-TSQL-DDL-DML-DCL-and-TCL-in-SQL-Server

[swclassdotcom]

Calling Web API using jQuery AJAX

Calling Web API using jQuery AJAX-Lets you know How to use Web API with JQuery AJAX. Moreover, one of the best available javascript design and pattern based on object oriented two most famous concept Encapsulation and Polymorphism.

For more visit - 

https://swclass.com/Article/71/String-string-and-StringBuilder-in-CSharp

[swclassdotcom]

14 - Effortless steps to run REST Web API - Asp.net

Asp.net Web API - A Web API (application programming interface) is an framework, that makes easy to build HTTP requests to GET, PUT, POST and DELETE data for clients. Which include browsers and mobile devices. ASP.NET provides REST full (Representational State Transfer) web applications using .NET Framework.

for more visit: https://swclass.com/Article/22/MVC-Web-API

[swclassdotcom]

String string and StringBuilder in C-Sharp

In C#, string is an alias for the String class in .NET framework. Like a person having two names one for UID, social, public, documentation and official purpose and other for parents like to call him with love at home.

String is immutable, which means if you create string object then you cannot modify it and It always create new object of string type in memory.

StringBuilder is mutable, it means if you create StringBuilder object then you can have more functionality over string by performing any operation like insert, replace or append without creating new instance for every time like in string. it will update string at one place in memory doesn't create new space in memory.

for more visit:

https://swclass.com/Article/71/String-string-and-StringBuilder-in-CSharp

[swclassdotcom]

C# Extension Method

With the help of Extension Methods, We can add more functionality to existing type without modifying the original types. We can add new methods to existing types without creating new derived type, recompiling or modifying types. In simple words it extends the functionality of dot net.

for more visit :

https://swclass.com/Article/39/CSharp-Extension-Methods

[swclassdotcom]

8 - Easy Steps to encrypt decrypt user data in C#

Here you will learn, encrypt and decrypt login credentials e.g. username and password and store in Sql Server Database using Asp.net with C# Language with an simple example.

Here we will store (save) UserName and Password return by user from input form into the SQL Server Database in encrypted form.

After save we will bind UserName and Password in first Grid View as it is (encrypted) and In the second Grid View decrypted

for more visit: 

https://swclass.com/Article/78/How-to-encrypt-decrypt-username-password-in-CSharp

[swclassdotcom]

T-Sql tactics to replace multiple spaces with single space

T-Sql to replace multiple spaces with single space - Every developer face same problem many times when user enters continuous white space between two words. Here you will Know technique, How to Replace Multiple Spaces in String with Single Space in SQL Server?. Its too simple logic which is easy to use.

https://swclass.com/Article/80/SQL-Server-Replace-Multiple-Spaces

[swclassdotcom]

1 minute script to Print web page desired content.

Most of the time we needs to print hidden bill-invoice or receipts HTML markups, without printing entire page contents. Here you will find the very short CSS and JavaScript magic to print only selected portion of the entire page at any place with in HTML contents.

<script>    var jsPrintAll = function () {        setTimeout(function () {            window.print();        }, 500);    } </script>

[swclassdotcom]

12 Easy steps to remove identity column in SQL server.

Sometimes we face a problem with primary key column in database with uncertain sequence generated due to deleting some data from table or SQL server sequence jump when SQL server restarts. To avoid this problem we plans to turn of auto sequence generated by identity column. It seems very easy in case of only one table. what happen if more than one table is present with in database with foreign keys dependency.

Step 1:   Create a duplicate table for backup tbdup_tbCountry.

Step 2:   Check data in both tables SWC.tbdup_tbCountry and SWC.tbCountry using count.

Step 3:   Add a new column for primary key column dup.

Step 4:   Copy data from primary key column to new column dup.

Step 5:   Match data of both primary key column and dup column.

Step 6:   Remove all constraints from table.

Step 7:   DELETE primary key column.

Step 8:   Add new column with same name as primary key column without any constraints.

Step 9:   Copy data from dup column to new created column (on which we will apply constraints).

Step 10:   Create all possible constraints with primary key.

Step 11:   If every this is good drop dup column.

Step 12:   Drop duplicate table.

Read more visit my web.