Using Comand (%LIKE%) to check data in the column

Question

Hello C# Corner,

 

I want to check out  data using Command (%LIKE%) before/after the Name of the Table Column to check out the so it give out the display after checking

 

this is my Code:

response = dr[(I want to use %Like% command at this table column)"Subscription_Type"].ToString();

if (response == Subscription_Standard)

{
label2.Text = "SE";

}
else if (response == Subscription_Professional)
{
label2.Text = "PE";
}

 

 

Possible someone to help me with code or explanation

Thanks

beavon