DOTNETVISHAL: 2013

Wednesday, 25 December 2013

Oracle V/S SQL Server

Today I was thinking of the various databases which we can use as the back-end in our application. We have more than 75+ Popular RDBMS and around 170+ databases. So Now the question arises which is the best out of these??

If we look on the statistics as of December,2013. The top 5 RDBMS in this list are:

1. Oracle

2. Mysql

3. MS SQL SERVER

4. PostgreSQL

5. DB2

Refer:

http://db-engines.com/en/ranking/relational+dbms

http://db-engines.com/en/ranking

We will see the comparison between Oracle and SQL Server in terms of Performance and Scalability..

Oracle vs. Microsoft Sql Server: Performance
Sql Server is quite simple and easy to administer, and it works just fine for databases that are less than a few hundred gigabytes. Yet once the database grows beyond that, performance degradation starts to occur.
Itt is quite common, on the other hand, to run Terabyte-sized Oracle databases without performance issues. Unlike Sql Server, Oracle offers hundreds of database-level tuning options and features to improve performance. One example is a feature called Real Application Clusters (or RAC). This feature allows multiple servers to operate concurrently on the same database, thereby giving more processing power to the company's application.
In short, Oracle supports "active-active" clustering, while Sql Server doesn't. When it comes to large databases, this is just one of the many features making Oracle the clear winner in terms of performance..

Oracle vs. Microsoft Sql Server: Scalability
Sql Server only supports vertical scalability. The only way to scale a system built on sql server technology is to add more memory and CPU to the single server hosting the database. Even then, there is threshold beyond which vertical scalability doesn't provide any benefits.
Oracle, on the other hand, supports both horizontal and vertical scalability. Like Sql Server, one could scale a system built on Oracle by adding more memory and CPU to the single server hosting the database.
Yet once a threshold is hit beyond which no gain could be made by adding memory and CPU to the single server, Oracle users have the option to upgrade to Oracle Real Application Cluster technology, and have multiple small servers work as "active-active" clusters on the same database. One could add new servers to the Oracle Real Application Cluster database as necessary, providing extreme scalability.

Oracle vs. Microsoft Sql Server: Choice of OS Platform
Sql Server is limited to the Microsoft Windows operating system and will not work on any flavor of Unix operating systems. This puts Sql Server at a disadvantage because the Microsoft Windows operating system is prone to crashes while all flavors of Unix operating system are considered more stable and reliable.
Oracle, on the other hand, can work on Microsoft Windows, or any flavor of Unix operating systems, making it a true enterprise solution.
Given Oracle's capacity to run on large databases, its many performance improvement features, its vertical and horizontal scalability, and its capacity to function on both MS Windows or any flavor of Unix, it's easy to see why more companies are choosing Oracle over Sql Server.

For further Reading you can refer the links below:

http://coug.ab.ca/wp-content/uploads/2012/10/Oracle_vs._SQL_Server.pdf

http://db-engines.com/en/system/DB2%3BMicrosoft+SQL+Server%3BOracle

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

Tuesday, 6 August 2013

Count Number of Words in Paragraph/Sentence inside Textbox using ASP.Net C#

Count Number of Words in a Paragraph inside Text box using ASP.Net C#

I will now illustrate an Example to count the Number of words present inside a paragraph..

Design Part:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Count Words in String</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="txtString" runat="server" BackColor="#E0E0E0" ForeColor="Black"
            Height="100px" TextMode="MultiLine" Width="600px"></asp:TextBox><br />
        <br />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Count Words" /><br />
        <br />
        <asp:Label ID="Label1" runat="server" Font-Bold="true"  ForeColor="red"></asp:Label>
    </div>
    </form>
</body>
</html>

Code-Behind:

public partial class CountWord : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {

        }
    }

    public static int CountWordInString(string strNew)
    {
        int length = 0;
        strNew = strNew.Trim();
        char[] LineDelimiters = { ' ', '\n', '\r' };
        string[] arr = strNew.Split(LineDelimiters);
        length = arr.Length;
        return length;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string str = txtString.Text.Trim();
        Label1.Text = "The Number of Words in the above String is: "+Convert.ToString(CountWordInString(str));
    }
}

Extract All Email from a URL and Save it in a Text File using ASP.Net C#

So Today I am gonna discuss how can we extract all the email Ids present in a Particular URL using asp.net(C#)..

Create a Form Design like as given below..

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Extract Email From URL</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h1>Extract Email By URL ~~ By Vishal Ranjan</h1>
        <br />
        <br />
        <br />
        <asp:Label ID="Label1" runat="server" Font-Bold="True" Text="Enter URL:"></asp:Label>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
        <br />
        <br />
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Search" /><br />
        <br />
        <br />
        <br />
        <asp:Label ID="lblMsg" runat="server" Font-Bold="True" ForeColor="Red"></asp:Label></div>
    </form>
</body>
</html>

Then Create a Class File to Extract the Emails as follows.. Name the Class file as GetEmails.cs

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
using System.Text.RegularExpressions;

namespace FindAllEmails
{
    public class GetEmails
    {
        //public method called from your application 
        public void RetrieveEmails(string webPage)
        {
            GetAllEmails(RetrieveContent(webPage));
        }


        //get the content of the web page passed in 
        private string RetrieveContent(string webPage)
        {
            HttpWebResponse response = null;//used to get response 
            StreamReader respStream = null;//used to read response into string 
            try
            {
                //create a request object using the url passed in 
                HttpWebRequest request = (HttpWebRequest)WebRequest.Create(webPage);
                request.Timeout = 10000;

                //go get a response from the page 
                response = (HttpWebResponse)request.GetResponse();

                //create a streamreader object from the response 
                respStream = new StreamReader(response.GetResponseStream());

                //get the contents of the page as a string and return it 
                return respStream.ReadToEnd();
            }
            catch (Exception ex)//houston we have a problem! 
            {
                throw ex;
            }
            finally
            {
                //close it down, we're going home! 
                response.Close();
                respStream.Close();
            }
        }



        //using a regular expression, find all of the href or urls 
        //in the content of the page 
        private void GetAllEmails(string content)
        {
            //regular expression 
            string pattern = @"(([\w-]+\.)+[\w-]+|([a-zA-Z]{1}|[\w-]{2,}))@" + @"((([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\." + @"([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])\.([0-1]?[0-9]{1,2}|25[0-5]|2[0-4][0-9])){1}|"+ @"([a-zA-Z]+[\w-]+\.)+[a-zA-Z]{2,4})";

            //Set up regex object 
            Regex RegExpr = new Regex(pattern, RegexOptions.IgnoreCase);

            //get the first match 
            Match match = RegExpr.Match(content);

            //loop through matches 
            while (match.Success)
            {

                //output the match info to a file named matchlog.txt in D drive..
                Console.WriteLine("href match: " + match.Groups[0].Value);
                WriteToLog("D:matchlog.txt", "Email match: " + match.Groups[0].Value + Environment.NewLine);

                //get next match 
                match = match.NextMatch();
            }
        }



        //Write to a log file 
        private void WriteToLog(string file, string message)
        {
            using (StreamWriter w = File.AppendText(file))
            {
                w.WriteLine(DateTime.Now.ToString() + ": " + message); w.Close();
            }
        } 


    }
}

Finally In the Code Behind create the object of that class by referring the corresponding Namespace..

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using FindAllEmails;

public partial class ExtractEmail : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            string url = TextBox1.Text.Trim();
            GetEmails ge = new GetEmails();
            ge.RetrieveEmails(url);
            TextBox1.Text = "";
            lblMsg.Text = @"Emails Retreived and Saved to D:\matchlog.txt";
        }
        catch (Exception ex)
        {
            lblMsg.Text = "The following Error Just Occured: " + ex.Message;
        }
    }
}

Once You have done this we are all set to go.. Just Enter the URL link with http:// attached in the corresponding Textbox and click on search button.. All the Emails Present in the associated page will be copied to the file matchlog.txt in D drive.. You can change the path of file Wherever you want ..

This Program can be used to create a web service for extracting all Emails from a Page and creating a database of emails and then auto-sending that emails at scheduled interval. Just a Thought.. :-)

Friday, 19 July 2013

Open Word File Directly on Client's PC without Displaying Save Dialogue Box

So Here I am with a trick to open the Word File directly on button click event without interrupting the user with that annoying Save Options Dialogue Box. So here is how we can do this,,,

Put a Button on your design page and write the following code on the button click event of that button control..

    protected void Button1_Click(object sender, EventArgs e)
    {
        string FullFilePath =Server.MapPath("WordFile\\demo.docx");
        FileInfo file = new FileInfo(FullFilePath);
        if (file.Exists)
        {
            Response.ContentType = "application/vnd.ms-word";
            Response.AddHeader("Content-Disposition", "inline; filename=\"" + file.Name + "\"");
            Response.AddHeader("Content-Length", file.Length.ToString());
            Response.TransmitFile(file.FullName);
        }
    }

Display the Content of Word File in Browser

We do most of the our Document related activities using Microsoft Office.. Most of the time we need to export the details from these files and display it our browsers. Most of them are related to excel file like importing excel to database or importing the excel content to gridview. Today I will be showing how to display the content of Word File(*.doc) to be rendered in your browser using ASP.Net.

First of all you need to reference this Microsoft.Office.Interop.Word to your Web Application.

Then include the namespace:

using Microsoft.Office.Interop.Word;

Then on the Page_Load Event write the following code:[Here I am using a word file named demo.docx which is in the folder WordFile inside my Web Application's Root Folder.]

        Microsoft.Office.Interop.Word.Application objWordApp = new Microsoft.Office.Interop.Word.Application();

        //ACCESSING THE WORD FILE PATH

        object objWordFile = Server.MapPath("WordFile\\demo.docx");

        object objNull = System.Reflection.Missing.Value;

        Document WordDoc = objWordApp.Documents.Open(

        ref objWordFile, ref objNull, ref objNull,

        ref objNull, ref objNull, ref objNull,

        ref objNull, ref objNull, ref objNull,

        ref objNull, ref objNull, ref objNull, ref objNull, ref objNull, ref objNull, ref objNull);

        WordDoc.ActiveWindow.Selection.WholeStory();

        WordDoc.ActiveWindow.Selection.Copy();

        string strWordText = WordDoc.Content.Text;

        WordDoc.Close(ref objNull, ref objNull, ref objNull);

        objWordApp.Quit(ref objNull, ref objNull, ref objNull);

        // Asssigning word file value to bind the div

        DisplayWord.InnerHtml = strWordText;

Uploading Files Using Multiple File Uploads in the same Page

Hello Guys,Today I will be showing you how to upload multiple files using multiple File Uploads in the same Page. There are other alternatives for this as well like as AJAX FileUpload with Progressbar or Jquery Fileupload; but I am just trying to achieve the same using Multiple File Uploads in the same Page.. So Here is how can we achieve the same:

Design Part:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Multiple File Upload</title>
</head>
<body>

<form id="form1" runat="server">

<div lang="aa" style="font-family: 'Curlz MT'; font-weight: bold; text-decoration: blink; font-style: oblique; text-transform: inherit;"> 
<h1>Upload Multiple Files in Asp.net Using C# code</h1></div>

<div><asp:FileUpload ID="FileUpload1" runat="server" /> <br /> 
<asp:FileUpload ID="FileUpload2" runat="server" /> <br /> 
<asp:FileUpload ID="FileUpload3" runat="server" /> <br /> 
<asp:FileUpload ID="FileUpload4" runat="server" /> </div> 
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Upload Files" /> 
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> 

</form>
</body>
</html>

Code Behind:

    protected void Button1_Click(object sender, EventArgs e)
    {
        HttpFileCollection multipleFiles = Request.Files;
        for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++)
        {
            HttpPostedFile uploadedFile = multipleFiles[fileCount];
            string fileName = Path.GetFileName(uploadedFile.FileName);
            if (uploadedFile.ContentLength > 0)
            {
                uploadedFile.SaveAs(Server.MapPath("~/Files/") + fileName);
                Label1.Text += fileName + "Saved <BR>";
            }
        }

    }

Wednesday, 22 May 2013

Yes/No Message Box ASP.NET

You might have got into this situation of displaying a message box to confirm the occurrence of an event similar to the Yes/No message box in Windows Forms. To achieve the same functionality in asp.net that too dynamically you need few JavaScript codes and you would be able to achieve the same easily..

Design Part:

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Confirm Yes No Demo</title>
        <script type="text/javascript" language="javascript">
        function ConfirmYesNo()
        {
          if (confirm("Are you sure?")==true)
          {
            return true;
          }
          else
          {
            document.getElementById('Label1').innerHTML = '';
            alert("You have Cancelled the Operation.");
            return false;
          }
        }
        </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:Button ID="Button1" runat="server" Text="Click Me" onclick="Button1_Click" OnClientClick="return ConfirmYesNo();" />
    <br />
    <br />
        <asp:Label ID="Label1" runat="server"></asp:Label>
    </div>
    </form>
</body>
</html>

Code-Behind:

    protected void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text = "";
        Label1.Text = "Welcome to Dotnetvishal.com";
    }

Demo:

Tuesday, 30 April 2013

Website Stats November,2013 [Updated]

Website Stats November,2013[Updated]

Well If You would have asked me a few Months ago ; I was not sure whether I would keep contributing to this Website or not.. It started as a hobby and suddenly I found myself attached and indulged with this Blog.. I want to help more and more community Members and Developers out there.. That is why I keep this Blog Updated regularly..

I have introduced a new Section Named Jobs in the Menu Tab where you can find Latest Job Openings related to ASP.Net @ India..

In the coming days I would like to include Topics such as Web Services, WCF and may be Sharepoint and Azure.

For Readers:

If you like this Site Please register yourself with the free Email Subscription and RSS Feed available in the site. This site is completely Non-Commercial in Nature; that is why you will find 0 advertisement over here.. My sole motive is to reach more and more people..

Anyhow Coming to the Point Here are the stats for Dotnetvishal.com as on 30/11/2013 01:30 am

Total Number of Post:183

Total Number of Page views: 1,32,467

Country Count Based on Viewers Location: 160+

Alexa Traffic Ranking[Global]:6,68,073

Alexa Traffic Ranking[India]:71,885

And as the saying goes A Picture Speaks Thousands Words .. So Here is the Growth Story of dotnetvishal.com in the picture below..

I started a small Blog with a mere Traffic of 332 visitors in Oct'12 which turns into a Big Website with more than 700 Daily Page views and counting..

In the coming days I would like to improve the website as much as possible.. Please Provide your views and suggestions at vishalranjan2k11@gmail.com or use our Contact Us/Feedback Form.. Again Thanking You all for Your Support..

Regards,

Vishal Ranjan

Saturday, 27 April 2013

Book Review: Visual Studio 2012 and .NET 4.5 Expert Development Cookbook By Abhishek Sur

The "Visual Studio 2012 and .NET 4.5 Expert Development Cookbook" is a book that guides you through steps to ensure you enrich the best experience with the latest technology in the best amount of time possible. The book focusses to give you under the hood expertise in .NET technologies it tends to cover and adapts you the best to face common problems of these technologies. The book is divided in forms of recipes. Each of these recipes gives you clear insight of the problem and step by step process to solve the issue practically. It also addresses the advanced features associated with each of those recipes that gives you additional advantage on getting precise knowledge about the problem and its associated issues.

What you will learn from this book:

Basic usage of Visual Studio 2012 IDE and its various components and better utilization of the tool while writing code
Understand memory management techniques to build better applications
Understand the .NET infrastructure with in-depth analysis of its internals
Architect solutions that leverage the full power of .NET language gems, understanding when to use what
Implement multithreaded / asynchronous applications using recent updates on .NET 4.5 and compare the past approaches
Create secure ASP.NET web based applications in .NET 4.5 with use of JQuery and HTML5 for rapid application development
Architect advanced .NET client applications using MVVM with WPF 4.5
Understand touch sensitive devices and leverage skills to develop multi-touch applications inside Windows 8

For More Details Please Visit:

http://www.abhisheksur.com/2013/04/net-book-visual-studio-2012-and-net-45.html

You Can Buy This Book from Here:

http://www.packtpub.com/visual-studio-11-and-dotnet-4-5-expert-development-cookbook/book

Wednesday, 24 April 2013

OOPS Concept With Real Life Example

This is the most asked Question in a technical interview in any domain.. OOPs Concept is very very important.. Today I will explain OOPs concept with real Life Example that will help you to grasp the concept well and excel in the interviews...

Objects: Object is the basic unit of object-oriented programming.Objects are identified by its unique name. An objectrepresents a particular instance of a class. There can be more than one instance of an object. Each instance of an object can hold its own relevant data.

An Object is a collection of data members and associated member functions also known as methods.

Classes: Classes are data types based on which objects are created.Objects with similar properties and methods are grouped together to form a Class. Thus a Class represent a set of individual objects. Characteristics of an object are represented in a class as Properties. The actions that can be performed by objects becomes functions of the class and is referred to as Methods.

Example #1:

For example consider we have a Class of Cars under which Santro Xing, Alto and WaganR represents individual Objects.In this context each Car Object will have its own, Model,Year of Manufacture, Colour, Top Speed, Engine Power etc.,which form Properties of the Car class and the associated actions i.e., object functions like Start, Move, Stop form the Methods of Car Class.No memory is allocated when a class is created. Memory is
allocated only when an object is created, i.e., when an instance of a class is created.

Example #2:

An architect will have the blueprints for a house....those blueprints will be plans that explain exactly what properties the house will have and how they are all layed out. However it is just the blueprint, you can't live in it. Builders will look at the blueprints and use those blueprints to make a physical house. They can use the same blueprint to make as many houses as they want....each house will have the same layout and properties. Each house can accommodate it's own families...so one house might have the Smiths live in it, one house might have the Jones live in it.

The blueprint is the class...the house is the object. The people living in the house are data stored in the object's properties.

Abstraction: Abstraction means showing essential features and hiding non-essential features to the user.

For Eg. Yahoo Mail...

When you provide the user name and password and click on submit button..It will show Compose,Inbox,Outbox,Sentmails...so and so when you click on compose it will open...but user doesn't
know what are the actions performed internally....It just Opens....that is essential; User doesn't know internal actions ...that is non-essential things...

For Eg. Tv Remote..
Remote is a interface between user and tv..right. which has buttons like 0 to 10 ,on /of etc but we dont know circuits inside remote...User does not need to know..Just he is using essential thing that is remote.

Encapsulation: Encapsulation means which binds the data and code (or) writing operations and methods in single unit (class).

For Example:
A car is having multiple parts..like steering,wheels,engine...etc..which binds together to form a single object that is car. So, Here multiple parts of cars encapsulates itself together to form a single object that is Car.

In real time we are using Encapsulation for security purpose...

Encapsulation = Abstraction + Data Hiding.

Inheritance: Deriving a new class from the existing class,is called Inheritance.
Derived(sub class) class is getting all the features from Existing (super class\base class) class and also incorporating some new features to the sub class.

For Eg.,

class Address
{
String name;
Srting H.no;
String Street name;
}
class LatestAddress extends Address
{
String City;
String State;
String Country;
}
public class Vishal
{
{
LatestAddress la = new LatestAddress();
//Assign variable accordingly...
}
}

In the above Example class LatestAddress getting all features from the Address class.
In the LatestAddress class we have total 6 properties..3 are inherited from Address class and 3 properties are
incorporated. So In the class Vishal we are declaring the object of class LatestAddress and then assign new variables using the properties of the previous base classes... So this is a nice example of inheritance..

Polymorphism :

Polymorphism means ability to take more than one form that an operation can exhibit different behavior at different instance depend upon the data passed in the operation.

1>We behave differently in front of elders, and friends. A single person is behaving differently at different time.

2> A software engineer can perform different task at different instance of time depending on the task assigned to him .He can done coding , testing , analysis and designing depending on the task assign and the requirement.

3> Consider the stadium of common wealth games. Single stadium but it perform multiple task like swimming, lawn tennis etc.

4> If a girl is married and mother of 2 children doing teaching job then she is a women first ,, teacher in a school when she is in school,,wife of someone at home,, mother of her children,, and obvious daughter of someone & may be girl friend of someone (just kidding) means a woman plays diffent roles at different times dats the polymorphism (many forms).

Summary:

OOPs have following features:

1. Object             - Instance of Class
2. Class             - Blue print of Object
3. Encapsulation    - Protecting our Data
4. Polymorphism   - Different behaviors at different instances
5. Abstraction      - Hiding our irrelevant Data
6. Inheritence        - One property of object is acquiring to another property of object

Saturday, 20 April 2013

Know Details of Various Databases in SQL Server

This Query will give you Database Id,Status,Size of Your Databases/Log File in MB,Compatibility,Last Backup Date,Creation Date etc. of all the Databases present in your SQL Server Instance..

SELECT database_id,
CONVERT(VARCHAR(25), DB.name) AS dbName,
CONVERT(VARCHAR(10), DATABASEPROPERTYEX(name, 'status')) AS [Status],
state_desc,
(SELECT COUNT(1) FROM sys.master_files WHERE DB_NAME(database_id) = DB.name AND type_desc = 'rows') AS DataFiles,
(SELECT SUM((size*8)/1024) FROM sys.master_files WHERE DB_NAME(database_id) = DB.name AND type_desc = 'rows') AS [Data MB],
(SELECT COUNT(1) FROM sys.master_files WHERE DB_NAME(database_id) = DB.name AND type_desc = 'log') AS LogFiles,
(SELECT SUM((size*8)/1024) FROM sys.master_files WHERE DB_NAME(database_id) = DB.name AND type_desc = 'log') AS [Log MB],
user_access_desc AS [User access],
recovery_model_desc AS [Recovery model],
CASE compatibility_level
WHEN 60 THEN '60 (SQL Server 6.0)'
WHEN 65 THEN '65 (SQL Server 6.5)'
WHEN 70 THEN '70 (SQL Server 7.0)'
WHEN 80 THEN '80 (SQL Server 2000)'
WHEN 90 THEN '90 (SQL Server 2005)'
WHEN 100 THEN '100 (SQL Server 2008)'
END AS [compatibility level],
CONVERT(VARCHAR(20), create_date, 103) + ' ' + CONVERT(VARCHAR(20), create_date, 108) AS [Creation date],
-- last backup
ISNULL((SELECT TOP 1
CASE TYPE WHEN 'D' THEN 'Full' WHEN 'I' THEN 'Differential' WHEN 'L' THEN 'Transaction log' END + ' – ' +
LTRIM(ISNULL(STR(ABS(DATEDIFF(DAY, GETDATE(),Backup_finish_date))) + ' days ago', 'NEVER')) + ' – ' +
CONVERT(VARCHAR(20), backup_start_date, 103) + ' ' + CONVERT(VARCHAR(20), backup_start_date, 108) + ' – ' +
CONVERT(VARCHAR(20), backup_finish_date, 103) + ' ' + CONVERT(VARCHAR(20), backup_finish_date, 108) +
' (' + CAST(DATEDIFF(second, BK.backup_start_date,
BK.backup_finish_date) AS VARCHAR(4)) + ' '
+ 'seconds)'
FROM msdb..backupset BK WHERE BK.database_name = DB.name ORDER BY backup_set_id DESC),'-') AS [Last backup],
CASE WHEN is_fulltext_enabled = 1 THEN 'Fulltext enabled' ELSE '' END AS [fulltext],
CASE WHEN is_auto_close_on = 1 THEN 'autoclose' ELSE '' END AS [autoclose],
page_verify_option_desc AS [page verify option],
CASE WHEN is_read_only = 1 THEN 'read only' ELSE '' END AS [read only],
CASE WHEN is_auto_shrink_on = 1 THEN 'autoshrink' ELSE '' END AS [autoshrink],
CASE WHEN is_auto_create_stats_on = 1 THEN 'auto create statistics' ELSE '' END AS [auto create statistics],
CASE WHEN is_auto_update_stats_on = 1 THEN 'auto update statistics' ELSE '' END AS [auto update statistics],
CASE WHEN is_in_standby = 1 THEN 'standby' ELSE '' END AS [standby],
CASE WHEN is_cleanly_shutdown = 1 THEN 'cleanly shutdown' ELSE '' END AS [cleanly shutdown]
FROM sys.databases DB
ORDER BY dbName, [Last backup] DESC, NAME

Thursday, 18 April 2013

Sharpen Your Skill

Once upon a time, there was a very strong woodcutter.He asked for a job from a timber merchant, and he got it. The pay was really good and so were the work conditions. For that reason the woodcutter was determined to do his best.
His boss gave him an axe and showed him the area where he was supposed to work.
The first day, the woodcutter brought down 18 trees. The Boss was very much impressed and said, “Congratulations keep it up!”
Very motivated by the words of the boss, the woodcutter tried harder the next day, but he only could bring down 15 trees. The third day he tried even harder, but he only could bring down 10 trees. Day after day he was bringing down less and less trees.
“I must be losing my strength”, the woodcutter thought to himself.
He went to the boss and apologized, saying that he could not understand what! was going on.
“When was the last time you sharpened your Axe?” the boss asked.
“Sharpen? I had no time to sharpen my Axe. I have been very busy trying to cut trees.
The moral of the story:
Our lives are like that. We sometimes get so busy that we don’t take time to sharpen the axe. In today’s world, it seems that everyone is busier than ever, but less happy than ever. Why is that? It is so because We forget to Upgrade our skill set and spend most of our times Working Hard.

There is an Old Proverb:
There is no need of running fast when you are in the wrong path..

Most of Us are running in the wrong path and blaming our fate for our self-created Misfortune...

Mother

One young academically excellent person went to apply for a managerial position in a big company.

He passed the first interview, the director did the last interview, made the last decision.

The director discovered from the CV that the youth's academic achievements were excellent all the way, from the secondary school until the postgraduate research, never had a year when he did not score.

The director asked, "Did you obtain any scholarships in school?" the youth answered "none".

The director asked, " Was it your father who paid for your school fees?" The youth answered, "My father passed away when I was one year old, it was my mother who paid for my school fees.

The director asked, " Where did your mother work?" The youth answered, "My mother worked as clothes cleaner. The director requested the youth to show his hands. The youth showed a pair of hands that were smooth and perfect.

The director asked, " Have you ever helped your mother wash the clothes before?" The youth answered, "Never, my mother always wanted me to study and read more books. Furthermore, my mother can wash clothes faster than me.

The director said, "I have a request. When you go back today, go and clean your mother's hands, and then see me tomorrow morning.*

The youth felt that his chance of landing the job was high. When he went back, he happily requested his mother to let him clean her hands. His
mother felt strange, happy but with mixed feelings, she showed her hands to the kid.

The youth cleaned his mother's hands slowly. His tear fell as he did that. It was the first time he noticed that his mother's hands were so wrinkled, and there were so many bruises in her hands. Some bruises were so painful that his mother shivered when they were cleaned with water.

This was the first time the youth realized that it was this pair of hands that washed the clothes everyday to enable him to pay the school fee. The bruises in the mother's hands were the price that the mother had to pay for his graduation, academic excellence and his future.

After finishing the cleaning of his mother hands, the youth quietly washed all the remaining clothes for his mother.

That night, mother and son talked for a very long time.

Next morning, the youth went to the director's office.

The Director noticed the tears in the youth's eyes, asked: " Can you tell me what have you done and learned yesterday in your house?"

The youth answered, " I cleaned my mother's hand, and also finished cleaning all the remaining clothes'

The Director asked, " please tell me your feelings."

The youth said, Number 1, I know now what is appreciation. Without my mother, there would not the successful me today. Number 2, by working together and helping my mother, only I now realize how difficult and tough it is to get something done. Number 3, I have come to appreciate the importance and value of family relationship.

The director said, " This is what I am looking for to be my manager.
I want to recruit a person who can appreciate the help of others, a person who knows the sufferings of others to get things done, and a person who would not put money as his only goal in life. You are hired.

Later on, this young person worked very hard, and received the respect of his subordinates. E very employee worked diligently and as a team. The company's perform ance improved tremendously.

A child, who has been protected and habitually given whatever he wanted, would develop "entitlement mentality" and would always put himself first. He would be ignorant of his parent's efforts. When he starts work, he assumes that every person must listen to him, and when he becomes a manager, he would never know the sufferings of his employees and would always blame others. For this kind of people, who may be good academically, may be successful for a while, but eventually would not feel sense of achievement. He will grumble and be full of hatred and fight for more. If we are this kind of protective parents, are we really showing love or are we destroying the kid instead?

The Seeds and The CEO

A successful business man was growing old and knew it was time to choose a successor to take over the business. Instead of choosing one of his Directors or his children, he decided to do something different. He called all the young executives in his company together.
He said, “It is time for me to step down and choose the next CEO. I have decided to choose one of you.”
The young executives were shocked, but the boss continued. “I am going to give each one of you a seed today – one very special seed. I want you to plant the seed, water it, and come back here one year from today with what you have grown from the seed I have given you. I will then judge the plants that you bring, and the one I choose will be the next CEO.”
One man, named Jim, was there that day and he, like the others, received a seed. He went home and excitedly, told his wife the story. She helped him get a pot, soil and compost and he planted the seed. Everyday, he would water it and watch to see if it had grown. After about three weeks, some of the other executives began to talk about their seeds and the plants that were beginning to grow.
Jim kept checking his seed, but nothing ever grew. Three weeks, four weeks, five weeks went by, still nothing. By now, others were talking about their plants, but Jim didn’t have a plant and he felt like a failure.
Six months went by — still nothing in Jim’s pot. He just knew he had killed his seed. Everyone else had trees and tall plants, but he had nothing. Jim didn’t say anything to his colleagues, however…. He just kept watering and fertilizing the soil – He so wanted the seed to grow.
A year finally went by and all the young executives of the company brought their plants to the CEO for inspection. Jim told his wife that he wasn’t going to take an empty pot. But she asked him to be honest about what happened. Jim felt sick to his stomach, it was going to be the most embarrassing moment of his life, but he knew his wife was right.
He took his empty pot to the board room. When Jim arrived, he was amazed at the variety of plants grown by the other executives. They were beautiful — in all shapes and sizes.
Jim put his empty pot on the floor and many of his colleagues laughed, a few felt sorry for him!
When the CEO arrived, he surveyed the room and greeted his young executives.
Jim just tried to hide in the back. “My, what great plants, trees, and flowers you have grown,” said the CEO. “Today one of you will be appointed the next CEO!”
All of a sudden, the CEO spotted Jim at the back of the room with his empty pot. He ordered the Financial Director to bring him to the front. Jim was terrified. He thought, “The CEO knows I’m a failure! Maybe he will have me fired!”
When Jim got to the front, the CEO asked him what had happened to his seed – Jim told him the story.
The CEO asked everyone to sit down except Jim. He looked at Jim, and then announced to the young executives, “Behold your next Chief Executive Officer! His name is Jim!”
Jim couldn’t believe it. Jim couldn’t even grow his seed. “How could he be the new CEO?” the others said.
Then the CEO said, “One year ago today, I gave everyone in this room a seed. I told you to take the seed, plant it, water it, and bring it back to me today. But I gave you all boiled seeds; they were dead – it was not possible for them to grow.
All of you, except Jim, have brought me trees and plants and flowers. When you found that the seed would not grow, you substituted another seed for the one I gave you. Jim was the only one with the courage and honesty to bring me a pot with my seed in it. Therefore, he is the one who will be the new Chief Executive Officer!”
If you plant honesty, you will reap trust; if you plant goodness, you will reap friends; if you plant humility, you will reap greatness; if you plant perseverance, you will reap contentment; if you plant consideration, you will reap perspective; if you plant hard work, you will reap success; if you plant forgiveness, you will reap reconciliation; if you plant faith in God , you will reap a harvest. So, be careful what you plant now; it will determine what you will reap later.
Whatever You Give To Life, Life Gives You Back.

Wednesday, 17 April 2013

Hindi Textbox [Multilingual Infact] Using Google Transliteration in ASP.Net

Today I am going to show you how to create a textbox which will take input in any language using Google Transliteration API... This is how we can do this:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Transliterate.aspx.cs" Inherits="Transliterate" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml">
    <head id="Head1" runat="server">
    <title></title>
    <script src="https://www.google.com/jsapi" type="text/javascript">
    </script>
    <script type="text/javascript" language="javascript">
    google.load("elements", "1", {
    packages: "transliteration"
    });
     
    function onLoad() {
    var options = {
    sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH,
    destinationLanguage: [google.elements.transliteration.LanguageCode.HINDI],
    shortcutKey: 'ctrl+g',
    transliterationEnabled: true
    };
     
    var control = new google.elements.transliteration.TransliterationControl(options);
    control.makeTransliteratable(['TextBox1']);
    //TEXT1 is the id of the control which you will use for the transliteration.
    }
    google.setOnLoadCallback(onLoad);
    </script>
    </head>
    <body >
    <form id="form2" runat="server">
    <div>
    <div class="Google-transliterate-Way2blogging">
    
        <asp:TextBox ID="TextBox1" TextMode="MultiLine" Width="600" Height="200" runat="server"></asp:TextBox>
     
    </div>
    </div>
    </form>
    </body>
    </html>

Monday, 15 April 2013

Create Multiplication Table in SQL SERVER

Creating Multiplication Table in SQL SERVER

I have attended an interview 2 days ago; In that interview I got a question in which I have to create a Multiplication Table for a particular Number in PL/SQL... So Here I am with a Multiplication table of 8..
You can Modify the same for other integers..

DECLARE @i INT 
SET @i = 0;
 
-- Alternate syntax to club above two lines
DECLARE @j INT 
SET @j= 8; -- Multiplicaiton table for 8. Change this.
 
PRINT 'Multipliction table for ' 
    + CONVERT(VARCHAR, @j) + ':' + CHAR(13); -- newline
 
 
WHILE (@i < 10) -- show 1 to 10
BEGIN
 SET @i = @i + 1; -- Can be written as SET @i += 1; 
 PRINT CONVERT(VARCHAR, @i) + ' x 8 = ' + CONVERT(VARCHAR, @i*@j);
END

Monday, 25 March 2013

Get the Private/Local IP Address of Your Machine Using C#.Net

Here is how you can get the Local IP Address of your machine using ASP.NET...

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Local IP</title>
    
<script type="text/javascript">

     window.onload = function () {
        var script = document.createElement("script");
        script.type = "text/javascript";
        script.src = "http://jsonip.appspot.com/?callback=DisplayIP";
        document.getElementsByTagName("head")[0].appendChild(script);
    };
    function DisplayIP(response) {
        document.getElementById("ipaddress").innerHTML = "Your Public IP Address is " + response.ip;
    } 

</script>
    
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server"></asp:Label>
        <br />
        <br />
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
        <span id = "ipaddress"></span>
    </div>
    </form>
</body>
</html>

Code-Behind:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Net;
using System.Net.NetworkInformation;

public partial class LocalIpAddress : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (NetworkInterface ni in NetworkInterface.GetAllNetworkInterfaces())
        {
            if (ni.NetworkInterfaceType == NetworkInterfaceType.Wireless80211 || ni.NetworkInterfaceType == NetworkInterfaceType.Ethernet)
            {
                Console.WriteLine(ni.Name);
                foreach (UnicastIPAddressInformation ip in ni.GetIPProperties().UnicastAddresses)
                {
                    if (ip.Address.AddressFamily == System.Net.Sockets.AddressFamily.InterNetwork)
                    {
                       Label1.Text=ip.Address.ToString();
                    }
                }
            }
        }
    }
}

Pages

Labels

Wednesday, 25 December 2013

Oracle V/S SQL Server

Refer:

Tuesday, 6 August 2013

Count Number of Words in a Paragraph inside Text box using ASP.Net C#

Extract All Email from a URL and Save it in a Text File using ASP.Net C#

Friday, 19 July 2013

Open Word File Directly on Client's PC without Displaying Save Dialogue Box

Display the Content of Word File in Browser

Uploading Files Using Multiple File Uploads in the same Page

Wednesday, 22 May 2013

Yes/No Message Box ASP.NET

Tuesday, 30 April 2013

Website Stats November,2013[Updated]

Saturday, 27 April 2013

Book Review: Visual Studio 2012 and .NET 4.5 Expert Development Cookbook By Abhishek Sur

What you will learn from this book:

Wednesday, 24 April 2013

OOPS Concept With Real Life Example

Summary:

Saturday, 20 April 2013

Know Details of Various Databases in SQL Server

Thursday, 18 April 2013

Sharpen Your Skill

Mother

The Seeds and The CEO

Wednesday, 17 April 2013

Hindi Textbox [Multilingual Infact] Using Google Transliteration in ASP.Net

Monday, 15 April 2013

Creating Multiplication Table in SQL SERVER

Monday, 25 March 2013

Get the Private/Local IP Address of Your Machine Using C#.Net