Click here to Skip to main content
15,881,172 members
Articles / Database Development

How to Create a Relevance Based Search Query for SQL

Rate me:
Please Sign up or sign in to vote.
4.75/5 (4 votes)
31 Dec 2010CPOL3 min read 37.3K   342   19  
Arrange Results to get the most relevant result first...
<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)


Written By
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.

Comments and Discussions