ASP.NET

private IEnumerable<AutoCompleteData> GetAutoCompleteData(string searchTerm)
{
    using (var context = new AdventureWorksEntities())
    {
        var results = context.Products
            .Include("ProductSubcategory")
            .Where(p => p.Name.Contains(searchTerm)
                        && p.DiscontinuedDate == null)
            .AsEnumerable()
            .Select(p => new AutoCompleteData
                                {
                                    Id = p.ProductID,
                                    Text = BuildAutoCompleteText(p)
                                })
            .ToArray();
        return results;
    }
}

    Private Sub Button1_Click(sender As Object, e As RibbonControlEventArgs) Handles Button1.Click







        Dim myexcel As New Excel.Application
        Dim myworkbook As Excel.Workbook
        Dim foldername As String



        foldername = "C:\SplitFiles\"

        Dim path1 As String

        Dim path2 As String()

        If Directory.Exists(foldername) Then path2 = Directory.GetFiles(foldername)

        For Each path1 In path2

            If File.Exists(path1) Then

                MsgBox(path1)
                myworkbook = myexcel.Workbooks.Open(path1, Format:=6, Delimiter:=",", Editable:=True)
                myworkbook.Activate()
            End If
        Next path1

    End Sub
End Class

Rebuild All: 3 succeeded, 1 failed, 0 skipped

Warning 3   Found conflicts between different versions of the same dependent assembly. In Visual Studio, double-click this warning (or select it and press Enter) to fix the conflicts; otherwise, add the following binding redirects to the "runtime" node in the application configuration file: <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"><dependentAssembly><assemblyIdentity name="log4net" culture="neutral" publicKeyToken="669e0ddf0bb1aa2a" /><bindingRedirect oldVersion="0.0.0.0-2.0.8.0" newVersion="2.0.8.0" /></dependentAssembly></assemblyBinding> XXXXX.SUD.CRS.Services (XXXXX.SUD.CRS.Services\XXXXX.SUD.CRS.Services)

if (!String.IsNullOrEmpty(SearchText))
    {
        customer = customer.Where(s => s.CompanyName.ToUpper().Contains(SearchText.ToUpper())
        || s.ContactName.ToUpper().Contains(SearchText.ToUpper())
        || s.ContactTitle.ToUpper().Contains(SearchText.ToUpper())
        || s.Address.ToUpper().Contains(SearchText.ToUpper()));
    }