SP2(service pack 2) for Microsoft SharePoint 2010 (KB2687453)
If you like to know complete details of packages or CU's included in this Service Pack 2,view this page
Therefore a swim lane diagram integrates your distinct actions in a systematic way ,thus representing it in a modular way and finally making the Workflow process a simple and readable.
Hope this would help you understand easy the need for swim lane diagrams in processing workflow solutions and shall be back with another useful concept in sharepoint. If you have any queries regarding any issue in sharepoint ,please feel free to write me on sri.restart@gmail.com.<html> <head> <style type="text/css"> .popupBody * { MARGIN-RIGHT: 15px; } .popupBody { OVERFLOW: auto; HEIGHT: 500px; MARGIN-LEFT: 7%; WIDTH: 92.8%; } .popupTitle { BACKGROUND-COLOR: #e13e43; border-top-left-radius: 5px; border-top-right-radius: 5px; } .popupTitle H2 { HEIGHT: 40px; COLOR: white; PADDING-BOTTOM: 5px; PADDING-TOP: 15px; PADDING-LEFT: 20px; MARGIN: 0px; } #lean_overlay { HEIGHT: 100%; BACKGROUND: #000; POSITION: fixed; LEFT: 0px; FILTER: alpha(opacity=30); Z-INDEX: 100; DISPLAY: none; TOP: 0px; WIDTH: 100%; opacity: 0.3; } .popupClose { RIGHT: 12px; POSITION: absolute; Z-INDEX: 2; TOP: 12px; text-decoration: none; color: white; } .popupContent { BORDER-TOP: #ccc 1px solid; BORDER-RIGHT: #ccc 1px solid; BORDER-BOTTOM: #ccc 1px solid; BORDER-LEFT: #ccc 1px solid; DISPLAY: none; TOP: 10%; width: 35%; height: 45%; } .popupWindow { WORD-WRAP: break-word; FONT-SIZE: 13px; HEIGHT: auto; FONT-FAMILY: san serif; BACKGROUND: white; POSITION: absolute; MARGIN-LEFT: 28%; Z-INDEX: 11000; LETTER-SPACING: 1px; WIDTH: 40%; -moz-box-shadow: 0 0px 4px rgba(0, 0, 0, 0.7); -webkit-box-shadow: 0 0 4px rgba(0, 0, 0, 0.7); box-shadow: 0px 0px 4px rgba(0, 0, 0, 0.7); border-radius: 5px; -moz-border-radius: 5px; -webkit-border-radius: 5px; } </style> <script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function () { /****** Close popup ******/ $(document).on('click', '.popupClose', function (e) { e.preventDefault(); $('.popupWindow').css('display', 'none').removeClass('popupWindow'); $("#lean_overlay").remove(); }); /******Trigger popup ********/ $('.popupTrigger').click(function () { var dialog = $(this).next('.popupContent'); $('.popupClose').css('display', 'block'); dialog.css('display', 'block').addClass('popupWindow'); var overlay = $("<div id='lean_overlay'> </div>").css('display', 'block').addClass('popupClose'); $("body").append(overlay); return false; }); }); </script> </head> <body> <div class="popup"> <a class="popupTrigger" href="#">Click here to see popup</a> <!-- This is the model popup content --> <div class="popupContent"> <!-- Titel for popup goes in <h2> tag ----> <div class="popupTitle"> <h2>Simple pop up using jquery </h2> </div> <!-- Body of popup goes into <p> tag --> <div class="popupBody"> <a class="popupClose" href="">Close</a> <p>Now you are able to create a simple and beautiful pop-up window.You can try not only plain text in it but also design according to our taste and could even create a form with any control you could use in your webpages.Hope you understand this and try to apply it in your applications whereever you feel it required.Lorem Ipsum has been the industry's standard dummy text ever since the 1500s,when an unknown printer took a galley of type and scrambled it to make a type specimen book. </p> </div> </div> </div> </body>
StyleCop is an open source static code analysis tool from microsoft which is used to maintain coding standards for the c# code
Step1:Now run the project it won’t show any warning ,we have run style cop manually .
We can integrate this process to MSBuild by adding tag in ‘.csproj ‘ file.
To do that we have unload project first then open “csproj” file to include those tags.Edit csproj file
Copy the path of the file styleCop.Targets
Include that stylecop.Targets path in import tag in csproj file
Now save changes and reload the project. Now buid /run solution , you find warnings on fly as shown below
To show those warnings as errors add following tag to csproject file as shown below in the rounded codeSave and reload project . Now run/build project . you will see following screen
So when we create a sqlconnection object which is a reference datatype memory is allocated in the heap and the object persists even if the connection is closed.So if there are multiple instances in your code using the connection object ,each instance occupies memory in the heap which reduces the performance.
So using(SqlConnection con=new SqlConnection) overcomes this issue.It helps disposing an object automatically once the connection is closed .So no extra memory is used even if you have multiple instances of your sql connection.
The using statement has an inbuilt a try-finally statement that calls the Dispose method.Here in this post I would like to make you clear on how and why to use ‘using(SqlConnection) rather simply opening and closing the connection while you are trying to deal with SQL Server. Generally when we try to interact with the database ,we simply create a connection object as
SqlConnection con=new sqlConnection();We then use the connection object to establish a connection to the server which we normally do it in the try block, then followed by a catch to display any exceptions and ultimately winding up in the finally winding up in the finally block in which we cclose the connection made to the server.
Here is the simple conventional example which most of us follow to establish a connection In the below example I am trying to insert the details of a person into the database.
var cs = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; SqlConnection cn = new SqlConnection(cs) { var addContact = "INSERT INTO Contacts VALUES (@FirstName, @Email,@Phone, @LandLine,@Website, @Address)"; SqlCommand cmd = new SqlCommand(addContact, cn); cmd.Parameters.Add("FirstName", SqlDbType.NVarChar).Value = cnt.FirstName; cmd.Parameters.Add("Email", SqlDbType.NVarChar).Value = cnt.Email; cmd.Parameters.Add("Phone", SqlDbType.NVarChar).Value = cnt.Mobile; cmd.Parameters.Add("LandLine", SqlDbType.NVarChar).Value = cnt.LandLine; cmd.Parameters.Add("Website", SqlDbType.NVarChar).Value = cnt.Website; cmd.Parameters.Add("Address", SqlDbType.NVarChar).Value = cnt.Address; try { cn.Open(); cmd.ExecuteNonQuery(); status = true; } catch (Exception e) { return status; } finally
As you see in the above example we just opened the connection to the server,inserted details then closed the connection. Now look at the same example using the ‘using’ statement
var cs = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString; using( SqlConnection cn = new SqlConnection(cs)) { // insert the parameters try { cn.Open(); cmd.ExecuteNonQuery(); } catch (Exception e) { } } // we need not specially close the connection ,con.close() that is the speciality of using statement, It automatically closes the instance and disposes the object.
Therefore using(sqlConnection) disposes the objects and releases the connection soon after the interaction with the database,which helps to reduce the heap memory used and thus increasing the perfomance.