For fixing this issue just follow simple steps below:
1. Open jquery.elevatezoom.js file in notepad.
2. Now you will see code below:
(function( $, window, document, undefined ) {
    var ElevateZoom = {
            init: function( options, elem ) {
                var self = this;

                self.elem = elem;
                self.$elem = $( elem );

                self.imageSrc = self.$elem.data("zoom-image") ? self.$elem.data("zoom-image") : self.$elem.attr("src");

Just replace highlighted code with code below:

                self.imageSrc = self.$elem.attr("sr ... Read more »

In this lecture you will cover mainly:
What to do before interview ?
What no to do before interview ?

Resume is main part. Please reference attached files for interview and PPT.

Click to go to download page

This lecture is on complex query SQL server, topic covered are:
• OUTPUT Clause
• RANK(), ROW_NUMBER() and DENSE_RANK() Function
• Query Optimization and Use of execution plan.



Click Here to see full article and download sql script

ASP.NET Dynamic Data is used to create data-driven web applications with minimal coding. ASP.NET Dynamic Data have the advantage of using all capabilities of the Dynamic Data Framework. You can also add specific capabilities of Dynamic Data to an existing Web application, such as:

• Web scaffolding, which is a mechanism to enhance the existing ASP.NET page Framework by dynamically display webpages based on the data model. Web scaffolding involves running a Web Application by reading the underlying database schema. Dynamic Data Scaffolding can generate a standard user interface(UI) from the data model.
• Full access to data operations (such as CREATE, DELETE, UPDATE, REMOVE and DISPLAY), relational operations, and data validation.
• Support for foreign-key relationships that allows Dynamic Data to detect the relationships among tabl ... Read more »

XSLT is very simple but powerful way to handle dynamic transform. In this example i have used XML datasource and XSLT file for generating dynamic nested menu. The menu source is an SQL server database. The script for generating SQL table is also provided with solution.

Download source code of dynamic nested menu using XSLT

Create Excel (xls) from gridview, XSLT from XML using c#, ASP.NET or .NET

In this example i have covered 2 ways of generating XLS:

1. From Gridview
2. Using XLST file

Code for Gridview to XLS:

Download code for Gridview to Excel


Code for XLS using XSLT:

Download code for generating excel using XSLT

Note:

• Better way is using XSLT.
• XSLT is fast resource for generating XSL
• Can be used with any datasource taking XML in between.
  

Generating HTML from XML, Database, Dataset

HTML from XML file source is generated, but you can use dataset to generate HTML from database by generating XML using dataset. In this example i have used XSLT file to transform XML to HTML file.

Download source code

Code:
        string source = Server.MapPath("~") + "//XMLFile.xml";
        string style = Server.MapPath("~") + "//XSLTFile.xslt";
        string destination = Server.MapPath("~") + "//a.html";
        XslTransform transfor=new XslTransform();
        transfor.Load(style);
        transfor.Transform(source,destination);

XSLT:

<xsl:stylesheet version="1.0" xmlns:xsl="htt ... Read more »

Read html, text or content between HTML tag c#. .NET

It is very easy to read content between HTML tag using c#. Steps for reading HTML content are as follows:

• Using namespace System.Xml
• Code:

        XmlDocument a=new XmlDocument();
        a.Load(Server.MapPath("~") + "//a.html");
        XmlNode n = a.SelectSingleNode("/html/body");
        TextBox1.Text = n.InnerXml;

       Note:

• Be sure about case sensitivity of tag example (/HTML/BODY) in place of (/html/body).

Download source

Read complete article



----Basic but important functions
--ROW_NUMBER()
--RANK()
--DENSE_RANK()
--NTILE()

--ROW_NUMBER() --Returns a sequential row number with in partition of result set
use Northwind;
SELECT ROW_NUMBER() over(order by productid) as [Row No.], ProductName from Products;

----Getting alternate rows
------Odd Row
select * from (SELECT ROW_NUMBER() over(order by productid) as [Row No.], ProductName from Products) p where p.[Row No.]%2=1;
------Even Row
select * from (SELECT ROW_NUMBER() over(order by productid) as [Row No.], ProductName from Products) p where p.[Row No.]%2=0;
------Row Between
select * from (SELECT ROW_NUMBER() over(order by productid) as [Row No.], ProductName from Products) p where p.[Row No.]
Between 5 and ... Read more »

Union is to select all records from two table but common record only once.

Select * from tbemp1
UNION
Select * from tbemp2


Inersect is to select common records from two tables.

Select * from tbemp1
INTERSECT
Select * from tbemp2

Except(Minus) is equivalent to oracle minus clause. Select records of table 1 which are not in table 2.

Select * from tbemp1
EXCEPT
Select * from tbemp2