Author: Travis Gneiting

Passionate Professional .NET Developer

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]