Technologies matter

Wednesday, March 5, 2014

To replace htmltable with div using CSS

Issue:

How to get tabular like layout using div.

Solution:

There is an in-built display property support for this with CSS 2.1.

display: table;

display: table-row;

display: table-cell;

Having below CSS and html, we can achieve this:

CSS:

.tabular

{

display: table;

}

.tabular-row

{

display: table-row;

position: relative;

height: 26px;

}

.tabular-cell

{

display: table-cell;

height:25px;

}

.tabular-cell-small

{

display: table-cell;

height:25px;

width:50px;

}

.tabular-cell-medium

{

display: table-cell;

height:25px;

width:114px;

}

CSHtml sample:

<h2>@Html.GetLocalizedString("xxxxxxxxxxxx")</h2>

</span>

</span>

</div>

@Html.GetLocalizedString("xxxxxxx")

</span>

</span>

@Html.GetLocalizedString("xxxxxxxxxxxx")

</span>

</div>

@Html.DropDownListFor(model => model.SelectedAccountXXXXX, new SelectList(Model.AccountXXXXXXList, "Id", "Name", Model.SelectedAccountXXXXX), new { @id = "accountGroupList", datavaluerequired = "data-value-required", @class = "required", style = "width:175px" })

</span>

</span>

@Html.DropDownListFor(model => model.SelectedBankXXXXXX, new SelectList(Model.BankXXXXList, "Id", "Name", Model.SelectedBankXXXX), new { @id = "bankList", datavaluerequired = "data-value-required", @class = "required", style = "width:175px" })

</span>

</span>

<button class="rounded">@Html.GetLocalizedString("prXXXXXX")</button>

</span>

</div>

Reference:

http://www.quirksmode.org/css/display.html

http://www.quirksmode.org/css/display.html#table

http://developer.practicalecommerce.com/articles/1941-CSS-display-table-display-table-row-and-display-table-cell-

Monday, March 3, 2014

Integrate ie 10 with visual studio 2010 debugging

There is a simpler fix for the JavaScript debugging issue in IE10:

Close IE

In elevated cmd prompt run this command:

regsvr32.exe "%ProgramFiles(x86)%\Common Files\Microsoft Shared\VS7Debug\msdbg2.dll"

(or %ProgramFiles% on a 32-bit OS)

Monday, December 2, 2013

How do I make background-size work in IE 8 and below versions?

A bit late, but this could also be useful. There is an IE filter, for IE 5.5+, which you can apply:

filter: progid:DXImageTransform.Microsoft.AlphaImageLoader(
src='images/logo.gif',
sizingMethod='scale');

-ms-filter: "progid:DXImageTransform.Microsoft.AlphaImageLoader(
src='images/logo.gif',
sizingMethod='scale')";

However, this scales the entire image to fit in the allocated area. So if your using a sprite, this may cause issues.

Specification: AlphaImageLoader Filter @microsoft

But this will not allow the links and buttons on the div clickable, for the workaround you need to change the z-index of the div or panel like below:



Untitled Document





    
        inhoud link b jkdsf


        vdf


        v


        dfv


        dfs


        v


        dfv


        dsf


        v


        dsf


        v


        inhoud link b jkdsf


        sdf


        v


        dsf


        v


        fdsv


        sdf


        v


        dsf


        v


        fdsv


        fds


        v


        dfsv


        dsf


        vsd

courtesy: http://stackoverflow.com/questions/2991623/how-do-i-make-background-size-work-in-ie
http://www.sitepoint.com/forums/showthread.php?462588-filter-progid-DXImageTransform-Microsoft-AlphaImageLoader-problem-in-IE6

Wednesday, November 27, 2013

Block unwanted Ads in your system

http://winhelp2002.mvps.org/hosts.htm

Monday, May 13, 2013

Find Nth Maximum value

"How do I find Nth maximum value?" is one of the most asked questions

Here are some methods

I explain how to find 5th Maximum value

declare  @number table(num integer) 

 

Insert into @number values(3456)

Insert into @number values(846)

Insert into @number values(1456)

Insert into @number values(3098)

Insert into @number values(34)

Insert into @number values(67856)

Insert into @number values(906)

Insert into @number values(34656)

Insert into @number values(9056)

Insert into @number values(3036)

(1) Use Inner Join

select t1.num from @number t1 inner join @number t2 on t1.num<=t2.num

group by t1.num having count(t1.num)=5

(2) Use Top Operator

Select top 1 num from

(

Select top 5 num from @number order by num desc

) T

order by num asc

(3) Generate Serial No based on descending order of the

select num from

(

Select (select count(*) from @number where num>=T.num)as Sno ,num

from @number as T

) as temp

where Sno=5

(4) Generate Serial No based on descending order of the values in where Clause

select num from @number as n

where (select count(*) from @number where num>=n.num)=5

(5) Use Aggregate

1.Select min(num) from (select top 5 num from @number order by num desc) T

(6) Use Row_number() function

select num from

(

select num, row_number() over (order by num desc) as sno from @number

) as t

where sno=5

 

Now you can replace 5 to the number that you want to find the maximum value

General SQL query should be as follows

select sal from emp a where N = (select count(distinct sal) from emp b where a.sal <= b.sal)
where N = any value.