C#

string sql = "SELECT ... WHERE DateField < @Date";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add("@Date", mydate);
SqlDataReader rdr = cmd.ExectueReader()
while(rdr.Read())
{
    // This cycle will repeat for every row returned. If you get two
    // rows, process one row here, get to the end of the while loop, and
    // when rdr.Read() is called again, you'll get the second record.
}

this.inLabelEdit = false;
NativeMethods.NMLVDISPINFO nmlvdispinfo1 = (NativeMethods.NMLVDISPINFO) m.GetLParam(typeof(NativeMethods.NMLVDISPINFO));
LabelEditEventArgs args2 = new LabelEditEventArgs(nmlvdispinfo1.item.iItem, nmlvdispinfo1.item.pszText);
this.OnAfterLabelEdit(args2);
m.Result = args2.CancelEdit ? IntPtr.Zero : ((IntPtr) 1);
if (!args2.CancelEdit && (nmlvdispinfo1.item.pszText != null))
{
      this.Items[nmlvdispinfo1.item.iItem].Text = nmlvdispinfo1.item.pszText;
}
return;

<br />
private void KillProcess(string processName)<br />
{<br />
    // get all instances of the requested process<br />
    Process[] processes = Process.GetProcessesByName(processName);<br />
<br />
    // kill all instances of the requested process<br />
    foreach (Process p in processes)<br />
    {<br />
        // kill the current instance of the process<br />
        p.kill()<br />
    }<br />
}<br />