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

Cassie Mod · Answer

Why you want to do a LIKE? You can just say: response = dr([columnitem]).ToString(); otherwise you need to create a new query to get only the responces you want.

Mithun Pattankar · Answer

Can you just rephrase your question? I don't understand why you need %Like%. I guess dr is datarow of datatable