Visual Studio 2013 Web Site Project Template File Definition

Script Manager: http://blogs.msdn.com/b/webdev/archive/2012/09/21/asp-net-4-5-scriptmanager-improvements-in-webforms.aspx

Controlers & Routing: http://www.asp.net/mvc/overview/controllers-and-routing

Owin & Katana: http://www.asp.net/aspnet/overview/owin-and-katana

File -> New -> Website

Templates -> Visual Basic/C# -> ASP.NET Web Forms Site

Size:

vs.

File -> New -> Project

Templates -> Visual Basic/C# -> ASP.NET Web Forms Site

vs.

File -> New -> Project -> MVC 4 Web Application
In IE9: File -> Save as: 883 KB, 900 KB on Disk, 9 Files,
Request: 20 Get and Post Request
In IE9: File -> Save as: 1.00 MB, 1.01 MB on Disk, 9 Files,
Request: 18 Get and Post Request

 

The VisualStudioWebsiteTemplate Account

File new ->

Skills?

Have an intense passion for quality software engineering.
Be comfortable developing software in a variety of languages.
See themselves as a facilitator in rapid software development and continuous deployment.
Be able to see through foggy situations and layout comprehensive engineering plans.
Drive and influence a culture of test driven development
See themselves as part of a team that delivers products and ensures business success.
Is comfortable blurring the boundaries between jobs to ensure success.
Prefer to communicate actively rather than passively.
Be able to document ideas and concepts to facilitate communication (both written and graphically).
Use creative thinking and problem solving skill to tackle challenges problems.
Resist pressure to over commit and spread development thin / compromise quality.
Be comfortable managing conflicting priorities and broad business demands.
Be engaged in the software development community (blogs, conferences, etc.).

View Full Text Catalog Content

USE AdventureWorks2012;
SELECT *
FROM sys.dm_fts_index_keywords(DB_ID(‘AdventureWorks2012’), OBJECT_ID(‘Production.Document’) )
ORDER BY document_count

 

Column name Data type Description
keyword nvarchar(4000) The hexadecimal representation of the keyword stored inside the full-text index.

Note Note
OxFF represents the special character that indicates the end of a file or dataset.
display_term nvarchar(4000) The human-readable format of the keyword. This format is derived from the hexadecimal format.

Note Note
The display_term value for OxFF is “END OF FILE.”
column_id int ID of the column from which the current keyword was full-text indexed.
document_count int Number of documents or rows containing the current term.

 

You may need to rebuild to get the latest

ALTER FULLTEXT CATALOG chinese REBUILD WITH ACCENT_SENSITIVITY = OFF

Simplest Tutorial for AJAX, JQUERY, WebService Call returning JSON

This is a tutorial for calling a WebService from an ASMX page in it’s simplest form.

Code Behind

[codesyntax lang=”vbnet”]

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols

‘ To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
<System.Web.Script.Services.ScriptService()> _
<WebService(Namespace:=”http://tempuri.org/”)> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Public Class MyWebService
Inherits System.Web.Services.WebService

<WebMethod()> _
Public Function ReturnJSONData() As Person
Dim guy As New Person
guy.Name1 = “MeNameASMX”
guy.Age = 18
Return guy
End Function

End Class

Public Class Person
Private _name As String
Public Property Name1() As String
Get
Return _name
End Get
Set(ByVal value As String)
_name = value
End Set
End Property
Private _age As Int32
Public Property Age() As Int32
Get
Return _age
End Get
Set(ByVal value As Int32)
_age = value
End Set
End Property
End Class

[/codesyntax]

 

ASPX Page that will be calling the ASMX WebService

[codesyntax lang=”html4strict”]

<%@ Page Language=”VB” AutoEventWireup=”false” CodeFile=”WebService_ASMX_JQuery.aspx.vb” Inherits=”WebService_ASMX” %>

<!DOCTYPE html>

<html xmlns=”http://www.w3.org/1999/xhtml”>
<head runat=”server”>
<title></title>
</head>
<body>
<script src=”//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js”></script>

<form id=”form1″ runat=”server”>
<a href=”#” id=”Result”>Click for Call</a>
</form>

<script>
$(document).ready(function () {
$(“#Result”).click(function () {
$.ajax({
type: “POST”,
url: “MyWebService.asmx/ReturnJSONData”,
data: “{}”,
contentType: “application/json; charset=utf-8”,
dataType: “json”,
success: function (msg) {
alert(msg.d.Name1 + ‘:’ + msg.d.Age);
}
});
});
});
</script>

</body>
</html>

[/codesyntax]

Simplest Tutorial for AJAX, JQUERY, WebMethod Call returning JSON

Code Behind

[codesyntax lang=”vbnet”]

Imports System.Web.Services
Imports System.Web.Script.Services

<WebService(Namespace:="http://tempuri.org/")> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<System.Web.Script.Services.ScriptService> _
Partial Class _Default
Inherits System.Web.UI.Page
<WebMethod()> _
Public Shared Function ReturnJSONData() As Person
Dim guy As New Person
guy.Name1 = "Joe"
guy.Age = 8
Return guy
End Function
End Class

Public Class Person
Private _name As String
Public Property Name1() As String
Get
Return _name
End Get
Set(ByVal value As String)
_name = value
End Set
End Property
Private _age As Int32
Public Property Age() As Int32
Get
Return _age
End Get
Set(ByVal value As Int32)
_age = value
End Set
End Property
End Class

[/codesyntax]

 

ASPX Page

[codesyntax lang=”html4strict”]

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

    <form id="form1" runat="server">
        <a href="#" id="Result">Click for Call</a>
    </form>
</body>
<script>
    $(document).ready(function () {
            // Add the page method call as an onclick handler for the div.
            $("#Result").click(function () {
                $.ajax({
                    type: "POST",
                    url: "Default.aspx/ReturnJSONData",
                    data: "{}",
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function (msg) {
                        // Replace the div's content with the page method's return.
                        alert(msg.d.Name1 + ':' + msg.d.Age);
                    }
                });
            });
    });
</script>
</html>

[/codesyntax]