Simpelt, men dynamisk sql

Search.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Seach : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void ButtonSearch_Click(object sender, EventArgs e)
    {
        string sql = "select * from stol inner join type on stol.fk_type = type.Id";

        string searchStr = TextBoxSearch.Text;
        string[] words = searchStr.Split(' ');
        string sqlFilters = "";

        foreach (string word in words)
        {
            if(sqlFilters.Length > 0)
            {
                sqlFilters += " OR";
            }
            sqlFilters += " stol.titel LIKE '%" + word + "%'";
            sqlFilters += " OR stol.designer LIKE '%" + word + "%'";
        }
        if(sqlFilters.Length > 0)
        {
            sql += " WHERE " + sqlFilters;
        }

        SqlDataSource1.SelectCommand = sql;
        GridView1.DataBind();
    }
}

search2.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class search2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void ButtonSearch_Click(object sender, EventArgs e)
    {
        string sql = "Select * from stol inner join type on stol.fk_type = type.Id";
        sql += " WHERE stol.titel LIKE '%" + TextBoxSearch.Text + "%'";

        SqlDataSource1.SelectCommand = sql;
        GridView1.DataBind();
    }
}