C#

ALTER       PROCEDURE create_journal_entry
@eom_date DATETIME --End of month date
AS

DECLARE

@next_jrnl_num VARCHAR(20)

private void createJEs()
{
	DateTime cutOffDate;
	cutOffDate=this.dtpCutOffDate.Value;

	SqlConnection conn =new SqlConnection(DBConnection.connectionString());
	conn.Open();
	SqlCommand comm=new SqlCommand("create_journal_entry",conn);
        comm.Parameters.Add("@eom_date",SqlDbtype.DateTime);
        comm.parameters["@eom_date"].value=this.dtpCutOffDate.Value;
	
        try
	{
		comm.ExecuteNonQuery();	
		moveFiles();
                MessageBox.Show("Data has been successfully sent to the   
                GL.", "Success",MessageBoxButtons.YesNo,MessageBoxIcon.Information);
	}
	catch(SqlException ex)
	{
            MessageBox.Show("Error "+ex.Number + " "+ ex.Message,"SqlServer 
            error",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
	}
	catch(Exception ex)
	{
            MessageBox.Show(ex.Message,"System Error",  
            MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
	}
	finally
	{
		if (conn!=null)
		{
			conn.Close();
		}
	}
}

device.Clear(ClearFlags.Target, Color.Black, 1.0f, 0);<br />
            device.BeginScene();<br />
            device.VertexFormat = CustomVertex.PositionTextured.Format;<br />
<br />
            //SET TEXTURE AND DRAW FLOOR<br />
            LoadTexturesAndMaterials("TexFloor.png");<br />
            device.SetTexture(0, texture);<br />
            device.DrawUserPrimitives(PrimitiveType.TriangleList, 8, Floor);<br />
<br />
            //DRAW A PILLAR<br />
            LoadTexturesAndMaterials("TexPillar.png");<br />
            device.SetTexture(0, texture);<br />
            device.DrawUserPrimitives(PrimitiveType.TriangleList, 16, MakePillar(new Vector3(fb, 0, 0), 4, 0.2f));<br />
            device.DrawUserPrimitives(PrimitiveType.TriangleList, 16, MakePillar(new Vector3(-fb, 0, 0), 4, 0.2f));<br />
            device.DrawUserPrimitives(PrimitiveType.TriangleList, 16, MakePillar(new Vector3(0, 0, -fb), 4, 0.2f));<br />
            <br />
            //DRAW CRYSTAL<br />
            LoadTexturesAndMaterials("TexCrystal.png");<br />
            device.SetTexture(0, texture);<br />
            device.DrawUserPrimitives(PrimitiveType.TriangleList, 32, Crystal);<br />
<br />
            device.EndScene();<br />
            device.Present();<br />
            Graphics g = this.CreateGraphics();<br />
            g.DrawString("HUD Test", this.Font, Brushes.Red, new PointF(20, 20));<br />
            this.Invalidate();<br />