Sai Online banking solution 8777

Sai banking solution 8777 Demo

AMOUNT FORMAT EXPORT TO EXCEL USING ASP.NET C#

Use This :

HttpContext.Current.Response.Write("<style>  .txt " + "\r\n" + " 

{mso-style-parent:style0;mso-number-format:\"" + @"\@" + "\"" + ";}

 " + "\r\n" + 

 "</style>");

 
HttpContext.Current.Response.Write("<Td class='txt'>&#8203;");
HttpContext.Current.Response.Write(row["Amount"]); // row is youre datarow
HttpContext.Current.Response.Write("</Td>");

You Can Also Use Below FORMAT

 mso-number-format         

mso-number-format:"0"	NO Decimals
mso-number-format:"0\.000"	3 Decimals
mso-number-format:"\#\,\#\#0\.000"	Comma with 3 dec
mso-number-format:"mm\/dd\/yy"	Date7
mso-number-format:"mmmm\ d\,\ yyyy"	Date9
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM"	D -T AMPM
mso-number-format:"Short Date"	01/03/1998
mso-number-format:"Medium Date"	01-mar-98
mso-number-format:"d\-mmm\-yyyy"	01-mar-1998
mso-number-format:"Short Time"	5:16
mso-number-format:"Medium Time"	5:16 am
mso-number-format:"Long Time"	5:16:21:00
mso-number-format:"Percent"	Percent - two decimals
mso-number-format:"0%"	Percent - no decimals
mso-number-format:"0\.E+00"	Scientific Notation
mso-number-format:"\@"	Text
mso-number-format:"\#\ ???\/???"	Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00"	£12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ "	2 decimals, negative numbers in red and signed (1.56 -1.56)

Save full length video

Save large video files using this settings in ur web.config file (setting highlighted in RED color);

Download Sourse code and sql db script :
Link : Click me To download sourse code





<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
    <system.web>
        <compilation debug="true" targetFramework="4.0" >
    
            <assemblies>
                <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
                <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/></assemblies></compilation>
   <httpRuntime  executionTimeout="9999" maxRequestLength="2073741824" enable="true"/>
    </system.web>
    <system.webServer>
    <security>
      <requestFiltering>
        <requestLimits maxAllowedContentLength="2073741824"/>
        
      
      </requestFiltering>
    </security>
 
    </system.webServer>
    <connectionStrings>
        <add name="8777" connectionString="Data Source=SERVER8777;Initial Catalog=Gallery_7;User ID=sa;Password=8777"/>
    </connectionStrings>
<appSettings>
  <add key="Port" value="http://localhost:6777"/>
  <add key ="FolderPath" value ="Video"/>
</appSettings>

</configuration>