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
10 months agoMi Bitácora Personal~
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.
10 months agoFORMATOS 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
10 months agoIF 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
10 months ago
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
