Getting started with AngularJS and ASP.NET MVC

http://www.codeproject.com/Articles/806029/Getting-started-with-AngularJS-and-ASP-NET-MVC-Par

CRUD with SPA, ASP.NET Web API and Angular.js

http://www.codeproject.com/Articles/832288/CRUD-with-SPA-ASP-NET-Web-API-and-Angular-js

Jumpstart KnockoutJS with ASP.NET MVC/Web Api

http://www.codeproject.com/Articles/755386/Jumpstart-KnockoutJS-with-ASP-NET-MVC-Web-Api
http://www.devcurry.com/2013/08/building-knockoutjs-based-client-for_16.html

Single Page Application with ASP.NET Web API and Angular.js

http://www.asp.net/web-api/overview/getting-started-with-aspnet-web-api/build-a-single-page-application-spa-with-aspnet-web-api-and-angularjs

C# Tutorials

https://msdn.microsoft.com/en-us/library/aa288436(v=vs.71).aspx

C# Single Page Application

Single Page Application: KnockoutJS
http://www.asp.net/single-page-application/overview/introduction/knockoutjs-template


Single Page Application (SPA) Using AngularJS
http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/single-page-application-spa-using-angularjs-web-api-and-m/

C# WEB API

http://www.asp.net/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api

https://msdn.microsoft.com/en-us/library/hh833994(v=vs.108).aspx

Accenture .Net interview questions

Data Structure & Algorithms
c# exceptional handling
Structured Exception Handling in C#
abstract class and interface difference
c# must implement method
c# must inherit
advantages of using interfaces c#
c# stack and heap
c# how to change stack to head
c# how to change heap to stack
c# struct vs class
c# struct data type
c# finalize vs dispose
c# close and dispose
c# generics
c# garbage collector
if i write custom class, should i use dispose or not? Why?
c# using
c# idisposable
c# asynchronous programming
C# how to wait for asynchronous method response in main method
asp.net viewstate
asp.net how to hide view state
how to find duplicate values in Array, write logic
asp.net session management
asp.net page life cycle
asp.net global.asax
How can i capture exception in asp.net global.asax

C# difference between connection.close() and connection.Dispose()

conn.Close(); //If you use this, no need to initialize SqlConnection , you can open using conn.Open();

//conn.Dispose();//If you use this, it completely release the connection object and cannot be reopen just calling Open method. We will have re-initialize the Connection object


So always use conn.Close();

Sample code............


using System;using System.Data;using System.Data.SqlClient;/// <summary>
/// Demonstrates how to work with SqlConnection objects/// </summary>class SqlConnectionDemo
{    static void Main()
    {        // 1. Instantiate the connection        SqlConnection conn = new SqlConnection(
            "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI");

        SqlDataReader rdr = null;
        try        {            // 2. Open the connection            conn.Open();
            // 3. Pass the connection to a command object            SqlCommand cmd = new SqlCommand("select * from Customers", conn);
            //
            // 4. Use the connection
            //

            // get query results            rdr = cmd.ExecuteReader();
            // print the CustomerID of each record            while (rdr.Read())
            {
                Console.WriteLine(rdr[0]);
            }
        }
        finally        {            // close the reader            if (rdr != null)
            {
                rdr.Close();
            }
            // 5. Close the connection            if (conn != null)
            {
                conn.Close(); //If you use this, no need to initialize SqlConnection , you can open using conn.Open();

//conn.Dispose();//If you use this, it completely release the connection object and cannot be reopen just calling Open method. We will have re-initialize the Connection object
            }
        }
    }
}

flights compare

http://www.kayak.com/flights

Get item CHARACTERISTIC values of an Item

select * from innovator.PART where keyed_name='P00001'

-- Get ID from above results and use in the below query...

select  * from innovator.PART_ITEM_CHARACTERISTIC_VALUE where SOURCE_ID='36A093C8325A44698684354FAF6E3425'

--Above query will give all item characteristic values of P00001. This result will have "Display_Value" and "Text_value"