C#

<br />
SqlConnection cn = new SqlConnection("some_valid_connectionstring_here");<br />
SqlCommand cmd = new SqlCommand("sp_procedure_params_rowset 'your_stored_procedure_name_here'", cn);<br />
SqlDataAdapter da = new SqlDataAdapter(cmd);<br />
DataTable table = new DataTable();<br />
da.Fill(table);<br />
<br />
foreach(DataRow row in table.Rows)<br />
{<br />
   Console.WriteLine("{0}", row[3]);<br />
}<br />

protected  override void Paint(Graphics g, Rectangle bounds, CurrencyManager source, int rowNum, Brush backBrush, Brush foreBrush, bool alignToRight)
{
	Decimal val = (Decimal) GetColumnValueAtRow(source, rowNum);
	if(val>0)
		foreBrush = Brushes.Green;
	else
		foreBrush = Brushes.Red;
	base.Paint (g, bounds, source, rowNum, backBrush, foreBrush, alignToRight);
}

public sealed class A
{
  private A()
  {
    // construct
  }
 
  private static object lockObject = new object();
  private static A instance;
 
  public A Instance
  {
    get 
    {
      if( instance == null )
      {
        lock( lockObject )
        {
          if( instance == null )
          {
            instance = new A();
          }
        }
      }
 
      return instance;
    }
  }
}

get
{   
   if( instance == null)
   {        lock( lockObject) 
               {          
                   if( instance == null )  
                   {       
                       instance = new A();          
                   }         
               }      
   }
}