[SQL][C#]¹¹¿··Ï¥¹¥È¥¢¥É¥×¥í¥·¡¼¥¸¥ã¤Î¼Â¹Ô

private System.Data.SqlClient.SqlConnection DatabaseConnection;
¡¦¡¦¡¦
// DB¥³¥Í¥¯¥·¥ç¥ó¥ª¡¼¥×¥ó
if (DatabaseConnection.State == System.Data.ConnectionState.Closed)
DatabaseConnection.Open();
// SQL¥³¥Þ¥ó¥ÉÀ¸À®
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "sp_calc_hoge";
cmd.Connection = this.DatabaseConnection;
cmd.CommandTimeout = 300;	// 5ʬ
// ¥Ñ¥é¥á¡¼¥¿ÀßÄê
cmd.Parameters.Add("@foo", SqlDbType.Float,8,"foo");
cmd.Parameters["@foo"].Value = fFoo;
// ¼Â¹Ô
nStatus = cmd.ExecuteNonQuery();