Mi Bitácora Personal~

OBTENER VALOR DE LINKBUTTON, DATAGRID

‘Respond to item being clicked
Dim btn As LinkButton = CType(e.CommandSource, LinkButton)

Select Case btn.Text
Case “Details”

….etc…

End Select

UNION CON ORDER BY, SQL

Example #2 - With ORDER BY Clause

The following is a UNION query that uses an ORDER BY clause:

select supplier_id, supplier_name
from suppliers
where supplier_id > 2000
UNION
select company_id, company_name
from companies
where company_id > 1000
ORDER BY 2;

Since the column names are different between the two “select” statements, it is more advantageous to reference the columns in the ORDER BY clause by their position in the result set. In this example, we’ve sorted the results by supplier_name / company_name in ascending order, as denoted by the “ORDER BY 2”.

The supplier_name / company_name fields are in position #2 in the result set.

FORMATOS DE FECHAS SQL

Por defecto lo entrega así:

dd/mm/yyyy hh:mm:ss

En cambio podemos hacer ciertas variaciones:

CONVERT (char(10), Fecha,103) retorna dd/mm/yyyy

CONVERT (char(10), Fecha,102) retorna dd.mm.yyyy

IF NULL ó NOT NULL EN VB.NET

En C# es muy sencillo:

If (someEvent = Null) //Si es nulo

{

//codigo

}

If (someEvent != Null) //Si no es nulo

{

//codigo

}

En VB.NET es de la siguiente forma:

If SomeEvent is Nothing Then //Si es nulo

//codigo

End If

If Not SomeEvent is Nothing Then //Si no es nulo

//codigo

End If

Por bajar además ^^

Por bajar además ^^


Por bajar 14-05-2008

Stone Temple Pilots - Pruno
Bush - Letting the Cables Sleep
Stone Temple Pilots - Revolution (Beatles Cover)
Blink-182 - Feeling This
Puddle of Mudd - Spin You Around
Creed - Signs
Goo Goo Dolls - Another Second
Pearl Jam - Yellow Ledbetter
The Offspring - Americana
Guns N’ Roses - Don’t Cry
Queens of the Stone Age - No One Knows
Bush - Swim
Pearl Jam - Off He Goes
SnappleMan - Dead Batteries
Brink of Time - Neon Bubbles Tube
The Office - Oasis Sounds
Chikusho Sound Team - Castlevania WickedestChild OC Remix
MP - Final Fantasy 6 EngineerCid (factory)

Por bajar 22-04-2008

Live - Sun
Tonic - If You Could Only See
Fuel - Quarter
Collective Soul - Slow
Everlast - Black Jesus
Live - Knives
Silverchair - Suicidal Dream
Collective Soul - Heavy

Por bajar 09-04-2008

Alice in Chains - No Excuses
Jerry Cantrell - Anger Rising
Pearl Jam - Alive
Alice in Chains - Them Bones
Live - Lightning Crashes
Silverchair - Miss you Love
Chevelle - Vitamin R

Por bajar 01-04-2008

Live - Teh Dam at Otter Creek
Foo Fighters - February Stars
Crowded House - She Called Up
Chevelle - The Fad