Using Multiple Keywords To Search The Data

I using multiple keywords to search and filter my data by using Stored Proc and retrieve the results in GridViewStored Proc
========ALTER PROCEDURE dbo.search

(

@eName nvarchar(30), @ID nvarchar(7), @cID nvarchar(10), @eCC nvarchar(3)

)

AS

SELECT eName, ID, cID, eCC

FROM iTrns

WHERE (ID LIKE '%' + @ID + '%') and

(eName LIKE '%' + @eName + '%') and

(cID LIKE '%' + @cID + '%') and

(eCC = @eCC)

========

My code behind
========protected void Button1_Click(object sender, EventArgs e)

{

GridView1.DataSource = GetTable();

GridView1.DataBind();

}public DataSet GetTable()

{SqlConnection SqlCon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["***"].ConnectionString);

SqlDataAdapter Adptr = new SqlDataAdapter();SqlCommand cmd = new SqlCommand("search", SqlCon);

cmd.CommandType = CommandType.StoredProcedure;cmd.Parameters.AddWithValue("@ID", TextBox2.Text);

cmd.Parameters.AddWithValue("@eName", TextBox1.Text);cmd.Parameters.AddWithValue("@cID", TextBox3.Text);

cmd.Parameters.AddWithValue("@eCC", TextBox4.Text);

Adptr.SelectCommand = cmd;

DataSet ds = new DataSet();return ds;

SqlCon.Close();

}

========

Sometimes it retrieves the whole data !! and sometimes retrieve nothing !!

Any hint ??

Thank you