Ap 7 Traslator

Wednesday, June 21, 2017

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


Friday, June 9, 2017

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


































































































































































Tuesday, January 17, 2017

Sql all 8777

Sql procedure With Function Calling And Get Max Salary ,Sub query

Friday, January 6, 2017

Thursday, December 22, 2016

Android App Using C#

Upcoming Videos
<<You can Create Android application using C# language>>

Wait for Video


Thanku.......
8777

Saturday, September 3, 2016

Why are You Going To Hydrabad. Learn Here In Aurangabad Good News To All New C#.Net Learner I Am Starting Classes At Begumpura Aurangabad.
Those Are Intrested To Do Classess
Contact Me On My Team ,

1.Atul Pathrikar:9673178777
2.Ajay Kale: 9689311143
3.Rahul Nawghare :7709024135