It works for me:
string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("VideoMaster");
using (SqlConnection con = new SqlConnection(strConnect))
{
try
{
con.Open();
using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM TVShows WHERE Title LIKE '%' + @SEARCH +'%'", con))
{
da.SelectCommand.Parameters.AddWithValue("@SEARCH", "Expanse");
using (DataTable dt = new DataTable())
{
da.Fill(dt);
DataView dv = new DataView(dt);
myDataGridView.DataSource = dv;
dv.RowFilter = "Title <> 'The Expanse S04E01 New Terra'";
}
}
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
}
}