Thanks but you still don't get me. I want to create my own search engine and as earlier stated, I have created a fulltext catalog on column "designation" of "Records" table.
Here is the logic I want you to understand:
On my form design, I have a textbox that will receive input from user (for instance- "bull") then pass the value ("bull") to the query which will now execute the query and retrieve all values that contain "bull" in the designation column of records table.
How do I bind the input value to the text box? Here below is the code of the web form I created, please do take a look and make the right corrections for me, this is the last phase of work for me.
Search Page:
<%@ Page Language="VB" MasterPageFile="~/Dicon.master" Title="Untitled Page" %>
<script runat="server">
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
SqlDataSource1.SelectParameters("DESIGNATION").DefaultValue = _
"%" + TextBox1.Text + "%"
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<style type="text/css">
.style4
{
color: #FFFFFF;
font-weight: bold;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table width="900px" align="center">
<tr>
<td>
<span class="style4">Enter Designation :</span>
<asp:TextBox ID="TextBox1" runat="server" Width="200px"></asp:TextBox>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<asp:Button ID="Button1" runat="server" Text="Search" Width="60px" />
</td>
</tr>
<tr>
<td>
[b]
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" Width="900px">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" />
<asp:BoundField DataField="SNUM" HeaderText="S-NUM" SortExpression="SNUM" />
<asp:BoundField DataField="DATE" HeaderText="DATE" SortExpression="DATE" DataFormatString='{0:d}' />
<asp:BoundField DataField="CODE" HeaderText="CODE" SortExpression="CODE" />
<asp:BoundField DataField="DESIGNATION" HeaderText="DESIGNATION"SortExpression="DESIGNATION" />
<asp:BoundField DataField="UNIT" HeaderText="UNIT" SortExpression="UNIT" />
<asp:BoundField DataField="SVC" HeaderText="SVC" SortExpression="SVC" />
<asp:BoundField DataField="UNSVC" HeaderText="UNSVC" SortExpression="UNSVC" />
<asp:BoundField DataField="STOREID" HeaderText="STOREID" SortExpression="STORENAME" />
<asp:BoundField DataField="LOCATION" HeaderText="LOCATION" SortExpression="LOCATION" />
<asp:BoundField DataField="ADMINNAME" HeaderText="ADMIN NAME" SortExpression="ADMINNAME" />
<asp:BoundField DataField="STOREMAN" HeaderText="STOREMAN" SortExpression="STOREMAN" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DiconConnectionString %>" SelectCommand="select id, snum, date, code, designation, unit, svc, unsvc, storeid, location, adminname, storeman
from records
where contains(designation, @designation)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="designation"
PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
[b]
</td>
</tr>
</table>
</asp:Content>
It compiled successfully but would not return any results. I think there is a data binding error in my code, I'm only novice. This page is just for you to understand what logic I am trying to execute, thank you as you always seem to solve my problems.
Thank you.