Tuesday, March 24, 2009
Better html anchor, a jquery script to slide the scrollbar
Found a new feature for better html anchor link. Looks great!! Will try to try it out and apply in website in future...
Wednesday, March 18, 2009
Escape From <asp:image> Default CSS
How to get rid of ASP.NET default styling for asp:image??? Ppl says it is a [bug]... donno...
BTW, here is the workaround:
1. Create 2 classes
Public Class BorderlessImage
Inherits System.Web.UI.WebControls.Image
Public Overrides Property BorderWidth() As System.Web.UI.WebControls.Unit
Get
If MyBase.BorderWidth.IsEmpty Then
Return Unit.Pixel(0)
Else
Return MyBase.BorderWidth
End If
End Get
Set(ByVal value As System.Web.UI.WebControls.Unit)
MyBase.BorderWidth = value
End Set
End Property
End Class
Public Class BorderlessImageButton
Inherits System.Web.UI.WebControls.ImageButton
Public Overrides Property BorderWidth() As System.Web.UI.WebControls.Unit
Get
If MyBase.BorderWidth.IsEmpty Then
Return Unit.Pixel(0)
Else
Return MyBase.BorderWidth
End If
End Get
Set(ByVal value As System.Web.UI.WebControls.Unit)
MyBase.BorderWidth = value
End Set
End Property
2. Addinto web.config
<system.web>
<pages>
<tagmapping>
<add mappedtagtype="BorderlessImage" tagtype="System.Web.UI.WebControls.Image">
<add mappedtagtype="BorderlessImageButton" tagtype="System.Web.UI.WebControls.ImageButton">
</pages>
</SYSTEM.WEB>
That's it. Done! Enjoy...
BTW, here is the workaround:
1. Create 2 classes
Public Class BorderlessImage
Inherits System.Web.UI.WebControls.Image
Public Overrides Property BorderWidth() As System.Web.UI.WebControls.Unit
Get
If MyBase.BorderWidth.IsEmpty Then
Return Unit.Pixel(0)
Else
Return MyBase.BorderWidth
End If
End Get
Set(ByVal value As System.Web.UI.WebControls.Unit)
MyBase.BorderWidth = value
End Set
End Property
End Class
Public Class BorderlessImageButton
Inherits System.Web.UI.WebControls.ImageButton
Public Overrides Property BorderWidth() As System.Web.UI.WebControls.Unit
Get
If MyBase.BorderWidth.IsEmpty Then
Return Unit.Pixel(0)
Else
Return MyBase.BorderWidth
End If
End Get
Set(ByVal value As System.Web.UI.WebControls.Unit)
MyBase.BorderWidth = value
End Set
End Property
2. Add
<system.web>
<pages>
<tagmapping>
<add mappedtagtype="BorderlessImage" tagtype="System.Web.UI.WebControls.Image">
<add mappedtagtype="BorderlessImageButton" tagtype="System.Web.UI.WebControls.ImageButton">
</pages>
</SYSTEM.WEB>
That's it. Done! Enjoy...
Wednesday, March 11, 2009
Oracle NVL Function
NVL function substitutes a value when a null value is encoutered.
Applies to: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
Example #1:
select NVL(supplier_city, 'n/a')
from suppliers;
The SQL statement above would return 'n/a' if the supplier_city field contained a null value. Otherwise, it would return the supplier_city value.
Example #2:
select supplier_id,
NVL(supplier_desc, supplier_name)
from suppliers;
This SQL statement would return the supplier_name field if the supplier_desc contained a null value. Otherwise, it would return the supplier_desc.
Syntax | NVL( string1, replace_with ) |
string1 | the string to test for a null value |
replace_with | the value returned if string1 is null |
Applies to: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
Example #1:
select NVL(supplier_city, 'n/a')
from suppliers;
The SQL statement above would return 'n/a' if the supplier_city field contained a null value. Otherwise, it would return the supplier_city value.
Example #2:
select supplier_id,
NVL(supplier_desc, supplier_name)
from suppliers;
This SQL statement would return the supplier_name field if the supplier_desc contained a null value. Otherwise, it would return the supplier_desc.
Friday, March 6, 2009
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats
just try to find a place to collect those downloads or tools that i found online... this is the first.
Subscribe to:
Posts (Atom)