使用sqlQuery c# ASP进行查询.. NET并在gridview中显示

我看不到gridview中显示的任何数据。看不到任何搜索结果。我试图使用sqlparameter。如您所见，我的sqlQuery非常长。如果我输入"card"，它应该会找到item_description的"大卡片"或"小卡片"值。下面是我的代码:

searchWord = Request.Cookies["Search"].Value;
searchType = Request.Cookies["Display"].Value;
string sqlQuery;
string custSearch = searchWord;
DataTable dt = new DataTable();
SqlConnection sc = new SqlConnection(GetConnectionString());
sqlQuery = "SELECT Player.player_id AS 'ID', Player.fname AS 'First name', "
         +"Player.lname AS 'Last name', Player.sport AS 'Sports',"
         +"Player.position AS 'Position', Player.debut_year AS 'Debut year',"
         +"Player.prof_year AS 'Major year', Player.birth_date AS 'Date of birth'," 
         +"Player.birth_place AS 'Place of birth', Player.team_f AS 'Current team',"
         +"Player.team_s AS 'Past team1', Player.team_t AS 'Past team2',"
         +"Player.living AS 'Death status' " 
         +"FROM Player WHERE (Player.fname LIKE '@SearchPam') "
         +"OR (Player.lname LIKE '@SearchPam') OR (Player.sport LIKE '@SearchPam') "
         +"OR (Player.position LIKE '@SearchPam') OR (Player.team_f LIKE '@SearchPam') "
         +"OR (Player.team_s LIKE '@SearchPam') OR (Player.team_t LIKE '@SearchPam');";
try
{
     sc.Open();
     string result = sqlQuery;
     SqlCommand cmd = new SqlCommand(result, sc);
     cmd.Parameters.AddWithValue("@SearchPam", custSearch);
     SqlDataAdapter adapter = new SqlDataAdapter(cmd);
     DataSet ds = new DataSet();
     adapter.Fill(ds);
     GridView1.DataSource = ds;
     GridView1.DataBind();
}
catch{...}
finally{sc.Close();}
public string GetConnectionString()
{
    return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}

string sql = "SELECT * FROM TableA WHERE Col1 LIKE @SearchPam";
.
.
cmd.Parameters.AddWithValue("@SearchPam", "%" + txtSearch.Text + "%");

string sql = "SELECT * FROM TableA WHERE Col1 LIKE '%' + @SearchPam+ '%'";
.
.
cmd.Parameters.AddWithValue("@SearchPam", txtSearch.Text);