search with keyword

what u want column name ya column data to display

I want design Electronic commercial website that there is many store that put their product on it.

in home page i put search engine that i use some keyword for it

EG:user want bye laptop at first they type LAPTOP on TB and click search button.

on my DB i put KEYWORD =laptop for my COMPUTER  & LAPTOP page 

I want when user search laptop at first show this link  in gridview

laptop

computer

when user click each of them it go to Corresponding page if they click laptop link to laptop.aspx

that was example .

now at first i want know how i  can define 1 keyword for two store that when user type that keyword it show the name of store like above.

I want some thing like this site

http://www.buy.com

in search TB you can search everythig like laptop when you type laptop it shows all laptop product but i want show name that i define for that keyword

CREATE FOLLOWING STORE PROCEDURE AND BIND IT WITH GRID WHEN SEARCH BUTTON IS CLICK

CREATE PROCEDURE [dbo].[Electronic_Search] @Key VARCHAR(50)ASBEGIN
	SET NOCOUNT ON;	declare @Temp table(pagename varchar(50))		INSERT INTO @Temp
	SELECT (CASE WHEN computer =1 THEN 'Computer.aspx' END)  FROM YourTableName WHERE keyword = @Key
	UNION ALL
	SELECT (CASE WHEN laptop =1 THEN 'laptop.aspx' END)  FROM YourTableName WHERE keyword = @Key
	UNION ALL
	SELECT (CASE WHEN library =1 THEN 'library.aspx' END) FROM YourTableName WHERE keyword = @Key
	UNION ALL
	SELECT (CASE WHEN furniture =1 THEN 'furniture.aspx' END)  FROM YourTableName WHERE keyword = @Key
	UNION ALL
	SELECT (CASE WHEN printery =1 THEN 'printery.aspx' END)  FROM YourTableName WHERE keyword = @Key
	SELECT * FROM @Temp WHERE pagename is not nullEND

I create your procedure and this is my search button code

 protected void search_Click(object sender, EventArgs e)
    {





        SqlConnection _cn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["behtopConnectionString"].ConnectionString);

        SqlCommand _cm2 = new SqlCommand("Electronic_Search", _cn);
        _cm2.CommandType = CommandType.StoredProcedure;
        _cm2.Parameters.Add("@Key", txtsearch.Text);

i dont know what should i bind in my gridview i want in my grid view put link that show my columns name that have  value=1 after  that click on link and it go to Corresponding page 

now what should i do?

SP

CREATE PROCEDURE [dbo].[Electronic_Search] @Key VARCHAR(50)AS BEGIN 
    SET NOCOUNT ON; declare @Temp table(pagename varchar(50),pageUrl nvarchar(50))      
	INSERT INTO @Temp
    SELECT (CASE WHEN computer =1 THEN 'Computer' END) as pagename,(CASE WHEN computer =1 THEN '~/Computer.aspx' END) as pageUrl  FROM YourTableName WHERE keyword = @Key
    UNION ALL
    SELECT (CASE WHEN laptop =1 THEN 'laptop' END) as pagename,(CASE WHEN laptop =1 THEN '~/laptop.aspx' END) as pageUrl  FROM YourTableName WHERE keyword = @Key
    UNION ALL
    SELECT (CASE WHEN library =1 THEN 'library' END) as pagename,(CASE WHEN library =1 THEN '~/library.aspx' END) as pageUrl FROM YourTableName WHERE keyword = @Key
    UNION ALL
    SELECT (CASE WHEN furniture =1 THEN 'furniture' END) as pagename,(CASE WHEN furniture =1 THEN '~/furniture.aspx' END) as pageUrl  FROM YourTableName WHERE keyword = @Key
    UNION ALL
    SELECT (CASE WHEN printery =1 THEN 'printery' END) as pagename,(CASE WHEN printery =1 THEN '~/printery.aspx' END) as pageUrl  FROM YourTableName WHERE keyword = @Key
    SELECT * FROM @Temp WHERE pagename is not nullEND

DESIGN

 <asp:TextBox id="txtSearch" runat="server" />
       <asp:Button id="Button1" runat="server" Text="Search" OnClick="BtnSearch_Click" />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns ="false">
        <Columns>        <asp:TemplateField>
       <ItemTemplate>
           <asp:LinkButton ID="LinkButton1" PostBackUrl ='<%#Eval("pageUrl") %>'  runat="server"><%#Eval("pagename") %></asp:LinkButton>
       </ItemTemplate>
        </asp:TemplateField>                                  
        </Columns>        </asp:GridView>

CODE

protected void BtnSearch_Click(object sender, EventArgs e)    {
        SqlConnection con = new SqlConnection("Data Source=SERVERNAME;Initial Catalog=DATABASENAME;User ID=sa;Password=123");
        SqlCommand cmd = new SqlCommand("Exec Electronic_Search @Key", con);
        cmd.Parameters.AddWithValue("@Key", txtSearch.Text);        con.Open();
        SqlDataReader rd = cmd.ExecuteReader();               if (rd.HasRows)
        {            GridView1.DataSource = rd;            GridView1.DataBind();
        }        con.Close();     }