Code
public static DataTable Get_like(int index, int page,string when ,string then)
        {
            int _count = Get_count();
            using (SqlConnection _conn = new SqlConnection(_Strconn))
            {
                _conn.Open();

                DataTable dt = new DataTable("Emp1");
                SqlDataAdapter da = new SqlDataAdapter(string.Format("select top {0} * from (select top {1} * from employees order by employeeid desc ) b where b.'{2}' like '%+'{3}'+%' order by b.employeeid", index, _count - (page - 1) * index,when,then), _conn);
                da.Fill(dt);
                return dt;

            }
        }