C#

// Search for the Attendance List form among the open child
// forms, and if found, activate it, restoring it if necessary
foreach(Form form in MdiChildren)
{
    if(form is AttendanceForm)
    {
        if(form.WindowState == FormWindowState.Minimized)
            form.WindowState = FormWindowState.Normal;
        form.Activate();
        return;
    }
}

// Form not open, create a new one
AttendanceForm af = new AttendanceForm();
af.MdiParent = this;
af.Visible = true;

My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

odbCommand.CommandType = CommandType.StoredProcedure ;
odbCommand.CommandText = "exec procs_BestMark ?, ?";

My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

foreach(object itemChecked in checkedListBox1.CheckedItems)

((CheckedListBox)itemChecked ).ValueMember 

SqlParameter param=new SqlParameter("@foo", myFooValue);

cmd.Parameters.Add(param);