CSS Mixer

CSSmixer128 Css mixer is a tool I’ve developped in C# winforms, .NET framework 3.5

You can use it to improve you ASP.NET Themes or your CSS files for all your web projects.

If you have many css files linked to a page, you can group them in a single file with CSS Mixer.

You can also minify CSS files to save the bandwith.

Â

To use it, open a folder containing CSS files,

cssmixer_screenshot

choose an action (simple combine, or combine and minify) then click Save as …

cssmixer_screenshot2

Download the last version of CSS Mixer on codeplex.

I hope you’ll find it usefull. please give me feedback on it

Get the parent Folder for a SPListItem

To retrieve the parent folder

my extension method


public static SPFolder GetParentFolder(this SPListItem spListItem)

{

if (spListItem == null)

return null;

SPFile spFile = spListItem.Web.GetFile(spListItem.Url);

if (spFile == null)

return null;

return spFile.ParentFolder;

}

Use


SPFolder parentFolder = sPListItem.GetParentFolder();

if (parentFolder != null)

{

// do some stuffs..

}

public static SPFolder GetParentFolder(this SPListItem spListItem)
{
if (spListItem == null)
return null;
SPFile spFile = spListItem.Web.GetFile(spListItem.Url);
if (spFile == null)
return null;
return spFile.ParentFolder;
}[/csharp]

Incoming search terms:

  • splistitem parent folder
  • splistitem get parent folder
  • splistitem get containg spfolder
  • splistitem change folder
  • get parent folder of splistitem
  • SPListItem parentfolder
  • how to get splistitem parent folder
  • get SPListItem parent folder
  • get splistitem folder
  • get parent folder for spitem

How to build a “visible on hover” action menu with CSS?

In my previous post I explain a way to build a “visible on hover” menu using jQuery.

Now, I’ll explain you how to do that without javascript, using only CSS.

First, built the web page and a CSS file


<html>
 <head>
 <title>Sam Beauvois | CSS on hover menu</title>
 <link href="demo.css" type="text/css" rel="stylesheet" />
 </head>

 <body>
 <h2>Visible on hover with CSS demo.<h2>
 <h3>Please put you mouse hover the following texts</h3>

 <div>
 Demo 1
 <div>
 <a href="#">action 1</a> | <a href="#">action 2</a> | <a href="#">action 3</a>
 </div>
 </div>

</body>

20100207_visibleOnHover_CSS_1Then add a class to the container and content divs

</pre>
<div class="hidden_action_container">
Demo 1
<div class="hidden_action">
<a href="#">action 1</a> | <a href="#">action 2</a> | <a href="#">action 3</a>
</div>
</div>
<pre>

And define the classes in the CSS file :


.hidden_action_container .hidden_action
{
 display: none;
}
.hidden_action_container:hover .hidden_action
{
 display:inline;
}

note the class declaration :

.hidden_action_container:hover .hidden_action

20100207_visibleOnHover_CSS_2
Now it’s functionnal,

Add a style to make it nicer :

.hidden_action_container
{
 padding : 15px 15px 15px 15px;
 background-color: #DDDDDD;
 border-style:solid;
 border-color:#EEEEEE;
 height:50px;
}

.hidden_action_container .hidden_action a
{
 color:#999999;
 font-size: 20px;
 font-weight:bolder;
}

.hidden_action_container .hidden_action
{
 display: none;
}
.hidden_action_container:hover .hidden_action
{
 display:inline;
}

20100207_visibleOnHover_CSS_3You can see the online demo here : http://www.sambeauvois.be/Demos/CSS/VisibleOnHover/demo.html

Incoming search terms:

  • hover action css
  • Content Title Visible image hover css
  • HOvER ACTION
  • html text mouseover image
  • visible div link hover

How to build a “visible on hover” action menu with jQuery ?

update 29/11/2010 : please notice that the same functionality could be achieved using css only

Here is a quick way to use jQuery library to create a “visible on hover” action menu.

I’ll explain step by step how to do that.

1.) Create an html page with actions in a container

<html>
 <head>
 <title>Sam Beauvois | jQuery usage demo 1</title>
 </head>
 <body>
 <h2>Visible on hover with jQuery demo.<h2>
 <h3>Please put you mouse hover the following texts</h3>
 <div>
 Demo 1
 <div>
 <a href="#">action 1</a> | <a href="#">action 2</a> | <a href="#">action 3</a>
 </div>
 </div>
 </body>
</html>

Result is

simple page

simple page

2.) Link the jquery library (here from google code, but you can download the library at jquery.com) and add a css class to the container div and one other to the action div


<head>
 <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js" ></script>
</head>
<body>
<div>
 Demo 1
 <div>
 <a href="#">action 1</a> | <a href="#">action 2</a> | <a href="#">action 3</a>
 </div>
 </div>
</body>

3.) Add a function :

<script type="text/javascript">
 $(document).ready(function()
 {
    ShowActionOnOver();
    $(".hidden_action",this).hide(); // hide all
 });

 function ShowActionOnOver()
 {
   $(".hidden_action_container").hover(
       function()
       {
          $(".hidden_action",this).show();
       },
       function()
       {
           $(".hidden_action",this).hide();
        }
    );
 }

 </script>

Now it’s functionnal, hover the zone to check :

jquery.visible.on.hover.demo2

4.) Now, add some css to make it nicer :

.hidden_action_container
{
 padding : 15px 15px 15px 15px;
 background-color: #DDDDDD;
 border-style:solid;
 border-color:#EEEEEE;
 height:50px;
}

.hidden_action a
{
 color:#999999;
 font-size: 20px;
 font-weight:bolder;
}
<head>
 <link href="demo.css" type="text/css" rel="stylesheet" />
</head>

And the final result looks like

jquery.visible.on.hover.demo3

You can see the online demo here.

http://www.sambeauvois.be/blog/2010/02/how-to-build-a-visible-on-hover-action-menu-with-css/

Incoming search terms:

  • div visible is hover
  • jquery add hover action
  • how to make a div visible on hover in jquery
  • hover css visible
  • hover corte action
  • wpf menu make visible on hover
  • div on hover jquery
  • datetimecontrol in sharepoint list jquery
  • css two actions visible and hover
  • css hover visible

How to get the list of all stored procedures using a specific table

Big projects with a lot of stored procedures can be a mess to maintain.

If you change one field in a table, you have to check if there is no side effect in the stored procedures using this table.

This “sp_depends” system stored procedure can help you finding your stored procedures using the table you modified.

Just create a new query, type


EXEC sp_depends @objname='tableName'

(replace “tableName” by the name of your table)

then execute.

result example :

example result

example result

Incoming search terms:

  • how can i get table in stored procedure
  • to get list of stored procedures using specific table