TechSapphire Thursday, 2018-07-19, 4:42 PM
Site menu
Login form
News
Play Games
  • Deep Freeze
  • Ice Slide
  • Gyroball
  • Fat Fish
  • Bush Royal Rampage
  • Main » Entries archive
    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 »
    Category: Programming | Views: 29624 | Added by: Admin | Date: 2014-03-09 | Comments (0)



    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
    Category: Programming | Views: 1907 | Added by: Admin | Date: 2014-03-02 | Comments (1)

    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
    Category: Database | Views: 11514 | Added by: Admin | Date: 2013-11-18 | Comments (0)


    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 »
    Category: Programming | Views: 26246 | Added by: Admin | Date: 2012-11-06 | Comments (3)


    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
    Category: Programming | Views: 25616 | Added by: Admin | Date: 2012-11-02 | Comments (1)

    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.

    Category: Programming | Views: 6493 | Added by: Admin | Date: 2012-11-02 | Comments (0)

    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 »
    Category: Programming | Views: 12537 | Added by: Admin | Date: 2012-11-02 | Comments (2)

    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

    Category: Programming | Views: 1759 | Added by: Admin | Date: 2012-11-02 | Comments (0)

    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 »
    Category: Database | Views: 16356 | Added by: Admin | Date: 2012-10-26 | Comments (1)

    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
    Category: Database | Views: 18254 | Added by: Admin | Date: 2012-09-04 | Comments (0)

    « 1 2 3 4 5 6 7 »
    Categories
    Programming [27]
    Tips for programming
    Security [2]
    Security Tips
    Google [1]
    Use google faster then ever you use
    Project [14]
    HTML [2]
    Electronics [0]
    Data Structure [0]
    Database [16]
    SQL SERVER
    SSRS [1]
    Sql Server Reporting Services
    Copyright MyCorp © 2018