H! This video for block user to enter manual url

https://youtu.be/Tpsop5WkSZA

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>

COLOUMN Store Index In Sql Server

Column Store Index Is Help For Improve Query Performance

1. Logical Reads And Physical Reads can Use Lot's Of Disk Use For Ur Hard Disk,
    And When Ur Disk Use 100% in use that time Ur SQL Not Responding and Ur
    Query Performance is Reduse 100%.

Download DEMO Col Store Index Script It's Help U To Avoid Above Disk Use And
Improve SQL Query Performance

     --=>>> Click Here To Download Sample Col Store Script--<<===

    -->>Click Here To Download My Blog Android App --<<=


If Any Query About This Demo Please Let Me Know

Contact Details :

Mob : +91-9673178777
Email:  Pathrikarsai77@gmail.com
            Pathrikararul7@gmail.com
            Pathrikaratul7@rediffmail.com
           

Diff between case statement and choose function in sql

Diff between convert and try conver in SQL

Error handling database level

Go to statement in sql

How to create job in Sql

SQL INJECTION PART 3

SQL INJECTION PART 2

SQL INJECTION PART 1

Get running total salary

TEXT TO SPEECH IN CONSOLE APPLICATION

note : add new abstract class

 abstract class _absract
{
        public abstract string GetDate();
        public virtual string GetVirtualData()
        {
            string str = "H! I am from Virtual...";
            Console.Write(str);
             return str;
        }

}

step 2: add new 2nd class

using System.Speech.Synthesis;
namespace factorialprog_7.RAJU_MAMA.abstract7
{
    class Non_abstract : _absract
    {
        public override string GetDate()
        {   

            string Time = "The Time Is: " + System.DateTime.Now.ToShortTimeString();
            string Date= "The Date Is: " + System.DateTime.Now.ToShortDateString();
            Console.WriteLine(Time +" " + Date);
            return Time + Date;
        }
        public override string GetVirtualData()
        {
            string str = "Bye I Am From Override...";
            Console.WriteLine(str);
            return str;
        }

        static void Main()
        {
            Non_abstract NA = new Non_abstract();

            SpeechSynthesizer synthesizer = new SpeechSynthesizer();
            synthesizer.Volume = 100;
            synthesizer.Rate = -2;

         
            synthesizer.Speak(NA.GetVirtualData());
            synthesizer.Speak(NA.GetDate());
           
            Console.ReadLine();



        }


    }
}


it's work plz comment if any query

HOW TO GET 3RD Highest Employee Salary In Sql 2008 R2

Ans:


Step 1 : Create Table

CREATE TABLE Tbl_Salary
(
    id int NOT NULL primary key,
    Name nvarchar(max) NULL,
    Salary money NULL
)

Then Step 2 : Insert Employee Record


 insert Tbl_Salary values (1001,'Atul Pathrikar',10000);
insert Tbl_Salary values (1002,'Sai Pathrikar', 9000)
insert Tbl_Salary values (1003,'Pravin Pathrikar',8000)
insert Tbl_Salary values (1004,'Vijay Pathrikar',7000);
insert Tbl_Salary values (1005,'Vishal Pathrikar',6000);
insert Tbl_Salary values (1006,'Rohit Pathrikar',5000);
insert Tbl_Salary values (1005,'Kartik Ingle',4000);

Tbl_Salary

 Step 3: Type 1st For Get 3RD highest Salary



SELECT Max(salary)
FROM   Tbl_Salary
WHERE  salary <
 (SELECT Max(salary)  FROM   Tbl_Salary
                 WHERE  salary NOT IN(SELECT Max(salary)
                                      FROM   Tbl_Salary))
                                  
                                   
                                     
                                     

3Rd Highest Salary

                                                                          OR

 Type 2nd To Get 3rd Highest Salary:

SELECT TOP (1) * FROM
   (SELECT TOP (4) Salary ,Name FROM Tbl_Salary ORDER BY salary DESC)
  Salary
ORDER BY salary ASC

3Rd Highest Salary

                                                                           OR

Type 3rd Get 3rd Highest Salary Using CTE(Common Table Expression)

create proc SP_Gethigestsal
(
@higestsalposition int
)
as
with Tbl_ctesal as
(
select *, DENSE_RANK() over(order by salary desc) as HigestSal from Tbl_Salary
)
select Name,Salary from Tbl_ctesal where HigestSal=@higestsalposition
return

--exec  SP_Gethigestsal 3

With CTE Get 3rd Highest Salary

 Try This  Any this 3 Step To Get 3rd Highest Salary

Note: You Also Get 2nd,4th,5th,6th,7th Highest Salary using This Any 1 Sql Query





Thank You For Visit my blog


if you have any query Comment And Share blog,
My YouTube Channel Name: TheAtulpathrikar7,   Atul Pathrikar
watch my all programming and Sql videos on Youtube ,

My-Email_ID: pathrikaratul7@gmainl.com
                       pathrikaratul7@rediffmail.com

send me youre Query on My Mail ID


My Mobile Number : +91-9673178777







Thank You Friends

AP8777

Get 3rd Higest Max salary in Sql query

Windows messagebox use in Asp Net using C#

Inheritance multilevel interface using c#

Download This Sql Script (All Query in This Script) 8777 <== Click Here To Download