vijay

welcome Netizen

welcome Netizen
Hi folks this site Share Basic Knowledge in .NET, DotNet, C#,DOT NET CODE, ASP.NET, VB.NET, DOT NET TRICKS,Dotnetcode,Android and Latest Technology Articles in VB,Android and ASP.NET

Tuesday, May 31, 2011

How To Get A Google +1 Button On Your Website or Blogger.


hi..
Google has going to launch +1 button for all websites,Its like facebook Like buttton,By using this button easy to  share the informationwith  one click.
since its avilable only in google search,In very soon google going to launch in all sites.
If you have any blog or Website just register your site in google for +1 button ,
click the link for register..
You can sign up for email updates at our +1 Google site.

How to get the Browser Version and Operating system version in Asp.Net


Hi..
Here i have wrriten the code for to find Browser name,version and also find operating system used in browsing system
There many methods used to find the value..Here list of codes used to find the task.......

        Response.Write(Request.Browser.Browser & "<br>") 'its return Browser name
        Response.Write(Request.Browser.Version & "<br>")   'its return Browser version
        Response.Write(Request.Browser.Platform & "<br>") its return os name

 Also you can use this code to find the os version.....

        Response.Write("The OS Version is " & System.Environment.OSVersion.ToString())


        Response.Write(Request.UserHostAddress & "<br>")

i hope it helpful .....

How to convert a Time in 24 hours format


hi..

Here i mention the code for converting time format..
i hope many of them could search for this code....

Dim tme as string


 tme = TimeOfDay.ToString("HH:mm:ss")


tme returns 24 hr format

Sunday, May 29, 2011

Usage of Connection pooling in ADO.NET


Connection Pooling is helps to reuse the database connection for more than one user. That connection might be SQL, or OLEDB its improves performance as the applications do not need to open and close the connection multiple times.

When the connection is closed or disposed in ADO.NET, it is returned to the connection pool and remains idle for until a request for a new connection comes in.If the no connection comes , the connection to the backend is closed and the connection instance is removed from the Connection Pool.

Connection pooling improves the performance of asp.net,

Normally connection pooling is declard in web.congif  connection string ...

<connectionStrings>

    <add name="Proj" connectionString=" uid=guest; pwd=007; database=student; Pooling=true; Max pool size=100; Min poolsize=0""/>
  
</connectionStrings>

i hope this one helpful to you...........

Tuesday, May 24, 2011

How Microsoft And Skype Embarrassed Google


If Microsoft put together a welcoming committee for Google’s new CEO Larry Page as Page assumed his new job recently, it couldn’t have done a better job.


First the software giant took the wraps off its Office 365 beta, which turns out to be far and away better than any single aspect of Google’s Google Apps offering.
Now, Microsoft announces it's buying Skype for $8.5 billion, and Page and Google have never looked weaker and more vulnerable from a solution perspective. The information technology world is changing faster and more meaningfully than it ever has, and Google now is far behind Microsoft in key areas and could rapidly lose its advantage in another.

Microsoft now has potential to embed Skype audio and video calling into Office 365, Outlook and Web mail products. While Google has for some time integrated audio and video into Gmail, it hasn’t picked up momentum in this space—largely because Skype has maintained fierce user loyalty. Microsoft now has that 170 million Skype installed base in its column, and that’s one big bat it can use to beat up Google;

Once this deal closes, Microsoft will immediately have a presence on tens of millions of smart phones that now have Skype Mobile—the powerful video-and-audio calling that works even at 3G speeds. That presence will even include Android phones—which had previously been Google’s playground.

Skype Mobile now becomes a gateway on Android phones into Microsoft’s Office, SharePoint, Exchange and even SQL Server. That means Microsoft’s current installed base across all products need not abandon its IT investment regardless of which smart device platform it selects to reach the edge of network.

Microsoft, as part-owner of Facebook, is now positioned strongly to drill Skype deep into the world’s largest social networking platform. Facebook with voice and video baked in would be a more powerful Facebook, and it will bear watching to see if a Microsoft-Skype duo becomes a trio with Facebook.

And, for Microsoft Chairman and CEO Steve Ballmer, here’s the beauty part: Microsoft can now integrate its Bing search technology into Skype on both the desktop and smart platforms.

That means Bing, through Skype, could be in front of hundreds of millions of eyeballs that would otherwise default to Google for search and search advertising. And, as we all know, search advertising is the secret sauce that keeps Google hot.

Until today, Microsoft could never really obtain beachhead in search. The operative phrase, here, is “until today.”

Ballmer and Skype CEO Tony Bates emphasized, repeatedly, during a press conference Tuesday morning that they intend to leverage the Microsoft-Skype marriage to score big with advertising—including video- and rich-media-based ads.

Ballmer and Bates also made it clear that the real bull’s-eye for them in this deal is the commercial IT space—where the marriage of VoIP and video have at times been pricey and integration with multiple platforms has at times been complex.

A Microsoft-Skype bundle for communications—if executed correctly with Microsoft’s solution provider channel, which must sell and deliver the deal to the IT marketplace—will be a game-changer. It would enable text, voice, video, collaboration and communication from the smart phone to the back office to the cloud.

In other words, for $8.5 billion, Microsoft gets its money’s worth. And Google and Page get a choice. They can respond with aggressive R&D, marketing and vision, or they can call the anti-trust lawyers and hope the courts can save them from a Microsoft-Skype union. Microsoft executives say they expect the regulatory process to finish up by year’s end. It’s safe to say they are somewhat familiar with the process.

Microsoft and Skype, together, are each stronger and leave Google much weaker. From a solutions perspective, MicroSkype comes at the perfect time with the perfect weapons in its arsenal.

Google to launch operating system


Google is developing an operating system (OS) for personal computers, in a direct challenge to market leader Microsoft and its Windows system.
Google Chrome OS will be aimed initially at small, low-cost netbooks, but will eventually be used on PCs as well.
Google said netbooks with Chrome OS could be on sale by the middle of 2010.
"Speed, simplicity and security are the key aspects of Google Chrome OS," the firm said in its official blog.
The operating system, which will run on an open source licence, was a "natural extension" of its Chrome browser, the firm said.
The news comes just months before Microsoft launches the latest version of its operating system, called Windows 7.

'Back to basics'
"We're designing the OS to be fast and lightweight, to start up and get you on to the web in a few seconds," said the blog post written by Sundar Pichai, vice-president of product management, and Google's engineering director Linus Upson.
 So at long last Google is making its move. It is poised to strike at the heart of Microsoft's software empire. 
Tim Weber, Business editor, BBC News website
Both men said that "the operating systems that browsers run on were designed in an era where there was no web" and that this OS was "our attempt to rethink what operating systems should be".
To that end, the search giant said the new OS would go back to basics.
"We are completely redesigning the underlying security architecture of the OS so that users don't have to deal with viruses, malware and security updates.
"It should just work," said Google.
Google already has an operating system for mobile phones called Android which can also be used to run on netbooks. Google Chrome OS will be aimed not just at laptops but also at desktops for those who spend a lot of time on the web.
'Truly competitive'
The announcement could dramatically change the market for operating systems, especially for Microsoft, the biggest player with around 90% share.
"This announcement is huge," said Rob Enderle, industry watcher and president of the Enderle Group.
"This is the first time we have had a truly competitive OS on the market in years. This is potentially disruptive and is the first real attempt by anyone to go after Microsoft.
"Google is coming at this fresh and, because it is based on a set of services that reside on the web, it is the first really post-web operating system, designed from the ground up, and reconceived for a web world," Mr Enderle told the BBC.
 It's a few hours since Google used its company blog to announce its entry into the operating systems market, and already opinion is strongly divided 
Rory Cellan-Jones
BBC's technology correspondent
Last year Google launched the Chrome browser, which it said was designed for "people who live on the web - searching for information, checking e-mail, catching up on the news, shopping or just staying in touch with friends".
Stephen Shankland at CNET said the move had widespread implications.
"One is that it shows just how serious Google is about making the web into a foundation not just for static pages but for active applications, notably its own such as Google Docs and G-mail.
"Another, it opens new competition with Microsoft and, potentially, a new reason for anti-trust regulators to pay close attention to Google's moves."
Some commentators said Google's motivation in all this was pretty clear.
"One of Google's major goals is to take Microsoft out, to systematically destroy their hold on the market," said Mr Enderle.
"Google wants to eliminate Microsoft and it's a unique battle. The strategy is good. The big question is, will it work?"
At the popular blog, TechCrunch, MG Siegler said: "Let's be clear on what this really is. This is Google dropping the mother of all bombs on its rival, Microsoft."
Microsoft releases Windows 7 later this year to replace Windows Vista and Windows XP, which is eight years old.
The Redmond-based company claims that 96% of netbooks run Windows to date.
Out of beta
In a separate announcement Google also revealed that many of its most popular applications had finally moved out of trial, or beta, phase.
Gmail, for example, has worn the beta tag for five years.
"We realise this situation puzzles some people, particularly those who subscribe to the traditional definition of beta software as being not yet ready for prime time," wrote Matthew Glotzbach, the director of product management in the official Google blog.
The decision to ditch the beta tag was taken because the apps had finally reached the "high bar" mark, he wrote.
More than 1.75 million companies use Google apps, according to the firm.

Tuesday, May 17, 2011

Aggregate Functions in SQL SERVER 2008


Aggregate functions are applied to a group of data values from a column. Aggregate functions always return a single value.


AVG: Calculates the arithmetic mean (average) of the data values contained within a column. The column must contain numeric values.

MAX and MIN: Calculate the maximum and minimum data value of the column, respectively. The column can contain numeric, string, and date/time values.

SUM: Calculates the total of all data values in a column. The column must contain numeric values.

COUNT: Calculates the number of (non-null) data values in a column. The only aggregate function not being applied to columns is COUNT(*). This function

returns the number of rows (whether or not particular columns have NULL values).

COUNT_BIG: New and Analogous to COUNT, the only difference being that COUNT_BIG returns a value of the BIGINT data type.

when using aggregate function 'where' keyword could not be used,Instead of  'where' Keyword 'Having' keyword is used in sql...

Examble for using aggregate function with Having Keyword..

SELECT stdname,SUM(total) FROM stdtable
WHERE stdname='raju' OR stdname='vikas'
GROUP BY stdname
HAVING SUM(total)>500

Monday, May 16, 2011

ADD AND REMOVE ITEMS FROM THE COMBOBOX IN VB.NET


Hi...

INTRODUCTION:
In this article i am going to describe about How to add and remove items in combo box ..

i think it may helpful those who starter in vb.net..

DESCRIPTION:

First add a combobox in your form...

To add a particular column from the database to combo box..
For examble here i add the all the phone number from database to combobox...

str = "select Number from phone"
        sqlcmd = New SqlCommand(str, sqlcon)
        dr = sqlcmd.ExecuteReader()
        ComboBox1.Items.Clear()
        If dr.HasRows Then
            While dr.Read
                ComboBox1.Items.Add(dr(0).ToString)
            End While
        End If

By using this code its all the number into combo box...

Suppose if you want to remove all the items in combobox...

        ComboBox1.Items.Clear()

To remove 3rd items in the combobox

        ComboBox1.Items.RemoveAt(3)

To remove the selected items from the combo box

        ComboBox1.Items.Remove(ComboBox1.SelectedItem)
or
        ComboBox1.Text = ""

PLZ POST YOUR VALUABLE COMMENTS .............