C#

Bitmap myBitmap = new Bitmap(@"c:\Picture1.bmp");<br />
OleDbConnection conn = new OleDbConnection("<<My Connection String>>");<br />
conn.Open();<br />
string sql = "UPDATE Table1 SET fldOLE = @fldOLE WHERE fldID = 5";<br />
OleDbCommand command = new OleDbCommand(sql, conn);<br />
command.Parameters.Add(new OleDbParameter("@fldOLE", myBitmap));<br />
int rowsAffected = command.ExecuteNonQuery();

 // Delegate declaration<br />
      public delegate void SubmitClickedHandler(string strValue);<br />
<br />
      // Event declaration<br />
      public event SelectBuilding.SubmitClickedHandler SubmitClicked;

Else<br />
{ SelectBuilding.SubmitClicked += new SelectBuilding.SubmitClickedHandler(SubmitClickedHandler_Submit);<br />
} 

<br />
<tr><br />
    <td align=right><br />
        <asp:Label id="cap" runat="server"/> :<br />
    </td><br />
    <td align="left" style="width:99%"><br />
        <asp:PlaceHolder id="con" runat="server"/><br />
    </td><br />
</tr><br />

<br />
public partial class MergedControl : System.Web.UI.UserControl<br />
{<br />
    public string Caption<br />
    {<br />
        get { return (cap.Text); }<br />
        set { cap.Text = value; }<br />
    }<br />
<br />
    public Control Cont<br />
    {<br />
        get { return con.Controls[0]; }<br />
        set { con.Controls.AddAt(0,value); }<br />
    }<br />
}<br />

            if (Velocity.Y > 0)<br />
            {<br />
                for (int n = 0; n < 25; ++n)<br />
                {<br />
                    if (Position.Y + Sprite.Height > grassTopBlock[n].Position.Y<br />
                        && Position.Y < grassTopBlock[n].Position.Y + grassTopBlock[n].Sprite.Height)<br />
                    {<br />
                        if (Position.X + Sprite.Width > grassTopBlock[n].Position.X<br />
                            && Position.X < grassTopBlock[n].Position.X + grassTopBlock[n].Sprite.Width)<br />
                        {<br />
                            Position.Y = grassTopBlock[n].Position.Y - Sprite.Height;<br />
                        }<br />
                    }<br />
                }<br />
            }<br />
<br />
            ///  FIX ME!  ( i wrote his for myself before I got off last night)<br />
<br />
            if (Velocity.X < 0)<br />
            {<br />
                for (int n = 0; n < 25; ++n)<br />
                {<br />
                    if (Position.Y + Sprite.Height > grassTopBlock[n].Position.Y<br />
                        && Position.Y < grassTopBlock[n].Position.Y + grassTopBlock[n].Sprite.Height)<br />
                        {<br />
                            if (Position.X < grassTopBlock[n].Position.X + grassTopBlock[n].Sprite.Width<br />
                                && Position.X + Sprite.Width > grassTopBlock[n].Position.X + grassTopBlock[n].Sprite.Width)<br />
                            {<br />
                                Position.X = grassTopBlock[n].Position.X + grassTopBlock[n].Sprite.Width;<br />
                            }<br />
                        }<br />
                }<br />
            }

public class Hands<br />
{<br />
    public int[,] PlayerHands = new int[4, 13];<br />
   public Hands()<br />
    {<br />
    }<br />
}

  public partial class Form1 : Form<br />
  {<br />
    private Deck TheDeck;<br />
    private Hands TheHands;<br />
public Form1()<br />
    {<br />
      TheDeck = new Deck();    //created only once<br />
      TheHands = new Hands();  //created only once<br />
     }<br />
private void buttonPlay_Click(object sender, EventArgs e)<br />
    {<br />
      TheDeck.Shuffle();<br />
      TheDeck.DealHands(TheHands);<br />
      // buttonPlay.Visible = false;<br />
      //gamestarted = true;<br />
      // some other code will be here<br />
      Invalidate();<br />
    }<br />
}<br />
<br />
//////////<br />
<br />
public class Deck<br />
  {<br />
    private int[] CardArray = new int[52];<br />
   // public int[,] PlayerHands = new int[4, 13]; is not needed<br />
    public Deck()<br />
    {<br />
      for( int i = 0; i &lt; 52; i++ )<br />
      {<br />
        CardArray[i] = i;<br />
      }<br />
    }<br />
<br />
    /// &lt;summary&gt;<br />
    /// Deal hands - Fill PlayerHands []<br />
    /// &lt;/summary&gt;<br />
      public void  DealHands(Hands passedHands)<br />
      {<br />
          for (int j = 0; j &lt; 13; j++)<br />
          {<br />
              for (int i = 0; i &lt; 4; i++)<br />
              {<br />
                  passedHands.PlayerHands [i,j]=CardArray[4 * j + i];<br />
              }<br />
          }<br />
          //passedHands.PlayerHands[2, 9] = 666; //for testing<br />
// there is no return statement<br />
      }<br />
   }<br />
}

 public partial class Form1 : Form<br />
  {<br />
    private Deck TheDeck;<br />
    private Hands TheHands;<br />
public Form1()<br />
    {<br />
      TheDeck = new Deck();    //created only once<br />
      TheHands = new Hands();  //created only once<br />
     }<br />
private void buttonPlay_Click(object sender, EventArgs e)<br />
    {<br />
      TheDeck.Shuffle();<br />
      TheHands.PlayerHands = TheDeck.DealHands();<br />
      // buttonPlay.Visible = false;<br />
      //gamestarted = true;<br />
      // some other code will be here<br />
      Invalidate();<br />
    }<br />
}<br />
<br />
//////////<br />
<br />
public class Deck<br />
  {<br />
    private int[] CardArray = new int[52];<br />
    public int[,] PlayerHands = new int[4, 13]; <br />
    public Deck()<br />
    {<br />
      for( int i = 0; i &amp;lt; 52; i++ )<br />
      {<br />
        CardArray[i] = i;<br />
      }<br />
    }<br />
<br />
    /// &amp;lt;summary&amp;gt;<br />
    /// Deal hands - Fill PlayerHands []<br />
    /// &amp;lt;/summary&amp;gt;<br />
      public int [,] DealHands()<br />
      {<br />
          for (int j = 0; j &amp;lt; 13; j++)<br />
          {<br />
              for (int i = 0; i &amp;lt; 4; i++)<br />
              {<br />
                  PlayerHands [i,j]=CardArray[4 * j + i];<br />
              }<br />
          }<br />
          //passedHands.PlayerHands[2, 9] = 666; //for testing<br />
return PlayerHands;<br />
      }<br />
   }<br />
}