Feb 18, 2016

Freedom 251 Mobile at Rs.251 Only

Goto http://freedom251.com/

Cheapest Mobile for the people who cant go for smart phones

Freedom 251 Mobile at price of 251 by Ringing Bells.

Provided features
4 inch (10.2 cms) qHD IPS
3.2MP AF Rear Camera & .3MP Front camera
1450 mAh battery
Freedom 251 comes with 1.3 GHz Quadcore Processor capable of fast and responsive performance. 1GB RAM and 8GB internal memory, all the space you need. SD card support (expandable up to 32GB)
android Lolipop 5.1

Default apps : women safety,swachh Bharat,fisherman,farmar,Medical
Watsapp,facebok,Youtube,gmail

To provide futuristic technology products of the highest quality and best service at the lowest cost of ownership.

If this comes true I thank to the RInging Bell and the government to help the rural people make educated on technology.
All the best.

Ringing Bells Pvt. Ltd. is one of the fastest growing smartphone companies in India. We design and produce smart phones to provide a satisfying mobile experience for user.

What the company claims is:

Complete in-house product testing set-up in India. With best-in-class features, Freedom251 is the Indian smartphone brand at highly affordable prices. We are an amazing team of smartphone lovers who collaborate seamlessly to exchange technical and qualitative inputs and create quality products, along with testing at several stages to deliver the ultimate customer experience in its category.


Aug 3, 2015

Cannot open Excel file in C#

while working on "Open excel file" from application using C# or VB.net...
you may get below exception in exception handler..
Exception:
Excel cannot access the file 'c:\demofolder\demo.xls'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
or below message :

There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook.

Solution 
Operating system:

Windows 2008 Server x64 :
Go to the below path and Create a "Desktop" folder
C:\Windows\SysWOW64\config\systemprofile\

Windows 2008 Server x86 :
Go to the below path and Create a "Desktop" folder
C:\Windows\System32\config\systemprofile\

There are other also other ways to resolve this problem by modifying the Registry of MS Office Excel to make the files available which is not suggested.

Jan 14, 2015

Where the NET Frameworks directory located in System?

The default framework installations for Microsoft Dotnet of all versions will be installed in the below folders

C:\Windows\Microsoft.NET\Framework
And
C:\Windows\Microsoft.NET\Framework (Framework64)
eg:
v1.0.3705
v1.1.4322
v2.0.50727
v3.0
v3.5
v4.0.30319 (for V4.0 and V4.5 same folder but build version different)

Note for the Versions of 4.0 and 4.5 we will see only one folder that is "v4.0.30319" as the Microsoft Dotnet framework versions 4, version 4.5 has the same files but only difference is that the file build version will be different.
for Microsoft Dotnet Framework version 4.5 will have the build version greater than 17000.




Oct 3, 2012

How to Add a Column, Rename or Edit the Column in Oracle.

In Oracle the syntax for Adding the Column in the existing Table:

Alter Table [Table Name] Add [Column Name] [Colum Type]
Eg 1:
ALTER TABLE Emp ADD emp_rank NUMBER;
Eg 2:
alter table emp add emp_rating number;

For renaming the Column Name of the Table in Oracle:

Syntax:
ALTER TABLE [Table Name] RENAME COLUMN [Column Name] TO [New Column Name];

Eg 1:
 ALTER TABLE Emp RENAME COLUMN emp_rank TO emp_rnk;

Eg 2:
alter table emp rename column emp_rating to rating;



How to Alter a Table in Oracle.

We can do the alteration of the table using command called Alter.
Syntax:
Alter Table [Table Name] Rename To [New Table Name]
Eg:
Alter Table Book Rename To Store_Books;
alter table Emp rename to tbl_Emp;

Jun 8, 2012

Give the world the best you have, and the best will come to you !!!

An old man lived alone in Minnesota. He wanted to spade his potato garden, but it was very hard work. His only son, who would have helped him, was in prison. The old man wrote a letter to his son and mentioned his situation:


Dear Son,


I am feeling pretty bad because it looks like I won’t be able to plant my potato garden this year. I hate to miss doing the garden because your mother always loved planting time. I’m just getting too old to be digging up a garden plot. If you were here, all my troubles would be over. I know you would dig the plot for me, if you weren’t in prison.


 Love,
 Dad



Shortly, the old man received this telegram: ‘For Heaven’s sake, Dad, don’t dig up the garden!! That’s where I buried the GUNS!!’

At 4 a.m. the next morning, a dozen FBI agents and local police officers showed up and dug up the entire garden without finding any guns.

Confused, the old man wrote another note to his son telling him what had happened, and asked him what to do next.

His son’s reply was: ‘Go ahead and plant your potatoes, Dad. It’s the best I could do for you, from here.’


NO MATTER WHERE YOU ARE IN THE WORLD, IF YOU HAVE DECIDED TO DO SOMETHING DEEP FROM YOUR HEART, YOU CAN DO IT. IT IS THE THOUGHT THAT MATTERS, NOT WHERE YOU ARE OR WHERE THE PERSON IS.

May 29, 2012

Java script function for Delay in milliseconds

Code:
<html>
  <head>
    <script type="text/javascript">
      // Delay for a number of milliseconds
      //Function to delay the execution, this is not as the setTimeout() which will continue
 //the execution of next statement without waiting to return the funciotn call
      function delay(delayTime) {
        var start = new Date().getTime();// set the start time for counting
       while (new Date().getTime() < start + delayTime); //looping till the expected delay time matches..
      }
    </script>
  </head>
  <body>
    <h1>Delay 7sec!</h1>
      <script type="text/javascript">
alert("Start");
        delay(7000);
        alert("ended");
      </script>
  </body>
</html>


Oct 3, 2011

Love is of different ways and stages.


This is an innocent love at the age of 2-4 yrs.. here there will not be any selfishness.
you can find true love here.

Sep 23, 2011

Do's And Dont's from Guru Tanvi !.....

Well, according to Tanvi  there are two concepts
Concept 1
1. See with your eyes
2. Listen what all are talking, store it ( may be in use some other time)
 But don't open you mouth to speak

Concept 2
1. Listen to all and don't let it go from  any where.
i.e :  out N/A  ||_: <= in

Which one you follow that's up to you..






Never eat what ever you want it may harm your health and glamour.

Note: All greens things are not vegetables/ eatables.















Thank you for following Tanvi's Tips.
Wait for next post for TIPs from Tanvi ..


Sep 22, 2011

How to learn Walking from Tanvi !....

Hi friends this is Tanvi, and in this article I am going to teach How to Walk.
All parents help there kids to learn walking. But how a kid himself can start walking without any support of the parents.

Let us C

First of all you need to look for any wall or chair or sofa which is near and which a kid can catch and hold.
this will help to stand up and standing is the first step to walk.
now try to move your legs to and fro for making yourself balance.

  once you fell that it is OK then try to turn around with support of wall or any which is nearer.

Let the hands be free and be confidence, that says you are done..

Slowly put you leg a step, do not fear. you will learn very fast..
Note: This for parents- Let the kids learn them selves it helps to grow fast.


Here the best practice is to reach refrigerator, you find plenty of things in that.
Eg : Milk, chocolates, cakes, nuts etc. kids love to have them so they frequently visit this place.



That's all for now.

I think this article will help kids and parents to learn.
Wait for the next post. Tanvi....

How to drink water yourself from Tanvi !...

Hello every one and this is Tanvi, in this post I am going to teach you how to drink water from a can.
Note: This is advanced course and kids bellow 1.6 years are strictly avoided.

If you are above 1.6 then you can follow.
Open the water can cap /led. 



If it is not possible by you then take assistance from your friends or seniors, here she is katyayani (caty)


Now try to take the water from the water can using glass, but in this case glass will not workout.
so, I try using my small hand and get the water into my palm.

 Please do follow what ever I am doing, should not miss out any step or else you may not achieve the objective.

ok, now you can see how i am inserting my hand into the can.

 here it goes, 
I think this may not work out for us, so we have to go for plan B
Plan B is, put your mouth into the can and the water will come up.

 ya, at last I had my water, it is great that without my parents support i am able to drink the water.

That was my class for you all friends. enjoy drinking water. It is good for health My uncle says.

Thanks for reading this and i hope you learnt some thing from this article.
Will be back with new concept in next post..

Sep 21, 2011

Joke- Bhrami on the floor



Bhrami and the Doctor
Bhrami  : Doctor, I have a problem.Doctor : What's your problem?Bhrami  : I keep forgetting things.
Doctor : Since when do you have this problem?
Bhrami  : What problem?



How to think?..
Our Bhrami was filling up an application form for a job. He promptly filled the columns titled name,address,age etc, he came to the column "Salary Expected" He was not sure as to what to be filled there. After much thought he wrote: Yes

Sep 16, 2011

Date format in SQL Server 2005


SQL Server 2005 Date Formates
Date FormatStandardSQL StatementSample Output
Mon DD YYYY 1
HH:MIAM (or PM)
DefaultSELECT CONVERT(VARCHAR(20), GETDATE(), 100)Jan 1 2005 1:29PM 1
MM/DD/YYUSASELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY]11/23/98
MM/DD/YYYYUSASELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY]11/23/1998
YY.MM.DDANSISELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD]72.01.01
YYYY.MM.DDANSISELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD]1972.01.01
DD/MM/YYBritish/FrenchSELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]19/02/72
DD/MM/YYYYBritish/FrenchSELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]19/02/1972
DD.MM.YYGermanSELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY]25.12.05
DD.MM.YYYYGermanSELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY]25.12.2005
DD-MM-YYItalianSELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY]24-01-98
DD-MM-YYYYItalianSELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY]24-01-1998
DD Mon YY 1-SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY]04 Jul 06 1
DD Mon YYYY 1-SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY]04 Jul 2006 1
Mon DD, YY 1-SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY]Jan 24, 98 1
Mon DD, YYYY 1-SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY]Jan 24, 1998 1
HH:MM:SS-SELECT CONVERT(VARCHAR(8), GETDATE(), 108)03:24:53
Mon DD YYYY HH:MI:SS:MMMAM (or PM) 1Default +
milliseconds
SELECT CONVERT(VARCHAR(26), GETDATE(), 109)Apr 28 2006 12:32:29:253PM 1
MM-DD-YYUSASELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY]01-01-06
MM-DD-YYYYUSASELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY]01-01-2006
YY/MM/DD-SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD]98/11/23
YYYY/MM/DD-SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD]1998/11/23
YYMMDDISOSELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD]980124
YYYYMMDDISOSELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD]19980124
DD Mon YYYY HH:MM:SS:MMM(24h) 1Europe default + millisecondsSELECT CONVERT(VARCHAR(24), GETDATE(), 113)28 Apr 2006 00:34:55:190 1
HH:MI:SS:MMM(24H)-SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)]11:34:23:013
YYYY-MM-DD HH:MI:SS(24h)ODBC CanonicalSELECT CONVERT(VARCHAR(19), GETDATE(), 120)1972-01-01 13:42:24
YYYY-MM-DD HH:MI:SS.MMM(24h)ODBC Canonical
(with milliseconds)
SELECT CONVERT(VARCHAR(23), GETDATE(), 121)1972-02-19 06:35:24.489
YYYY-MM-DDTHH:MM:SS:MMMISO8601SELECT CONVERT(VARCHAR(23), GETDATE(), 126)1998-11-23T11:25:43:250
DD Mon YYYY HH:MI:SS:MMMAM 1KuwaitiSELECT CONVERT(VARCHAR(26), GETDATE(), 130)28 Apr 2006 12:39:32:429AM 1
DD/MM/YYYY HH:MI:SS:MMMAMKuwaitiSELECT CONVERT(VARCHAR(25), GETDATE(), 131)28/04/2006 12:39:32:429AM



Here are some more date formats that does not come standard in SQL Server as part of the CONVERT function.
Extended Date Formats
Date FormatSQL StatementSample Output
YY-MM-DD
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD]
99-01-24
YYYY-MM-DD
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD]
1999-01-24
MM/YYSELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY]
08/99
MM/YYYYSELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY]12/2005
YY/MMSELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM]99/08
YYYY/MMSELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM]2005/12
Month DD, YYYY SELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY]July 04, 2006
Mon YYYYSELECT SUBSTRING(CONVERT(VARCHAR(11), GETDATE(), 113), 4, 8) AS [Mon YYYY]Apr 2006
Month YYYYSELECT DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY]February 2006
DD MonthSELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) AS [DD Month]11 September
Month DDSELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD]September 11
DD Month YY SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + RIGHT(CAST(YEAR(GETDATE()) AS VARCHAR(4)), 2) AS [DD Month YY]19 February 72
DD Month YYYY SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY]11 September 2002
MM-YYSELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 5), 5) AS [MM-YY]
SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 5), 4, 5) AS [MM-YY]
12/92
MM-YYYYSELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 105), 7) AS [MM-YYYY]05-2006
YY-MMSELECT RIGHT(CONVERT(VARCHAR(7), GETDATE(), 120), 5) AS [YY-MM]
SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 5) AS [YY-MM]
92/12
YYYY-MMSELECT CONVERT(VARCHAR(7), GETDATE(), 120) AS [YYYY-MM]2006-05
MMDDYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 1), '/', '') AS [MMDDYY]122506
MMDDYYYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 101), '/', '') AS [MMDDYYYY]12252006
DDMMYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 3), '/', '') AS [DDMMYY]240702
DDMMYYYYSELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 103), '/', '') AS [DDMMYYYY]24072002
Mon-YY SELECT REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '-') AS [Mon-YY]Sep-02
Mon-YYYYSELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY]Sep-2002
DD-Mon-YY SELECT REPLACE(CONVERT(VARCHAR(9), GETDATE(), 6), ' ', '-') AS [DD-Mon-YY]25-Dec-05
DD-Mon-YYYY SELECT REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-') AS [DD-Mon-YYYY]25-Dec-2005
 To make the month name in upper case, simply use the UPPER string function.






Original Link

Mosquitoes King in Bangalore..

Blue Sky with Clouds in Bangalore

Diffrence between SQL Server 2000,2005 and 2008







SlSQL Server 2000SQL Server 2005SQL Server 2008
1Query
Analyser and Enterprise manager are separate.


Both are
combined as SSMS(Sql Server management Studio).


Both are
combined as SSMS(Sql Server management Studio).
2No
XML datatype is used.
XML
datatype is introduced.
XML
datatype is used.
3We
can create maximum of 65,535 databases.
We
can create 2(pow(20))-1 databases.
We
can create 2(pow(20))-1 databases.
4NillException
Handling
Exception
Handling
5NillVarchar(Max)
data type
Varchar(Max)
data type
6NillDDL
Triggers
DDL
Triggers
7NillDataBase
Mirroring
DataBase
Mirroring
8NillRowNumber
function for paging
RowNumber
function for paging
9NillTable
fragmentation
Table
fragmentation
10NillFull
Text Search
Full
Text Search
11NillBulk
Copy Update
Bulk
Copy Update
12NillCant
encrypt
Can
encrypt the entire database introduced in 2008.
13Cant
compress the tables and indexes.
Can
Compress tables and indexes.(Introduced in 2005 SP2)
Can
compress tables and indexes.
14Datetime
datatype is used for both date and time.
Datetime
is used for both date and time.
Date
and time are seperately used for date and time datatype,geospatial and
timestamp with internal timezone is used.
15No
varchar(max) or varbinary(max) is available.
Varchar(max)
and varbinary(max) is used.
Varchar(max)
and varbinary(max) is used.
16No
table datatype is included.
No
table datatype is included.
Table
datatype introduced.
17No
SSIS is included.
SSIS
is started using.
SSIS
avails in this version.
18CMS
is not available.
CMS
is not available.
Central
Management Server(CMS) is Introduced.
19PBM
is not available.
PBM
is not available.
Policy
based management(PBM) server is Introduced.

Jul 29, 2010

This bridge is half under the water, for ships to pass and then again, it comes out on the other side.

Truly a marvelous piece of engineering!
This bridge is between Sweden and Denmark
 
 

iRahman - 15 Essential Tracks: Vol. 2 Hindi














Koi Na Tere (Language: Hindi; Film: Amardeep; Film Artists: Rajesh Khanna, Shabana Azmi)
How the World is !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Why teachers always seemed so mad?

Mastermind for Kids 
When in School we always wondered why teachers always seemed so mad

Now we know the reason….coz they are so stressed out by kids



Why??????? Read below the essays to know



Interesting answer..given by children to make teachers world upside down



 
 Candy Land Castle Game



Pictureka