Skip to content

Instantly share code, notes, and snippets.

@Joruus
Joruus / SqlParameterWith0OK.cs
Created February 20, 2012 15:10
SqlParameter
string sql = "INSERT INTO Incidencias (Estado) VALUES (@Estado)";
SqlParameter paramEstado = new SqlParameter("Estado", Convert.ToInt32(0));
SqlHelper.ExecuteScalar(CommandType.Text, sql, paramEstado);
@Joruus
Joruus / SqlParameterWith0NoOK.cs
Created February 20, 2012 15:10
SqlParameterNoOK
string sql = "INSERT INTO Incidencias (Estado) VALUES (@Estado)";
SqlParameter paramEstado = new SqlParameter("Estado", 0);
SqlHelper.ExecuteScalar(CommandType.Text, sql, paramEstado);
@Joruus
Joruus / datetimeDosDigitosAño.cs
Created January 4, 2012 10:00
Conversión DateTime
DateTime dt;
string datetime = "120101";
DateTime.TryParseExact(datetime,
"yyMMdd",
CultureInfo.InvariantCulture,
DateTimeStyles.None,
out dt);
@Joruus
Joruus / UtilidadesDateTime.cs
Created January 4, 2012 08:41
UtilidadesDateTime TwoDigitYearMax
public static class UtilidadesDateTime
{
public static CultureInfo Cultura { get; private set; }
static UtilidadesDateTime()
{
Cultura = new CultureInfo(CultureInfo.CurrentCulture.LCID);
Cultura.Calendar.TwoDigitYearMax = 2099;
}