check this, modify the table name and column name
string text = "Plastic Hole";
string[] keys = text.Trim().Split(' ');
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=karthik_test;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string query = "", likePattern = "";
for (int i = 0; i < keys.Length; i++)
likePattern += string.Format("%{0}", keys[i]);
likePattern = likePattern.Trim() + "%";
query = likePattern.Length > 0 ? "select * from TableKeywordSearch where keywordcolumn like @keyword " : "select * from TableKeywordSearch";
cmd.CommandText = query;
cmd.Parameters.Add("@keyword", likePattern);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtResults = new DataTable ();
try
{
da.Fill(dtResults);
}
catch (Exception)
{
throw;
}