MVC Reference URL

User Registeration with Database:

http://www.mindstick.com/Articles/f769698f-fed6-43eb-8e61-d7baaf713819/

http://dotnetawesome.blogspot.in/2014/03/how-to-create-user-registration-page-in-mvc4.html

http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-make-custom-login-register-and-logout-in-mvc-4-usin/

http://www.c-sharpcorner.com/uploadfile/b19d5a/custom-user-login-and-registration-page-in-Asp-Net-mvc3-with-razor-and-entity-framework/

http://geekswithblogs.net/dotNETvinz/archive/2011/06/03/asp.net-mvc-3-creating-a-simple-sign-up-form.aspx

http://www.techiesweb.net/


Scaffolding:

http://sampathloku.blogspot.in/2014/04/scaffolding-with-aspnet-mvc-5.html

https://www.asp.net/mvc/overview/getting-started/introduction/accessing-your-models-data-from-a-controller

https://visualstudiogallery.msdn.microsoft.com/811973ed-e6a9-4f38-b375-2fee9931bebd

What’s New in ASP.NET MVC 5 that make your MVC web 

http://www.dotnetcurry.com/showarticle.aspx?ID=975

ASP.NET MVC3 Vs MVC4 Vs MVC5

http://www.webdevelopmenthelp.net/2014/02/asp-net-mvc3-vs-mvc4-vs-mvc5.html

MVC5 Training Video's:

http://www.lynda.com/ASPNET-tutorials/ASPNET-MVC-5-Essential-Training/170334-2.html

http://azure.microsoft.com/en-us/documentation/articles/web-sites-dotnet-deploy-aspnet-mvc-app-membership-oauth-sql-database/

MVC5 Fundamentals:

http://www.pluralsight.com/courses/aspdotnet-mvc5-fundamentals

MVC Video:

https://www.youtube.com/watch?v=-pzwRwYlXMw&list=PL6n9fhu94yhVm6S8I2xd6nYz2ZORd7X2v

Arithmetic overflow error converting numeric to data type numeric

SELECT CAST(1234567891234567.34 AS NUMERIC(18,2))  --Works
SELECT CAST(1234567891234567.34 AS NUMERIC(18,10)) --fails with Arithmetic overflow error

it is clear that, in the first case from the statement NUMERIC(18,2) the total digits are 18 and 16 digits are available to the left of decimal, whereas 1234567891234567 are 16 digits. Hence, there is no error.
In the second case, from the statement NUMERIC(18,10), 8 digits are available to the left of decimal, but 1234567891234567 are 16 digits which is more than 8 digits. Hence, Arithmetic overflow error occurs.

Call WCF Service from jQuery Ajax JSON Example in Asp.net using C#

Reference:

http://www.aspdotnet-suresh.com/2013/12/call-wcf-service-from-jquery-ajax-json-example-aspnet.html

http://www.aspsnippets.com/Articles/Make-AJAX-JSON-call-to-ASP.Net-WCF-Service-using-jQuery-and-Javascript.aspx

http://pranayamr.blogspot.in/2010/12/steps-to-call-wcf-service-using-jquery.html

http://www.codeproject.com/Articles/664157/Consume-RESTful-Service-using-jQuery-in-Simple-S

http://www.c-sharpcorner.com/UploadFile/rohatash/calling-wcf-services-using-jquery/

call service from code behind & script(same/differnt domain)

http://stackoverflow.com/questions/25401585/call-service-from-code-behind-scriptsame-differnt-domain

Create and consume WCF Restful Service using an HttpClient

http://chsakell.com/2013/07/12/create-and-consume-wcf-restful-service-using-an-httpclient/

Bind DropDownList:

http://www.aspdotnet-suresh.com/2012/07/how-to-bind-dropdownlist-in-aspnet.html

Bind Gridview

http://www.aspsnippets.com/Articles/Bind-GridView-using-data-from-WCF-Service-in-ASPNet.aspx


Rest Services: (XML and JSON)

http://www.codeproject.com/Articles/105273/Create-RESTful-WCF-Service-API-Step-By-Step-Guide

-------------------------------------------------------------------------------------------------------------------------

http://www.bizcoder.com/index.php/2012/01/09/httpclient-it-lives-and-it-is-glorious/

Using SQL Server Metadata and Statistics to Build a Table

select o.name as [Name], sc.name as [Type], s.row_count as [Size]
 from sys.objects o        
left join sys.schemas sc on sc.schema_id = o.schema_id
left join (select object_id, sum(rows) as row_count from sys.partitions 
      where index_id < 2
    group by object_id) s on o.object_id = s.object_id
where o.type = 'U'
order by sc.name, o.name

Extract Table Meta Data (description, fields and their data types)

SELECT   u.name + '.' + t.name AS [table],
            td.value AS [table_desc],
      c.name AS [column],
      cd.value AS [column_desc]
FROM     sysobjects t
INNER JOIN  sysusers u
    ON  u.uid = t.uid
LEFT OUTER JOIN sys.extended_properties td
    ON  td.major_id = t.id
    AND  td.minor_id = 0
    AND  td.name = 'MS_Description'
INNER JOIN  syscolumns c
    ON  c.id = t.id
LEFT OUTER JOIN sys.extended_properties cd
    ON  cd.major_id = c.id
    AND  cd.minor_id = c.colid
    AND  cd.name = 'MS_Description'
WHERE t.type = 'u'
ORDER BY    t.name, c.colorder

Convert the XML to temp table using OPENXML in SQL Server

DECLARE @idoc int

DECLARE @doc varchar(1000)

SET @doc ='

<OutLookContact>

<Contact FirstName="Asif" LastName="Ghafoor" EmailAddress1="asifghafoor@my.web.pk" />

<Contact FirstName="Rameez" LastName="Ali" EmailAddress1="rameezali@my.web.pk" />

</OutLookContact>'

--Create an internal representation of the XML document.

EXEC sp_xml_preparedocument @idoc OUTPUT, @doc

-- Execute a SELECT statement that uses the OPENXML rowset provider.

DECLARE @Temp TABLE(FirstName VARCHAR(250),LastName VARCHAR(250),Email1 VARCHAR(250))  

INSERT INTO @Temp(FirstName,LastName,Email1)

SELECT *

FROM OPENXML (@idoc, '/OutLookContact/Contact',1)

WITH (FirstName varchar(50),LastName varchar(50),EmailAddress1 varchar(50))

select FirstName,LastName,Email1 from @Temp

jQuery User Interface

References:

http://jqueryui.com/demos/

http://jqfundamentals.com/chapter/events

http://www.tutorialspoint.com/jquery/jquery-events.htm

http://www.itfunda.com/aspnet-how-to-tips-and-tricks/Show/50

http://www.dotnet-tricks.com/Tutorial/jquerylist

http://www.jeasyui.com/

http://jqueryui.com/dialog/

JSON:

http://forums.asp.net/t/1651515.aspx?call+C+function+using+json

AJAX Cascading dropdownlist using JQuery:

http://www.aspsnippets.com/Articles/AJAX-Cascading-DropDownList-using-jQuery-in-ASP.Net.aspx