Posts

Redeem Calculation Only

create table PurRedTranTable ( id int identity(1,1), folionumber varchar(20), schemecode varchar(20), plancode varchar(20), tdate date, units float, transtype varchar(20), purred varchar(20), nav int ) INSERT INTO PurRedTranTable VALUES('100', 'FF', 'GP', '06/01/18', '300', 'SIP','P', 20 ); INSERT INTO PurRedTranTable VALUES('100', 'FF', 'GP', '06/10/18', '50', 'SIP','P', 20 ); INSERT INTO PurRedTranTable VALUES('100', 'FF', 'GP', '06/20/18', '50', 'SIP','P', 20 ); INSERT INTO PurRedTranTable VALUES('100', 'FF', 'GP', '06/30/18', '200', 'RED','R', 20 ); INSERT INTO PurRedTranTable VALUES('100', 'FF', 'GP', '07/10/18', '100', 'SIP','P', 20 ); INSERT INTO PurRedTranTable VA...
Post a Comment
Read more

Export to MacroEnableExcel File

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="EPPlusForMacroExcel.aspx.cs" Inherits="WebApplication1.EPPlusForMacroExcel" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title></title>     <script src="Scripts/jquery-3.3.1.js"></script>     <script src="JavaScript/JavaScript1.js"></script>     <script>         $(document).ready(function () {             $("#Button0").click(function () {                 //****Set validation****                 var startDt = $("#Text1").val();                 var endDt = $("#Text2").val();                 $.ajax({                 ...
Post a Comment
Read more
Export 2 Excel using EPPlus create table EPPlus ( Id int, fname varchar(255), lname varchar(255), addr varchar(255), salary int, gradute bit, dob datetime ) --------------------------------------------------------------------------------------------------------- insert into EPPlus values (1,'harshal','desai','mumbai',10000,1,getdate()) insert into EPPlus values (2,'sneha','gaikwad','mumbai',20000,2,getdate()-10) insert into EPPlus values (3,'sachin' ,'tendulkar','mumbai',30000,3,getdate()-250) --------------------------------------------------------------------------------------------------------- CREATE PROCEDURE tableA  AS        SELECT id, fname, lname, addr FROM EPPlus GO CREATE PROCEDURE tableB  AS        SELECT id, salary, gradute, dob FROM EPPlus GO ----------------------------------------------------------------------------------------------------- ---Make Sure You install...
Post a Comment
Read more