Search.Net.DBIndex	
        Search.Net Namespace	
DBIndex Class	
CreateDBIndex Method (Overloaded)	
FindInFields Method	
ReCreateDBIndex Method (Overloaded)	
Search Method (Overloaded)	
UpdateRecordsInIndex Method	
DBIndexAsynchronously Class	
CreateDBIndex Method (Overloaded)	
ReCreateDBIndex Method (Overloaded)	
UpdateRecordsInIndex Method	
   Search.Net.Fields Namespace	
FieldFind Class	
FieldName Property	
Value Property	
FieldProcedure Class	
FieldName Property	
NotOutPut Property	
Weight Property	
tType Property	
   Search.Net.Util Namespace	
Settings Class	
DirectoryStoredIndex Property	
MaxRecordsInResults Property	
PrincipalLanguageInData Property	
RegisterFor Property	
RegisteredVersion Property	
StopWordsAnotherLanguage Property	
Moviment Enumeration	
ProviderType Enumeration	
    
Search.Net.DBIndex

Search.Net Namespace
Classes
DBIndex, DBIndexAsynchronously
DBIndex Class
This component help to make search in your database very fast

System.Object
Search.Net.DBIndex

[Visual Basic] 
Public Class DBIndex 	

[C#] 
public class DBIndex 	
Requirements
Namespace: Search.Net
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)
Methods
CreateDBIndex, Equals (inherited from Object), FindInFields, GetHashCode (inherited from Object), GetType (inherited from Object), ReCreateDBIndex, ReferenceEquals (inherited from Object), Search, ToString (inherited from Object), UpdateRecordsInIndex
DBIndex.CreateDBIndex (System.String, System.String) Method
This method create a file index for results collect in execute the Stored Procedure And all fields define with same weight, and all fields in results

[Visual Basic] 
Public Shared Function CreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String _
) As Boolean 	

[C#] 
public static bool CreateDBIndex(
   string sProcedureName,
   string sConnectionString
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
Returns
Sucess
Remarks
Tips: - In Connection String define TimeOut iqual 0 (No limits), because same times the create of index take a large time - In Your Stored Procedure relate all fields for search results
Example

DBIndex.CreateDBIndex("USP_LIST_ALL_PRODUCTS","Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0")

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.CreateDBIndex (System.String, System.String, System.Collections.Generic.List`1) Method
This method create a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Function CreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldProcedure As List(Of FieldProcedure) _
) As Boolean 	

[C#] 
public static bool CreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldProcedure> lstFieldProcedure
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
lstFieldProcedure 
List of Fields extracts the result of StoreProcedure with information about Weigth or NotOutPut 
Returns
Sucess
Remarks
Tips: - In Connection String define TimeOut iqual 0 (No limits), because same times the create of index take a large time - In Your Stored Procedure relate all fields for search results - In Fields is possible define NotOutPut for enhance performance or weight for each field for score results
Example

var lstFields = new List«FieldProcedure»();
lstFields.Add(new FieldProcedure { FieldName = "PRD_NAME", NotOutPut = false, Weight = 2.0f });
lstFields.Add(new FieldProcedure { FieldName = "PRD_DESCRIPTION", NotOutPut = true});
DBIndex.CreateDBIndex("USP_LIST_ALL_PRODUCTS", "Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0", lstFields);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.FindInFields Method
This method locate for records base in fields and values iqual Is another way to locate information fast, but not work like search

[Visual Basic] 
Public Shared Function FindInFields( _
   ByVal lstFieldFind As List(Of FieldFind), _
   ByVal sProcedureName As String, _
   ByVal bOperatorAND As Boolean _
) As DataTable 	

[C#] 
public static DataTable FindInFields(
   List<FieldFind> lstFieldFind,
   string sProcedureName,
   bool bOperatorAND
) 	
Parameters 
lstFieldFind 
List of FieldsFind 
sProcedureName 
Stored Procedure Name 
bOperatorAND 
Type of Operator 
Returns
Records in DataTable
Remarks
Tips: - Set the Operator for AND this results more precise and fast - DataTable Schema is mirror of Store Procedure Schema Returns
Example

var lstFields = new List«FieldFind»();
lstFields.Add(new FieldFind { FieldName = "PRD_CODE", Value = 120 });
lstFields.Add(new FieldFind { FieldName = "PRD_SECTION_NAME", Value = "LAUNDRY"});
DBIndex.UpdateRecordsInIndex("USP_LIST_ALL_PRODUCTS", lstFields, true);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1) Method
This method recreate a file index for results colect in execute the Stored Procedure And not is possible access the index file in process

[Visual Basic] 
Public Shared Function ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldProcedure As List(Of FieldProcedure) _
) As Boolean 	

[C#] 
public static bool ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldProcedure> lstFieldProcedure
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
lstFieldProcedure 
List of Fields extracts the result of StoreProcedure with information about Weigth or NotOutPut 
Returns
Sucess
Remarks
Tips: - In Connection String define TimeOut iqual 0 (No limits), because same times the create of index take a large time - In Your Stored Procedure relate all fields for search results - In Fields is possible define NotOutPut for enhance performance or weight for each field for score results
Example

var lstFields = new List«FieldProcedure»();
lstFields.Add(new FieldProcedure { FieldName = "PRD_NAME", NotOutPut = false, Weight = 2.0f });
lstFields.Add(new FieldProcedure { FieldName = "PRD_DESCRIPTION", NotOutPut = true});
DBIndex.ReCreateDBIndex("USP_LIST_ALL_PRODUCTS", "Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0", lstFields);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.ReCreateDBIndex (System.String, System.String) Method
This method recreate a file index for results colect in execute the Stored Procedure And all fields define with same weight, and all fields in results And not is possible access the index file in process

[Visual Basic] 
Public Shared Function ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String _
) As Boolean 	

[C#] 
public static bool ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
Returns
Sucess
Remarks
Tips: - In Connection String define TimeOut iqual 0 (No limits), because same times the create of index take a large time - In Your Stored Procedure relate all fields for search results
Example

DBIndex.ReCreateDBIndex("USP_LIST_ALL_PRODUCTS", "Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0");

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.ReCreateDBIndex (System.String, System.String, System.Boolean) Method
This method recreate a file index for results colect in execute the Stored Procedure And all fields define with same weight, and all fields in results

[Visual Basic] 
Public Shared Function ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal bFastSwap As Boolean _
) As Boolean 	

[C#] 
public static bool ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   bool bFastSwap
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
bFastSwap 
Define type of ReCreate 
Returns
Sucess
Remarks
Tips: - In Connection String define TimeOut iqual 0 (No limits), because same times the create of index take a large time - In Your Stored Procedure relate all fields for search results - FastSwap garanty the old index file access, when the finish the ReCreate the system move to new to old
Example

DBIndex.ReCreateDBIndex("USP_LIST_ALL_PRODUCTS", "Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0", true);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.Boolean) Method
This method recreate a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Function ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldProcedure As List(Of FieldProcedure), _
   ByVal bFastSwap As Boolean _
) As Boolean 	

[C#] 
public static bool ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldProcedure> lstFieldProcedure,
   bool bFastSwap
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
lstFieldProcedure 
List of Fields extracts the result of StoreProcedure with information about Weigth or NotOutPut 
bFastSwap 
Define type of ReCreate 
Returns
Sucess
Remarks
Tips: - In Connection String define TimeOut iqual 0 (No limits), because same times the create of index take a large time - In Your Stored Procedure relate all fields for search results - In Fields is possible define NotOutPut for enhance performance or weight for each field for score results - FastSwap garanty the old index file access, when the finish the ReCreate the system move to new to old
Example

var lstFields = new List«FieldProcedure»();
lstFields.Add(new FieldProcedure { FieldName = "PRD_NAME", NotOutPut = false, Weight = 2.0f });
lstFields.Add(new FieldProcedure { FieldName = "PRD_DESCRIPTION", NotOutPut = true});
DBIndex.ReCreateDBIndex("USP_LIST_ALL_PRODUCTS", "Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0", lstFields, true);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.Search (System.String, System.String, System.Single, System.Int32) Method
This method search content in your DBIndex And not paging results And Order is Score about the terms

[Visual Basic] 
Public Shared Function Search( _
   ByVal sTerm As String, _
   ByVal sProcedureName As String, _
   ByVal fApproximation As Single, _
   ByRef iNumberRecords As Integer _
) As DataTable 	

[C#] 
public static DataTable Search(
   string sTerm,
   string sProcedureName,
   float fApproximation,
   out int iNumberRecords
) 	
Parameters 
sTerm 
Search Terms 
sProcedureName 
Stored Procedure Name 
fApproximation 
This value to define the variants of terms accept in results 
iNumberRecords 
Numbers of Total Records found 
Returns
Records in DataTable
Remarks
Tips: - In Terms use wildcards (*,?), don´t separete terms with ',', use simples space - Define Approximation for words similiarys, 1 = exactly «» 0.01 = anythings - DataTable Schema is mirror of Store Procedure Schema Returns
Example

var iRecords = 0;
DBIndex.Search("Clocks","USP_LIST_ALL_PRODUCTS", 0.8, iRecords);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.Search (System.String, System.String, System.Int32, System.Int32, System.Single, System.String, System.Boolean, System.Int32) Method
This method search content in your DBIndex

[Visual Basic] 
Public Shared Function Search( _
   ByVal sTerm As String, _
   ByVal sProcedureName As String, _
   ByVal iPageIndex As Integer, _
   ByVal iPageSize As Integer, _
   ByVal fApproximation As Single, _
   ByVal sOrderField As String, _
   ByVal bReverse As Boolean, _
   ByRef iNumberRecords As Integer _
) As DataTable 	

[C#] 
public static DataTable Search(
   string sTerm,
   string sProcedureName,
   int iPageIndex,
   int iPageSize,
   float fApproximation,
   string sOrderField,
   bool bReverse,
   out int iNumberRecords
) 	
Parameters 
sTerm 
Search Terms 
sProcedureName 
Stored Procedure Name 
iPageIndex 
Page Index 
iPageSize 
Size Page 
fApproximation 
This value to define the variants of terms accept in results 
sOrderField 
Field to Order Results 
bReverse 
Order Reverse 
iNumberRecords 
Numbers of Total Records found 
Returns
Records in DataTable
Remarks
Tips: - In Terms use wildcards (*,?), don´t separete terms with ',', use simples space - PageSize possible define with -1, and the limit is 10000 or setting 'Search.Net.DBIndex.Results.MaxRecordsInResults' - Page start with position 0 (zero) - Define Approximation for words similiarys, 1 = exactly «» 0.01 = anythings - Field Order Name should be exactly Field Name in Results - DataTable Schema is mirror of Store Procedure Schema Returns
Example

var iRecords = 0;
DBIndex.Search("Clocks","USP_LIST_ALL_PRODUCTS", 0, 100, 0.8, "PRD_PRICE", true, iRecords);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.Search (System.String, System.String, System.Single, System.String, System.Boolean, System.Int32) Method
This method search content in your DBIndex And not paging results

[Visual Basic] 
Public Shared Function Search( _
   ByVal sTerm As String, _
   ByVal sProcedureName As String, _
   ByVal fApproximation As Single, _
   ByVal sOrderField As String, _
   ByVal bReverse As Boolean, _
   ByRef iNumberRecords As Integer _
) As DataTable 	

[C#] 
public static DataTable Search(
   string sTerm,
   string sProcedureName,
   float fApproximation,
   string sOrderField,
   bool bReverse,
   out int iNumberRecords
) 	
Parameters 
sTerm 
Search Terms 
sProcedureName 
Stored Procedure Name 
fApproximation 
This value to define the variants of terms accept in results 
sOrderField 
Field to Order Results 
bReverse 
Order Reverse 
iNumberRecords 
Numbers of Total Records found 
Returns
Records in DataTable
Remarks
Tips: - In Terms use wildcards (*,?), don´t separete terms with ',', use simples space - Define Approximation for words similiarys, 1 = exactly «» 0.01 = anythings - Field Order Name should be exactly Field Name in Results - DataTable Schema is mirror of Store Procedure Schema Returns
Example

var iRecords = 0;
DBIndex.Search("Clocks","USP_LIST_ALL_PRODUCTS", 0.8, "PRD_PRICE", true, iRecords);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.Search (System.String, System.String, System.Int32) Method
This method search content in your DBIndex with basic functions And not paging results And the terms math exactly And Order is Score about the terms

[Visual Basic] 
Public Shared Function Search( _
   ByVal sTerm As String, _
   ByVal sProcedureName As String, _
   ByRef iNumberRecords As Integer _
) As DataTable 	

[C#] 
public static DataTable Search(
   string sTerm,
   string sProcedureName,
   out int iNumberRecords
) 	
Parameters 
sTerm 
Search Terms 
sProcedureName 
Stored Procedure Name 
iNumberRecords 
Numbers of Total Records found 
Returns
Records in DataTable
Remarks
Tips: - In Terms use wildcards (*,?), don´t separete terms with ',', use simples space - DataTable Schema is mirror of Store Procedure Schema Returns
Example

var iRecords = 0;
DBIndex.Search("Clocks","USP_LIST_ALL_PRODUCTS", iRecords);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndex.UpdateRecordsInIndex Method
Use this for Control the Updates of Records in Index This way is better for ReCreate or Create Index for update informations

[Visual Basic] 
Public Shared Function UpdateRecordsInIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldFind As List(Of FieldFind), _
   ByVal eMoviment As Moviment _
) As Integer 	

[C#] 
public static int UpdateRecordsInIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldFind> lstFieldFind,
   Moviment eMoviment
) 	
Parameters 
sProcedureName 
Stored Procedure Name 
sConnectionString 
Connection String Width SQL SERVER DataBase 
lstFieldFind 
List of FieldFind [Exists in Where of Stored Procedure] 
eMoviment 
Type of Moviment for Update 
Returns
Number affected records
Remarks
In your Stored Procedure any Fields inform, must exists in where cause  Tips: - When two fields informed the condition is always "AND" - If you prefer user always Moviment Type Update, even for Insert,   this way a record garanty is deleted after inserted
Example

var lstFields = new List«FieldFind»();
lstFields.Add(new FieldFind { FieldName = "PRD_CODE", Value = 120 });
lstFields.Add(new FieldFind { FieldName = "PRD_SECTION_CODE", Value = 12});
DBIndex.UpdateRecordsInIndex("USP_LIST_ALL_PRODUCTS", "Data Source=SERVER;Initial Catalog=dbDATABASE;User=USER;password=PASSWORD;Connect Timeout=0", lstFields, Moviment.Update);

Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndex
DBIndexAsynchronously Class
This class provides the possible methods for asynchronous calls

System.Object
Search.Net.DBIndexAsynchronously

[Visual Basic] 
Public Class DBIndexAsynchronously 	

[C#] 
public class DBIndexAsynchronously 	
Requirements
Namespace: Search.Net
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)
Methods
CreateDBIndex, Equals (inherited from Object), GetHashCode (inherited from Object), GetType (inherited from Object), ReCreateDBIndex, ReferenceEquals (inherited from Object), ToString (inherited from Object), UpdateRecordsInIndex
DBIndexAsynchronously.CreateDBIndex (System.String, System.String, System.AsyncCallback) Method
Use this method for asynchronous process to create a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Sub CreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void CreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously
DBIndexAsynchronously.CreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.AsyncCallback) Method
Use this method for asynchronous process to create a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Sub CreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldProcedure As List(Of FieldProcedure), _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void CreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldProcedure> lstFieldProcedure,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
lstFieldProcedure 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously
DBIndexAsynchronously.ReCreateDBIndex (System.String, System.String, System.AsyncCallback) Method
Use this method for asynchronous process to recreate a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Sub ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously
DBIndexAsynchronously.ReCreateDBIndex (System.String, System.String, System.Boolean, System.AsyncCallback) Method
Use this method for asynchronous process to recreate a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Sub ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal bFastSwap As Boolean, _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   bool bFastSwap,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
bFastSwap 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously
DBIndexAsynchronously.ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.Boolean, System.AsyncCallback) Method
Use this method for asynchronous process to recreate a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Sub ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldProcedure As List(Of FieldProcedure), _
   ByVal bFastSwap As Boolean, _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldProcedure> lstFieldProcedure,
   bool bFastSwap,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
lstFieldProcedure 
 
bFastSwap 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously
DBIndexAsynchronously.ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.AsyncCallback) Method
Use this method for asynchronous process to recreate a file index for results colect in execute the Stored Procedure

[Visual Basic] 
Public Shared Sub ReCreateDBIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldProcedure As List(Of FieldProcedure), _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void ReCreateDBIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldProcedure> lstFieldProcedure,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
lstFieldProcedure 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously
DBIndexAsynchronously.UpdateRecordsInIndex Method
Use this method for asynchronous process to Updates of Records in Index

[Visual Basic] 
Public Shared Sub UpdateRecordsInIndex( _
   ByVal sProcedureName As String, _
   ByVal sConnectionString As String, _
   ByVal lstFieldFind As List(Of FieldFind), _
   ByVal eMoviment As Moviment, _
   ByVal aCallBack As AsyncCallback _
) 	

[C#] 
public static void UpdateRecordsInIndex(
   string sProcedureName,
   string sConnectionString,
   List<FieldFind> lstFieldFind,
   Moviment eMoviment,
   AsyncCallback aCallBack
) 	
Parameters 
sProcedureName 
 
sConnectionString 
 
lstFieldFind 
 
eMoviment 
 
aCallBack 
Method Invoke after the finish the process. (This param is not necessary) 
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: DBIndexAsynchronously

Search.Net.Fields Namespace
Classes
FieldFind, FieldProcedure
FieldFind Class
This object use to create a list of field and value for find ou update records in DBIndex

System.Object
Search.Net.Fields.FieldFind

[Visual Basic] 
<Serializable()> _
Public Class FieldFind 	

[C#] 
[Serializable()]
public class FieldFind 	
Requirements
Namespace: Search.Net.Fields
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)
Properties
FieldName, Value
Methods
Equals (inherited from Object), GetHashCode (inherited from Object), GetType (inherited from Object), ReferenceEquals (inherited from Object), ToString (inherited from Object)
FieldFind.FieldName Property
Field Name used in conditions of Stored Procedure

[Visual Basic] 
Public Property FieldName() As String 	

[C#] 
public string FieldName {get; set;} 	
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: FieldFind
FieldFind.Value Property
Value of Field

[Visual Basic] 
Public Property Value() As Object 	

[C#] 
public object Value {get; set;} 	
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: FieldFind
FieldProcedure Class
This object used for informe the index fields of result procedure to Create ou ReCreate DBIndex

System.Object
Search.Net.Fields.FieldProcedure

[Visual Basic] 
<Serializable()> _
Public Class FieldProcedure 	

[C#] 
[Serializable()]
public class FieldProcedure 	
Requirements
Namespace: Search.Net.Fields
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)
Properties
FieldName, NotOutPut, Weight, tType
Methods
Equals (inherited from Object), GetHashCode (inherited from Object), GetType (inherited from Object), ReferenceEquals (inherited from Object), ToString (inherited from Object)
FieldProcedure.FieldName Property
Field Name inside de Stored Procedure

[Visual Basic] 
Public Property FieldName() As String 	

[C#] 
public string FieldName {get; set;} 	
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: FieldProcedure
FieldProcedure.NotOutPut Property
If field not necessary show in results, but relevante for search

[Visual Basic] 
Public Property NotOutPut() As Boolean 	

[C#] 
public bool NotOutPut {get; set;} 	
Remarks
Set true enhance compress the file Index
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: FieldProcedure
FieldProcedure.Weight Property
Define Weight of Field in Score of Relevance in Search Results

[Visual Basic] 
Public Property Weight() As Single 	

[C#] 
public float Weight {get; set;} 	
Remarks
Default value is 1, raise this for diferents pounds in analyse score
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: FieldProcedure
FieldProcedure.tType Property
Type of Field [Not necessary inform, the search extract for the table info

[Visual Basic] 
Public Property tType() As Type 	

[C#] 
public Type tType {get; set;} 	
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: FieldProcedure

Search.Net.Util Namespace
Classes
Settings
Enumerations
Moviment, ProviderType
Settings Class
General Setting for Search.Net

System.Object
Search.Net.Util.Settings

[Visual Basic] 
Public Class Settings 	

[C#] 
public class Settings 	
Requirements
Namespace: Search.Net.Util
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)
Properties
DirectoryStoredIndex, MaxRecordsInResults, PrincipalLanguageInData, RegisterFor, RegisteredVersion, StopWordsAnotherLanguage
Methods
Equals (inherited from Object), GetHashCode (inherited from Object), GetType (inherited from Object), ReferenceEquals (inherited from Object), ToString (inherited from Object)
Settings.DirectoryStoredIndex Property
This is main directory to stored index files

[Visual Basic] 
Public ReadOnly Shared Property DirectoryStoredIndex() As String 	

[C#] 
public static string DirectoryStoredIndex {get;} 	
Property Value
Complete Fisical Path
Remarks
Default value is Currenty Directory Application  If necessary define, create a single key in appsettings with name: Search.Net.DBIndex.DirectoryInfo.StoredIndex <example>     c:\\temp </example>
Example
c:\\temp
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: Settings
Settings.MaxRecordsInResults Property
Number of Maximun Records on Results

[Visual Basic] 
Public ReadOnly Shared Property MaxRecordsInResults() As Integer 	

[C#] 
public static int MaxRecordsInResults {get;} 	
Property Value
Number of Records
Remarks
For Unregisted User: Maximun Records is 20 items  For only registred version: Default value is 10.000 items  If necessary define, create a single key in appsettings with name: Search.Net.DBIndex.Results.MaxRecordsInResults <example>     20000 </example>
Example
20000
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: Settings
Settings.PrincipalLanguageInData Property
This is Language to used in Analyser Index

[Visual Basic] 
Public ReadOnly Shared Property PrincipalLanguageInData() As String 	

[C#] 
public static string PrincipalLanguageInData {get;} 	
Property Value
Name of Language
Remarks
Default value is pt-BR If necessary change, create a single key in appsetting with name: Search.Net.DBIndex.Principal.Language.InData <example>     pt-BR, en-US, Another </example>
Example
pt-BR, en-US, Another
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: Settings
Settings.RegisterFor Property
Name of Register User

[Visual Basic] 
Public ReadOnly Shared Property RegisterFor() As String 	

[C#] 
public static string RegisterFor {get;} 	
Property Value
Register Name
Remarks
If decide buy the license, visit www.dragonsoft.com.br/searchDBIndex
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: Settings
Settings.RegisteredVersion Property
Condition of Register

[Visual Basic] 
Public ReadOnly Shared Property RegisteredVersion() As Boolean 	

[C#] 
public static bool RegisteredVersion {get;} 	
Property Value
Condition
Remarks
If decide buy the license, visit www.dragonsoft.com.br/searchDBIndex
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: Settings
Settings.StopWordsAnotherLanguage Property
This is List of Stop Word for Analyser

[Visual Basic] 
Public ReadOnly Shared Property StopWordsAnotherLanguage() As String() 	

[C#] 
public static string[] StopWordsAnotherLanguage {get;} 	
Property Value
Word's Array
Remarks
For Portuguese ou English not used for this fields, because all word define internal Now, if used another language, create a single key in appsetting with name split with ',': Search.Net.DBIndex.StopWords.AnotherLanguage <example>     this, that, another, and, or, etc </example>
Example
this, that, another, and, or, etc
Requirements
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
See Also
Applies to: Settings
Moviment Enumeration
Define type of Moviment of Record(s) for Update Index

Requirements
Namespace: Search.Net.Util
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)
ProviderType Enumeration
Enum to Provider Type for the Connection with Server DataBase

Requirements
Namespace: Search.Net.Util
Platforms: Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
Assembly: Search.Net.DBIndex (in Search.Net.DBIndex.dll)

Index
CreateDBIndex (System.String, System.String) Method {Search.Net.DBIndex}, 
CreateDBIndex (System.String, System.String, System.AsyncCallback) Method {Search.Net.DBIndexAsynchronously}, 
CreateDBIndex (System.String, System.String, System.Collections.Generic.List`1) Method, 
CreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.AsyncCallback) Method {Search.Net.DBIndexAsynchronously}, 
DBIndex Class, 
DBIndexAsynchronously Class, 
DirectoryStoredIndex Property, 
FieldFind Class, 
FieldName Property {Search.Net.Fields.FieldFind}, 
FieldName Property {Search.Net.Fields.FieldProcedure}, 
FieldProcedure Class, 
FindInFields Method, 
MaxRecordsInResults Property, 
Moviment Enumeration, 
NotOutPut Property, 
PrincipalLanguageInData Property, 
ProviderType Enumeration, 
ReCreateDBIndex (System.String, System.String) Method {Search.Net.DBIndex}, 
ReCreateDBIndex (System.String, System.String, System.AsyncCallback) Method {Search.Net.DBIndexAsynchronously}, 
ReCreateDBIndex (System.String, System.String, System.Boolean) Method, 
ReCreateDBIndex (System.String, System.String, System.Boolean, System.AsyncCallback) Method {Search.Net.DBIndexAsynchronously}, 
ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1) Method, 
ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.AsyncCallback) Method {Search.Net.DBIndexAsynchronously}, 
ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.Boolean) Method, 
ReCreateDBIndex (System.String, System.String, System.Collections.Generic.List`1, System.Boolean, System.AsyncCallback) Method {Search.Net.DBIndexAsynchronously}, 
RegisterFor Property, 
RegisteredVersion Property, 
Search (System.String, System.String, System.Int32) Method, 
Search (System.String, System.String, System.Int32, System.Int32, System.Single, System.String, System.Boolean, System.Int32) Method, 
Search (System.String, System.String, System.Single, System.Int32) Method, 
Search (System.String, System.String, System.Single, System.String, System.Boolean, System.Int32) Method, 
Search.Net Namespace, 
Search.Net.DBIndex, 
Search.Net.Fields Namespace, 
Search.Net.Util Namespace, 
Settings Class, 
StopWordsAnotherLanguage Property, 
UpdateRecordsInIndex Method {Search.Net.DBIndexAsynchronously}, 
UpdateRecordsInIndex Method {Search.Net.DBIndex}, 
Value Property, 
Weight Property, 
tType Property,