private void button7_Click(object sender, EventArgs e)
                    {
                        List<string> valcontains = new List<string>() { "MAP" };
                        List<string> Empcontains = new List<string>() { "M1" };
                        int EmpTagNo = 0;
            
                        DataTable tblData = new DataTable();
                        tblData.Columns.Add("EMPNO", typeof(string));
                        tblData.Columns.Add("EMPTAG", typeof(int));
                        tblData.Columns.Add("EMPDEP", typeof(string));
                        tblData.Rows.Add("KL+M1+XZ+X1+HM", "15", "CIV");
                        tblData.Rows.Add("KL+M1+M3+X1+HM", "20", "MEC");
                        tblData.Rows.Add("KL+M1+M5+X1+HM+M7", "40", "IT");
                        tblData.Rows.Add("KL+M1+M5+X1+HM+M7", "40", "IT");
                        tblData.Rows.Add("KL+M1+M5+X1+HM+M7", "40", "IT");
                        tblData.Rows.Add("KL+M1+M5+X1+HM+M7", "40", "IT");
                        tblData.Rows.Add("(MAP) KL+M1+M5+X1+HM+M7", "40", "CIV");
            
                        var Qry = (from r in tblData.AsEnumerable()
                                   where
                                   ContainsStringExtensions.ContainsAny(r.Field<string>("EMPNO"), valcontains) &&
                                   ContainsStringExtensions.ContainsAny(r.Field<string>("EMPNO"), Empcontains)
                                   select new
                                   {
            
                                   }).Count();
                        if (Qry > 0)
                        {
                            var Qry1 = (from r in tblData.AsEnumerable()
                                        where
                                        ContainsStringExtensions.ContainsAny(r.Field<string>("EMPNO"), valcontains) &&
                                        ContainsStringExtensions.ContainsAny(r.Field<string>("EMPNO"), Empcontains)
                                        select new
                                        {
                                            EMPTAG = r.Field<int>("EMPTAG"),
                                        }).Distinct();
            
                            foreach (var n in Qry1)
                            {
                                EmpTagNo = n.EMPTAG;
                            }
            
                        }
                    }
             public static class ContainsStringExtensions
                {
                    public static bool ContainsAny(this string haystack, IEnumerable<string> filterList)
                    {
                        //return filterList.Any(haystack.Contains);
                        return haystack != null && filterList.Any(haystack.Contains);
                    }
                }