Banner Ad

Wednesday, March 5, 2014

VisualStudio Tips & Tricks - 7 : Using Transact-SQL Editor in Visual Studio 2010

By Francis   Posted at   10:13 AM   Visual Studio Tips and Tricks No comments
                           Few months ago, when we upgrade from VSS to TFS, somehow we lost intellisense in SQLServer Management studio 2008 R2. We struggle a lot to obtain. But no luck till now. However, currently we are using Visual Studio 2010, which enriched with lot of futures.
            Instead of using SQL Server Management, what I did was open the SQL file using Visual Studio 2010. In Visual Studio, Right click on the Menu bar, from the floating menu “check” the “Transact-SQL Editor”.

image
Now we got the toolbar available in SQL to do some basic operations like connect the SQL Server, Execute the Transact SQL etc., The main benefit in this approach is the intellisense works fine with in the “Transact-SQL Editor”. So my problem solved temporary.
One of the main attraction in this feature is, we can do all basic operations with in this editor. However, I’m not at all a DBA, just a developer who used SQL server as a backend. This is more convenient way work as of now.

Hope this may help to some one!!

Tuesday, March 4, 2014

Visual Studio Tips & Tricks – 6 : Multi-Copy functionality in Visual Studio

By Francis   Posted at   12:26 PM   Visual Studio Tips and Tricks No comments

                                    Some time we may need to copy the multiple code snippets (that is we may need to copy and paste lines that are not in order) in a file and paste it in another location of the file inside Visual Studio. For example, we have 5 lines of text, what we need is to copy the 1,3 and 5 line of text and paste it on some other location. To achieve that functionality to do the following:

 

1) Copy the code snippets using Ctrl+C key combination. (That is select the line 1 and press Ctrl + C and select line 3 press Ctrl + C and so on).

2) When you paste that code press the key combination Ctrl + V + Shift key, which rotates the copied lines of text. To paste a particular selected text just press Ctrl + V.

 

Hope this helps to some one!

Tuesday, February 4, 2014

Daily Interview Question #6: What are the different types of Constructor in C#?

By Francis   Posted at   1:03 PM   C# Interview Questions No comments

Below is the list of Constructors available in C#:

1. Default Constructor

2. Parameterized constructor

3. Static Constructor.

 

By default constructor have “public” as access specifier. A class can have more than one Constructor. In C# “this” keyword is used to access the constructor from another constructor. By default, C# will provide a default constructor if no constructor declared.

 

Hope this helps!

Monday, February 3, 2014

Attach Javascript to Button

By Francis   Posted at   2:01 PM   No comments

In this tutorial I’m going to explain how to add a javascript snippet to the ASP.Net server side Button Control.

 

Code:

Copy the below code in an .aspx file:

 

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td>
                    <asp:Button runat="server" ID="btnSubmit" Text="Click Me" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>


 


Copy the below code in an .aspx.vb file:

 
 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        btnSubmit.Attributes.Add("onclick", "alert('Button Clicked');return false;")
 End Sub


Explanation:


The above code add “onclick” attribute to the Server side button “btnSubmit”. The attribute value is just a javascript snippet, which just show an alert box.


 


Take a look, after the alert we specify the “return  false;” which avoid the webform to be refreshed.


 


Hope this helps!

Tuesday, January 28, 2014

Daily Interview Question #5 : What is the difference between “Method Overloading” and “Method Overriding”?

By Francis   Posted at   1:47 PM   OOPS interview Questions No comments

Method overloading

Method overriding

method overloading used to achieve “early binding” or “static binding”. method overriding used to achieve “late (dynamic) binding” or “runtime polymorphism”.
method overloading means, in a class method can be declared with same method name and with different parameters. method overriding means, a method defined in base class can be redefined in the derived classes.
method signature (method name + parameter) must be different in method overloading. method signature must be same in method override.

 

Sample Program:

using system;
using system.collections.generic;
using system.text;

namespace consoleapplicationc
{
    //Base class
    class baseclass
    {
        private int add(int a, int b)
        {
            return a + b;
        }
        // Overload the Above Method
        private float add(float a, float b)
        {
            return a + b;
        }
        // virtual method - Indicates this will be override in Child class
        public virtual string whereiam()
        {
            return "In Base Class";
        }
    }
    // Derived Class
    class derived : baseclass
    {
        // Base class Method Override here
        public override string whereiam()
        {
            return "In Derived Class";
        }
    }
    class program
    {
        static void main(string[] args)
        {
            // Just create base class reference
            baseclass basereference;
            // Create Base class Object
            baseclass baseobj = new baseclass();
            // create object for Derived class
            derived derivedobj = new derived();
            // Base class reference contains derived object
            basereference = derivedobj;
            // Now Derived class method called with base ref
            string strvalue = basereference.whereiam();
            console.writeline(strvalue);
            // Now Base class ref contains base object
            basereference = baseobj;
            string strval = basereference.whereiam();
            console.writeline(strval);
            console.read();
        }
    }
}
Output:
in derived class
in base class
Connect with Us