C# Filter Example | Filter | Source Code

C# Filter Example | Filter | Source Code

Purpose: – Illustrates the for .




Step 1: Click on C# to Cut-n-paste code into clsFilter.cs

using System;
public class clsFilter
{
 
    public void Main()
    {
 
 
        //****************************************************************************************
        // Purpose: Returns a zero-based array containing a subset of a String array based on
        // specified filter criteria.
        //
        // Syntax: 	Filter (Source As String(), Match As String, Include As Boolean, _
        // Compare As CompareMethod) As String()
        //
        // Source - Required - one-dimensional string array to be searched
        // Match - required - string to search for
        // Include - optional - Boolean value indicating whether to return substrings that 
        // include or exclude Match.
        // Compare - optional - numeric value indicating compare method - CompareMethod.Binary
        // or CompareMethod.Text
        //****************************************************************************************
 
        Console.WriteLine("Example #1: 	Filter(Source, Match, Include,Compare) As String");
        string[] myStrings = new string[4];
        myStrings[0] = "This";
        myStrings[1] = "is";
        myStrings[2] = "my";
        myStrings[3] = "string";
 
        string[] FilteredStrings = null;
        FilteredStrings = Microsoft.VisualBasic.Strings.Filter(myStrings, "is", true, Microsoft.VisualBasic.CompareMethod.Text);
 
        foreach (string myItem in FilteredStrings)
        {
            Console.WriteLine(myItem); // Returns ["This", "Is"].
        }
 
 
 
        //write blank line to make output easier to read
        Console.WriteLine();
 
 
 
        //Prevent console from closing before you press enter
        Console.ReadLine();
 
    }
 
 
}

Step 2: Click on C# to Cut-n-paste code into Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
 
namespace CSharp_Syntax
{
    class Program
    {
        static void Main(string[] args)
        {
 
 
            clsFilter myFilter = new clsFilter();
            myFilter.Main();
 
        }
    }
}

Prerequistes:

  1. Install C# (Express or Standard Edition)
  2. Install SQL Server Express
  3. Download Northwind and pubs Database
  4. Attach Northwind Database to Databases in Sql Express
  5. Attach pubs Database to Databases in Sql Express

Notes:

  • Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
  • You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Program.cs

Instructions:

  1. Use C# 2010 Express or Standard Edition
  2. Create new project;
    • Click File/New Project
    • Select Console Application Template
    • Select C# for Language
    • name of project could be CSharp_Syntax.
  3. CS Syntax File Directory Binary File Read Sequential

  4. Add New folder named “StringManipulation”
    • Right-click project name in solution explorer;
    • add new folder;
    • name of folder could be: StringManipulation
  5. Add Class Named clsFilter to StringManipulation folder
    • Right-click StringManipulation folder;
    • add new item;
    • Select class
    • Class name could be clsFilter
  6. Click on C# in code in step 1 at top of page to copy code into clsFilter.cs
  7. Click on C# in step 2 at top of page to copy code into Program.cs
  8. Click green arrow or press F5 to run program