C#

<br />
    ArrayList admins = new ArrayList();<br />
    ArrayList available = new ArrayList();<br />
<br />
//This gets the AVAILABLE system administrators listed in the table.<br />
        SqlDataSource sa = new SqlDataSource(ConfigurationManager.ConnectionStrings["HelpDeskConnectionString"].ConnectionString, "SELECT [Admins] FROM [Admin_Table] WHERE ([Area] = 'System Administrator') AND ([Available] = 'True')");<br />
<br />
//This pulls all the tickets from the Tickets table that users have submitted and looks for the <br />
//Assigned field where it equals System Administrator<br />
        SqlDataSource count = new SqlDataSource(ConfigurationManager.ConnectionStrings["HelpDeskConnectionString"].ConnectionString, "SELECT [Assigned] FROM [User_Submit] WHERE ([Type] = 'System Administrator')");<br />
<br />
// Great Gridviews and bind them to the SqlDAtaSource<br />
        GridView gvAvail = new GridView();<br />
        gvAvail.DataSource = sa;<br />
        gvAvail.Visible = false;<br />
        gvAvail.DataBind();<br />
        this.Controls.Add(gvAvail);<br />
<br />
        GridView gvCount = new GridView();<br />
        gvCount.DataSource = count;<br />
        gvCount.Visible = false;<br />
        gvCount.DataBind();<br />
        this.Controls.Add(gvCount);<br />
<br />
// This reads the GridView that contains everyone that is available.<br />
        foreach (GridViewRow row in gvAvail.Rows)<br />
        {<br />
            available.Add(row.Cells[0].Text);<br />
        }<br />
// Now this reads the other GridView and adds the System Administrators name to an ArrayList if<br />
// They are listed as available which is all the names in the first ArrayList (available).<br />
        for (int i = 0; i < gvCount.Rows.Count; i++)<br />
        {<br />
            if (available.Contains(gvCount.Rows[i].Cells[0].Text))<br />
            {<br />
                admins.Add(gvCount.Rows[i].Cells[0].Text);<br />
            }<br />
        }<br />
<br />