Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » Data Access » Downloads
 
Add your own
alternative version

Tagged as

How to Create a Relevance Based Search Query for SQL

, 31 Dec 2010 CPOL
Arrange Results to get the most relevant result first...
RelevanceSearch.zip
RelevanceSearch
bin
Debug
Car_Showroom.mdb
DatabaseRelevance.exe
DatabaseRelevance.pdb
DatabaseRelevance.vshost.exe
DatabaseRelevance.vshost.exe.manifest
My Project
Application.myapp
Settings.settings
obj
Debug
DatabaseRelevance.exe
DatabaseRelevance.Main.resources
DatabaseRelevance.pdb
DatabaseRelevance.Resources.resources
DatabaseRelevance.vbproj.GenerateResource.Cache
RelevanceSearch.vbproj.GenerateResource.Cache
TempPE
My Project.Resources.Designer.vb.dll
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class Main
    Inherits System.Windows.Forms.Form

    'Form overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()> _
    Protected Overrides Sub Dispose(ByVal disposing As Boolean)
        Try
            If disposing AndAlso components IsNot Nothing Then
                components.Dispose()
            End If
        Finally
            MyBase.Dispose(disposing)
        End Try
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> _
    Private Sub InitializeComponent()
        Me.grpBox2 = New System.Windows.Forms.GroupBox
        Me.cmbBrakes = New System.Windows.Forms.ComboBox
        Me.cmbLock = New System.Windows.Forms.ComboBox
        Me.cmbFuel = New System.Windows.Forms.ComboBox
        Me.cmbEngine = New System.Windows.Forms.ComboBox
        Me.cmbSteering = New System.Windows.Forms.ComboBox
        Me.lblBrakes = New System.Windows.Forms.Label
        Me.lblEngine = New System.Windows.Forms.Label
        Me.lblFuel = New System.Windows.Forms.Label
        Me.lblLock = New System.Windows.Forms.Label
        Me.lblSteering = New System.Windows.Forms.Label
        Me.DataGridView1 = New System.Windows.Forms.DataGridView
        Me.btnSearch = New System.Windows.Forms.Button
        Me.grpBox2.SuspendLayout()
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SuspendLayout()
        '
        'grpBox2
        '
        Me.grpBox2.BackColor = System.Drawing.Color.Transparent
        Me.grpBox2.Controls.Add(Me.cmbBrakes)
        Me.grpBox2.Controls.Add(Me.cmbLock)
        Me.grpBox2.Controls.Add(Me.cmbFuel)
        Me.grpBox2.Controls.Add(Me.cmbEngine)
        Me.grpBox2.Controls.Add(Me.cmbSteering)
        Me.grpBox2.Controls.Add(Me.lblBrakes)
        Me.grpBox2.Controls.Add(Me.lblEngine)
        Me.grpBox2.Controls.Add(Me.lblFuel)
        Me.grpBox2.Controls.Add(Me.lblLock)
        Me.grpBox2.Controls.Add(Me.lblSteering)
        Me.grpBox2.Location = New System.Drawing.Point(26, 27)
        Me.grpBox2.Name = "grpBox2"
        Me.grpBox2.Size = New System.Drawing.Size(239, 181)
        Me.grpBox2.TabIndex = 14
        Me.grpBox2.TabStop = False
        Me.grpBox2.Text = "Search Parameters"
        '
        'cmbBrakes
        '
        Me.cmbBrakes.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cmbBrakes.FormattingEnabled = True
        Me.cmbBrakes.Location = New System.Drawing.Point(101, 135)
        Me.cmbBrakes.Name = "cmbBrakes"
        Me.cmbBrakes.Size = New System.Drawing.Size(121, 21)
        Me.cmbBrakes.TabIndex = 27
        '
        'cmbLock
        '
        Me.cmbLock.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cmbLock.FormattingEnabled = True
        Me.cmbLock.Location = New System.Drawing.Point(100, 106)
        Me.cmbLock.Name = "cmbLock"
        Me.cmbLock.Size = New System.Drawing.Size(121, 21)
        Me.cmbLock.TabIndex = 26
        '
        'cmbFuel
        '
        Me.cmbFuel.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cmbFuel.FormattingEnabled = True
        Me.cmbFuel.Location = New System.Drawing.Point(100, 77)
        Me.cmbFuel.Name = "cmbFuel"
        Me.cmbFuel.Size = New System.Drawing.Size(121, 21)
        Me.cmbFuel.TabIndex = 25
        '
        'cmbEngine
        '
        Me.cmbEngine.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cmbEngine.FormattingEnabled = True
        Me.cmbEngine.Location = New System.Drawing.Point(101, 49)
        Me.cmbEngine.Name = "cmbEngine"
        Me.cmbEngine.Size = New System.Drawing.Size(121, 21)
        Me.cmbEngine.TabIndex = 24
        '
        'cmbSteering
        '
        Me.cmbSteering.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.cmbSteering.FormattingEnabled = True
        Me.cmbSteering.Location = New System.Drawing.Point(100, 23)
        Me.cmbSteering.Name = "cmbSteering"
        Me.cmbSteering.Size = New System.Drawing.Size(121, 21)
        Me.cmbSteering.TabIndex = 17
        '
        'lblBrakes
        '
        Me.lblBrakes.AutoSize = True
        Me.lblBrakes.Location = New System.Drawing.Point(20, 143)
        Me.lblBrakes.Name = "lblBrakes"
        Me.lblBrakes.Size = New System.Drawing.Size(40, 13)
        Me.lblBrakes.TabIndex = 11
        Me.lblBrakes.Text = "Brakes"
        '
        'lblEngine
        '
        Me.lblEngine.AutoSize = True
        Me.lblEngine.Location = New System.Drawing.Point(20, 57)
        Me.lblEngine.Name = "lblEngine"
        Me.lblEngine.Size = New System.Drawing.Size(40, 13)
        Me.lblEngine.TabIndex = 9
        Me.lblEngine.Text = "Engine"
        '
        'lblFuel
        '
        Me.lblFuel.AutoSize = True
        Me.lblFuel.Location = New System.Drawing.Point(20, 85)
        Me.lblFuel.Name = "lblFuel"
        Me.lblFuel.Size = New System.Drawing.Size(27, 13)
        Me.lblFuel.TabIndex = 5
        Me.lblFuel.Text = "Fuel"
        '
        'lblLock
        '
        Me.lblLock.AutoSize = True
        Me.lblLock.Location = New System.Drawing.Point(20, 114)
        Me.lblLock.Name = "lblLock"
        Me.lblLock.Size = New System.Drawing.Size(31, 13)
        Me.lblLock.TabIndex = 7
        Me.lblLock.Text = "Lock"
        '
        'lblSteering
        '
        Me.lblSteering.AutoSize = True
        Me.lblSteering.Location = New System.Drawing.Point(20, 31)
        Me.lblSteering.Name = "lblSteering"
        Me.lblSteering.Size = New System.Drawing.Size(46, 13)
        Me.lblSteering.TabIndex = 6
        Me.lblSteering.Text = "Steering"
        '
        'DataGridView1
        '
        Me.DataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize
        Me.DataGridView1.Location = New System.Drawing.Point(281, 32)
        Me.DataGridView1.Name = "DataGridView1"
        Me.DataGridView1.Size = New System.Drawing.Size(243, 258)
        Me.DataGridView1.TabIndex = 15
        '
        'btnSearch
        '
        Me.btnSearch.Location = New System.Drawing.Point(26, 214)
        Me.btnSearch.Name = "btnSearch"
        Me.btnSearch.Size = New System.Drawing.Size(116, 37)
        Me.btnSearch.TabIndex = 16
        Me.btnSearch.Text = "Search"
        Me.btnSearch.UseVisualStyleBackColor = True
        '
        'Main
        '
        Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
        Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
        Me.ClientSize = New System.Drawing.Size(542, 302)
        Me.Controls.Add(Me.btnSearch)
        Me.Controls.Add(Me.DataGridView1)
        Me.Controls.Add(Me.grpBox2)
        Me.Name = "Main"
        Me.Text = "Relevance Search"
        Me.grpBox2.ResumeLayout(False)
        Me.grpBox2.PerformLayout()
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub
    Friend WithEvents grpBox2 As System.Windows.Forms.GroupBox
    Friend WithEvents cmbBrakes As System.Windows.Forms.ComboBox
    Friend WithEvents cmbLock As System.Windows.Forms.ComboBox
    Friend WithEvents cmbFuel As System.Windows.Forms.ComboBox
    Friend WithEvents cmbEngine As System.Windows.Forms.ComboBox
    Friend WithEvents cmbSteering As System.Windows.Forms.ComboBox
    Friend WithEvents lblBrakes As System.Windows.Forms.Label
    Friend WithEvents lblEngine As System.Windows.Forms.Label
    Friend WithEvents lblFuel As System.Windows.Forms.Label
    Friend WithEvents lblLock As System.Windows.Forms.Label
    Friend WithEvents lblSteering As System.Windows.Forms.Label
    Friend WithEvents DataGridView1 As System.Windows.Forms.DataGridView
    Friend WithEvents btnSearch As System.Windows.Forms.Button

End Class

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Manan J
Web Developer
India India
Hey,
I am Manan Jadhav, working on Web Applications and Databases since 3 years. I started off to develop some applications, some basic ones and which then kick-started the freelancing projects from various companies and colleges. I have been always interested in doing things differently and as efficient as possible. My proficiency includes Web Development, Databases and .net.
 
My interests include programming and teaching.
 
I also have some research work going around on Artificial Intelligence and Databases.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.141223.1 | Last Updated 31 Dec 2010
Article Copyright 2010 by Manan J
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid