Skip to content

Instantly share code, notes, and snippets.

View crowcoder's full-sized avatar

Bob crowcoder

17 followers · 3 following
View GitHub Profile
@crowcoder
crowcoder / Phaser Background
Last active April 30, 2016 22:38
//in the game's preload function you load the image like any other
game.load.image('bkgrnd', 'sprites/background.png');
/*Then you add the tileSprite in create(). This constructor's parameters are, in order:
0 - position of the image on the X coordinate of the game
0 - position of the image on the Y coordinate of the game
640 - Width of the tile
480 - Height of the tile
bkgrnd - key you gave to the image when you loaded it in preload()
see: http://phaser.io/docs/2.4.4/Phaser.TileSprite.html */
@crowcoder
crowcoder / BasicGameIntegration
Last active January 26, 2019 15:56
BasicGameIntegration
<!doctype html>
<html>
<head>
<!-- stuff... -->
</head>
<body>
<div id="gameDiv"></div>
<script src="https://newupwaititsfun.z13.web.core.windows.net/frog/game.js" integrity="sha384-qoRzVFhcu3MPqU4+hUIAG45mJWAXYwf1QDlkHQY2519KjBjFyETk7mTDV/wY9AD1"
crossorigin="anonymous"></script>
</body>
@crowcoder
crowcoder / ParentFooHiding
Created August 22, 2016 23:14
SO Question http://stackoverflow.com/questions/39089582/accessing-the-correct-function-in-an-arraylist-of-different-child-classes/39089681#39089684
using System;
using System.Collections;
using System.Collections.Generic;
namespace ConsoleApplication4
{
class Program
{
static void Main(string[] args)
{
@crowcoder
crowcoder / ParamBehavior
Last active October 15, 2016 14:26
static void Main(string[] args)
{
SqlConnectionStringBuilder bldr = new SqlConnectionStringBuilder();
bldr.DataSource = "(localdb)\\DEV";
bldr.InitialCatalog = "DbParams";
bldr.ApplicationName = "ParameterBehavior";
bldr.IntegratedSecurity = true;
using (SqlConnection con = new SqlConnection(bldr.ConnectionString))
using (SqlCommand cmd = con.CreateCommand())
@crowcoder
crowcoder / InputWithNoDefault
Created October 15, 2016 14:29
private static void InputWithNoDefault(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Input_No_Default";
SqlParameter par = new SqlParameter("@param1", SqlDbType.VarChar);
par.Direction = ParameterDirection.Input;
par.Value = "Foo";
cmd.Parameters.Add(par);
}
@crowcoder
crowcoder / usp_Input_No_Default
Created October 15, 2016 14:31
CREATE PROCEDURE [dbo].[usp_Input_No_Default]
@param1 varchar(50)
AS
SELECT @param1;
RETURN 0;
@crowcoder
crowcoder / InputWithNoDefault_NullValue
Created October 15, 2016 14:47
private static void InputWithNoDefault_NullValue(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Input_No_Default";
SqlParameter par = new SqlParameter("@param1", SqlDbType.VarChar);
par.Direction = ParameterDirection.Input;
par.Value = null;
cmd.Parameters.Add(par);
}
@crowcoder
crowcoder / InputWithNoDefault_DBNullValue
Created October 15, 2016 14:56
private static void InputWithNoDefault_DBNullValue(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Input_No_Default";
SqlParameter par = new SqlParameter("@param1", SqlDbType.VarChar);
par.Direction = ParameterDirection.Input;
par.Value = DBNull.Value;
cmd.Parameters.Add(par);
}
@crowcoder
crowcoder / usp_Input_Has_Default
Created October 15, 2016 15:09
CREATE PROCEDURE [dbo].[usp_Input_Has_Default]
@param1 varchar(50) = 'I''m a default value'
AS
SELECT @param1;
RETURN 0;
@crowcoder
crowcoder / InputNullWithDefault
Created October 15, 2016 15:25
private static void InputNullWithDefault(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Input_Has_Default";
SqlParameter par = new SqlParameter("@param1", SqlDbType.VarChar);
par.Direction = ParameterDirection.Input;
par.Value = null;
cmd.Parameters.Add(par);
}