search with keyword

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();     }