sundar

call javascript Function in Page load event in ASP.Net

2010-05-06T00:12:00.000-07:00

Try adding this to your HTML after the controls are declared.

struct and a class

2010-03-11T11:08:00.000-08:00

Here are just some of the differences between a struct and a class:

* Classes are reference types and structs are value types. Since classes are reference type, a class variable can be assigned null, but we cannot assign null to a struct variable, since structs are value type.
* You will always be dealing with reference to an object ( instance ) of a class. But you will not be dealing with references to an instance of a struct, you will be dealing directly with struct
* Classes must be instantiated using the new operator, but structs can be instantiated without using the new operator.
* Classes support inheritance.But there is no inheritance for structs, (structs don't support inheritance polymorphism )
* It is not mandatory to initialize all Fields inside the constructor of a class. But all the Fields of a struct must be fully initialized inside the constructor.
* structs object is allocated in the stack, and the class object is allocated in the heap.

Class are usually for large amounts of data, whereas structs are smaller, and often used when you want to group similar data together. Use a class when object identity is more important than value. Use a struct when the value contained by an instance is more important than instance identity.

Struct variables directly contain their values, so when you pass a struct instance as a parameter, it can be more expensive than passing an instance of a reference type, due to
the copying costs.

Char Vs Varchar

2010-03-05T05:15:00.000-08:00

The char is a fixed-length[Storage Size] character data type, the varchar is a variable-length character data type.

Because char is a fixed-length data type, the storage size of the char value is equal to the maximum size for this column. Because varchar is a variable-length data type, the storage size of the varchar value is the actual length of the data entered, not the maximum size for this column.

You can use char when the data entries in a column are expected to be the same size.
You can use varchar when the data entries in a column are expected to vary considerably in size.

1. Storage wise: char columns have fixed length. If the user supplied value for the column is less than the fixed length defined in the schema, the column is padded with 0 at end to make the total length fixed. varchar doesn't have a fixed length thus no padding is needed. But as the result varchar columns have to store the size of the data together with the column
data, which takes an extra 2 bytes per varchar column.

2. Performance wise locating char is a little faster than varchar. Since char columns have fixed length, they are stored in fixed location in a row. This means locating a char column can directly jump to the fixed location in a row to read. For varchar column since the size of the data is variable, they can't be stored in fixed location in a row and rather there is some kind of lookup table in the row format to store the location of each varchar column. This means locating a varchar column has to lookup the location of the column in the lookup table stored in the row first before jumping to the location to read. Referencing the lokup table introduces some perofrmance overhead, especially ifthe lookup table reference causes cache line miss.

Caching in ASP.NET

2010-02-26T09:57:00.000-08:00

Introduction

I have no clue who first thought of it, but caching is a great idea. You just use a small amount of something fast to make something slow seem much faster then it really is! It's done by motherboards, hard drives, operating systems, and in some form or another by almost everything where speed is important. That's why it was so upsetting that classic ASP had so little support for caching. The web server would do some caching of scripts on it's own, but it was pretty rudimentary and you had very little say in it what got cached and for how long. There are some third party alternatives and some scripts to enable caching in ASP (see the related links below), but they all have their problems. ASP.NET fixes this by including some first-rate caching support built right into the platform.

The Types of Caching in ASP.NET

ASP.NET supports three types of caching:

Output Caching: Caches the output from an entire page and returns it for future requests instead of re-executing the requested page.
Fragment Caching: Caches just a part of a page which can then be reused even while other parts of the page are being dynamically generated.
Data Caching: Programmatically caches arbitrary objects for later reuse without re-incurring the overhead of creating them.

Which type of caching you decide to use obviously depends on your situation, but I'll briefly cover them all so you can make an informed decision.

Output Caching

Output caching is the simplest of the caching options offered by ASP.NET. It is useful when an entire page can be cached as a whole and is analogous to most of the caching solutions that were available under classic ASP. It takes a dynamically generated page and stores the HTML result right before it is sent to the client. Then it reuses this HTML for future requests bypassing the execution of the original code.

Telling ASP.NET to cache a page is extremely simple. You simply add the OutputCache directive to the page you wish to cache.

<%@ OutputCache Duration="30" VaryByParam="none" %>

The resulting caching is similar to the caching done by browsers and proxy servers, but does have one extremely important difference... you can tell a page which parameters to the page will have an effect on the output and the caching engine will cache separate versions based on the parameters you specify. This is done using the VaryByParam attribute of the OutputCache directive. The code listing below illustrates a very simple example of output caching.

<%@ Page Language="VB" %>

<%@ OutputCache Duration="30" VaryByParam="test" %>

This page was generated at: <%= Now() %>

This piece of code will cache the result for 30 seconds. During that time, responses for all requests for the page will be served from the cache. It also specifies that the caching should vary by the parameter "test". As such, the page will cache a different version for each value of "test" that it is passed and will return the appropriate version based on the value of "test" in the incoming requests.

Fragment Caching

Sometimes it's not possible to cache an entire page. For example, many shopping sites like to greet their users by name. It wouldn't look very good if you went to a site and instead of using your name to greet you it used mine! In the past this often meant that caching wasn't a viable option for these pages. ASP.NET handles this by what they call fragment caching.

Honestly, I find this a little misleading... while you can technically cache part of a page, in order to do so you need to make the section to be cached into a user control and set the OutputCache directive in the new user control. Then you use this control from your dynamic page. The solution works well, but in my mind I think of it as caching a separate mini-page and not really a fragment of a page. I guess it's just semantics, but it is a separate file so it can be a little bit of work to implement.

The caching part is very similar to the code above. Aside from making the section a user control and then using the user control (which we covered in our User Controls lesson) it's pretty boring. There's a sample in the zip file, but I'm not including the code here.

Data Caching

This is the most powerful of the caching options available in ASP.NET. Using data caching you can programmatically cache anything you want for as long as you want. The caching system exposes itself in a dictionary type format meaning items are stored in name/value pairs. You cache an item under a certain name and then when you request that name you get the item back. It's similar to an array or even a simple variable.

In addition to just placing an object into the cache you can set all sorts of properties. The object can be set to expire at a fixed time and date, after a period of inactivity, or when a file or other object in the cache is changed.

The main thing to watch out for with data caching is that items you place in the cache are not guaranteed to be there when you want them back. While it does add some work (you always have to check your object exists after you retrieve it), this scavenging really is a good thing. It gives the caching engine the flexibility to dispose of things that aren't being used or dump parts of the cache if the system starts running out of memory.

<%@ Page Language="VB" %>

This page was generated at:

SQL injection

2010-02-19T01:53:00.000-08:00

Constrain input.
We should validate all input to your ASP.NET applications for type, length, format, and range. By constraining the input used in your data access queries; you can protect your application from SQL injection.

Constrain Input in ASP.NET Web Pages

Constrain Input in Data Access Code

Use parameters with stored procedures.
Using stored procedures does not necessarily prevent SQL injection. The important thing to do is use parameters with stored procedures. If you do not use parameters.

Use parameters with dynamic SQL.
If you cannot use stored procedures, you should still use parameters when constructing dynamic SQL statements. The following code shows how to use SqlParametersCollection with dynamic SQL..

AutoEventWireup attribute in ASP.NET

2010-02-04T22:00:00.000-08:00

AutoEventWireup attribute in ASP.NET

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

The ASP.NET page framework supports an automatic way to associate page events and methods. If the AutoEventWireup attribute of the Page directive is set to true, the page framework calls page events automatically, specifically the Page_Init and Page_Load methods. In that case, no explicit Handles clause or delegate is needed.

AutoEventWireup is an attribute in Page directive.

AutoEventWireup is a Boolean attribute that indicates whether the ASP.NET pages events are auto-wired.

AutoEventWireup will have a value true or false. By default it is true.

There is no event or method associated with Page_Load. Those events whose inline event is not there but that should be executed, for that purposed AutoEventWireup="true".

Disadvantages of AutoEventWireup attribute

AutoEventWireup uses fixed naming convention for the events. Page events handlers have specific predictable names. This limits your flexibility in how you name event handlers.

If you do set AutoEventWireup to true, Visual Studio will generate code to bind the events and the page framework will automatically call events based on their names. This can result in the same event code being called twice when the page runs. As a consequence, you should always leave AutoEventWireup set to false when working in Visual Studio.

Another disadvantage is that performance is adversely affected, because ASP.NET searches for methods at run-time. For a Web site with high traffic volumes, the impact on performance could be significant.

AutoEventWireup="true" target is for page events only. In case of AutoEventWireup method are not case sensitive. (Page_Load or page_load both will work).

If AutoEventWireup="false" but still you want to executed Page event (Page_Load). In this you have to explicitly code for it.

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

Conclusion

I hope that this article would have helped you in understanding AutoEventWireup attribute in ASP.NET. Please share it if you know more about this attribute. Your feedback and constructive contributions are welcome.

Difference between user defined function and stored procedure

2010-02-02T22:53:00.000-08:00

Advantages of User Defined Functions

Before SQL 2000, User Defined Functions (UDFs), were not available. Stored Procedures were often used in their place. When advantages or disadvantages of User Defined Functions are discussed, the comparison is usually to Stored Procedures.

One of the advantages of User Defined Functions over Stored Procedures, is the fact that a UDF can be used in a Select, Where, or Case statement. They also can be used to create joins. In addition, User Defined Functions are simpler to invoke than Stored Procedures from inside another SQL statement.

Disadvantages of User Defined Functions

User Defined Functions cannot be used to modify base table information. The DML statements INSERT, UPDATE, and DELETE cannot be used on base tables. Another disadvantage is that SQL functions that return non-deterministic values are not allowed to be called from inside User Defined Functions. GETDATE is an example of a non-deterministic function. Every time the function is called, a different value is returned. Therefore, GETDATE cannot be called from inside a UDF you create.

Types of User Defined Functions

There are three different types of User Defined Functions. Each type refers to the data being returned by the function. Scalar functions return a single value. In Line Table functions return a single table variable that was created by a select statement. The final UDF is a Multi-statement Table Function. This function returns a table variable whose structure was created by hand, similar to a Create Table statement. It is useful when complex data manipulation inside the function is required.

Scalar UDFs

Our first User Defined Function will accept a date time, and return only the date portion. Scalar functions return a value. From inside Query Analyzer, enter:

CREATE FUNCTION dbo.DateOnly(@InDateTime datetime)

RETURNS varchar(10)

AS

BEGIN

        DECLARE @MyOutput varchar(10)

        SET @MyOutput = CONVERT(varchar(10),@InDateTime,101)

        RETURN @MyOutput

END

To call our function, execute: SELECT dbo.DateOnly(GETDATE())

Notice the User Defined Function must be prefaced with the owner name, DBO in this case. In addition, GETDATE can be used as the input parameter, but could not be used inside the function itself. Other built in SQL functions that cannot be used inside a User Defined Function include: RAND, NEWID, @@CONNCECTIONS, @@TIMETICKS, and @@PACK_SENT. Any built in function that is non-deterministic.

The statement begins by supplying a function name and input parameter list. In this case, a date time value will be passed in. The next line defines the type of data the UDF will return. Between the BEGIN and END block is the statement code. Declaring the output variable was for clarity only. This function should be shortened to:

CREATE FUNCTION testDateOnly(@InDateTime datetime)

RETURNS varchar(10)

AS

BEGIN

        RETURN CONVERT(varchar(10),@InDateTime,101)

END

Inline Table UDFs

These User Defined Functions return a table variable that was created by a single select statement. Almost like a simply constructed non-updatable view, but having the benefit of accepting input parameters.

This next function looks all the employees in the pubs database that start with a letter that is passed in as a parameter. In Query Analyzer, enter and run:

USE pubs

GO

CREATE FUNCTION dbo.LookByFName(@FirstLetter char(1))

RETURNS TABLE

AS

RETURN SELECT *

FROM employee

WHERE LEFT(fname, 1) =  @FirstLetter

To use the new function, enter:

SELECT * FROM dbo.LookByFName('A')

All the rows having a first name starting with A were returned. The return is a Table Variable, not to be confused with a temporary table. Table variables are new in SQL 2000. They are a special data type whose scope is limited to the process that declared it. Table variables are stated to have performance benefits over temporary tables. None of my personal testing has found this result though.

Multi Statement UDFs

Multi Statement User Defined Functions are very similar to Stored Procedures. They both allow complex logic to take place inside the function. There are a number of restrictions unique to functions though. The Multi Statement UDF will always return a table variable–and only one table variable. There is no way to return multiple result sets. In addition, a User Defined Function cannot call a Stored Procedure from inside itself. They also cannot execute dynamic SQL. Remember also, that UDFs cannot use non-deterministic built in functions. So GETDATE and RAND cannot be used. Error handling is restricted. RAISERROR and @@ERROR are invalid from inside User Defined Functions. Like other programming languages, the purpose of a User Defined Function is to create a stand-alone code module to be reused over and over by the global application.

For a Multi Statement test, we will create a modified version of the LookByFName function. This new function will accept the same input parameter. But rather than return a table from a simple select, a specific table will be created, and data in it will be manipulated prior to the return:

CREATE FUNCTION dbo.multi_test(@FirstLetter char(1))

RETURNS @Result TABLE

        fname varchar(20),

        hire_date datetime,

        on_probation char(1)

AS

BEGIN

        INSERT INTO @Result

               (fname, hire_date)

               SELECT fname, hire_date

               FROM employee

               WHERE LEFT(fname, 1) =  @FirstLetter

        UPDATE @Result

        SET on_probation = 'N'

        UPDATE @Result

        SET on_probation = 'Y'

        WHERE hire_date < '01/01/1991'

        RETURN

END

To use the new function, execute:

SELECT * FROM dbo.multi_test('A')

With the new Multi Statement Function, we can manipulate data like a Stored Procedure, but use it in statement areas like a View.

For example, only specific columns can be returned.

SELECT fname FROM dbo.multi_test('A')

The function can also be joined like a view:

SELECT e.lname, f.fname

FROM employee e INNER JOIN dbo.multi_test('A') f ON e.fname = f.fname

Conclusion

User Defined Functions offer an excellent way to work with code snippets. The main requirement is that the function be self-contained. Not being able to use non-deterministic built in functions is a problem, but if it can be worked around, UDFs will provide you with a programming plus.

Example for Interface and Abstract class

2009-12-18T12:06:00.000-08:00

Example for Interface :
Code:
public interface IVehicle
{
void Start();
void Drive();
void Park();
void ChangeGear(int gear);
void SwitchOff();
}
public class Vehicle : IVehicle
{
public void Start()
{
Console.WriteLine("The vehicle has been started");
}

public void Drive()
{
Console.WriteLine("The vehicle is being driven");
}

public void Park()
{
Console.WriteLine("The vehicle is being parked");
}

public void ChangeGear(int gear)
{
Console.WriteLine("Gear changed to " + gear.ToString());
}

public void SwitchOff()
{
Console.WriteLine("The vehicle has been switched off");
}
}

Example for Abstract class :
Code:
public abstract class Vehicle
{
public void Start()
{
Console.WriteLine("The vehicle has been started");
}

public abstract void Drive();
public abstract void Park();
public abstract void ChangeGear(int gear);

public void SwitchOff()
{
Console.WriteLine("The vehicle has been switched off");
}
}

public class Car : Vehicle
{
public Car()
{
}

public override void Drive()
{
Console.WriteLine("The car is being driven");
}

public override void Park()
{
Console.WriteLine("The car is being parked");
}

public override void ChangeGear(int gear)
{
Console.WriteLine("The car changed gear changed to " + gear.ToString());
}
}

Left Outer join with Having in SQL Server

2009-12-13T22:53:00.000-08:00

select p.[ProductName],count(po.ProductID)
from Products as p Left Outer join
Productorder po on p.ProductID=po.productID
GROUP By p.[ProductName],po.ProductID
HAVING (count(po.ProductID) > 0)

Personal Interview Questions

2009-12-08T09:27:00.000-08:00

"Tell me a little about yourself."

When responding to this request, you should focus on both your personal and professional values. Always be honest, but talk about your best traits only, especially those that relate to the position for which you are applying. Highlight experiences and accomplishments you are most proud of. Here's an example:

"I'm an experienced communications specialist with extensive knowledge of public information tools and techniques. I've developed comprehensive communication plans for major public events, written dozens of articles accepted by worldwide publications, and created specialized educational programs for adults and students. I am always eager to learn new methods and procedures, and have implemented continuous improvement techniques in my past positions that saved money and increased productivity. I like working with people and enjoy group projects, but am also a self-starter who doesn't mind working on my own. I'm a volunteer with the local chapter of Special Olympics and enjoy participating in community events. My goals are to complete my Master's Degree and broaden my experiences with community relations."

Remember to tailor your response to the specific job. By studying the job announcement, you'll get a good idea of the skills and experience being sought. Work those into your response.

Consider this your own personal commercial. If the interview consisted of only this ONE chance to sell yourself, what would you say?

"What do you feel has been your greatest work-related accomplishment?"

Choose one example from your past that was important to you and helped the company you worked for. Give specific details about what you did, how you did it, and what the results were. Try to pick an accomplishment that relates to the position for which you are applying. Employers like to hear about accomplishments that reduced expenses, raised revenues, solved problems or enhanced a company's reputation

"What is your greatest strength?"

This is a great chance to highlight your best skills. Don't pick just one, focus on your top three or four. Some examples are: leadership skills, team-building skills, and organizational skills. Determine which strengths would fit best with the position for which you are applying. For example, if the job announcement stresses the ability to handle multiple tasks, you could say: "I'm good at organizational skills, prioritization and time management. But my greatest strength is my ability to effectively handle multiple projects and deadlines.

"What is your greatest weakness?"

Be careful with this one. Most interview guides will tell you to answer it with a positive trait disguised as a weakness. For example, "I tend to expect others to work as hard as I do," or "I'm a bit of a perfectionist." Interviewers have heard these "canned" answers over and over again. To stand out, be more original and state a true weakness, but then emphasize what you've done to overcome it. For example: "I've had trouble delegating duties to others because I felt I could do things better myself. This has sometimes backfired because I'd end up with more than I could handle and the quality of my work would suffer. But I've taken courses in time management and learned effective delegation techniques, and I feel I've overcome this weakness."

IMPORTANT: Be sure the weakness you talk about is NOT a key element of the position!

"How do you handle stressful situations?"

Give some examples of stressful situations you've dealt with in the past. Tell how you use time management, problem-solving or decision-making skills to reduce stress. For example, tell them that making a "to-do" list helps. Site stress-reducing techniques such as stretching and taking a break. Don't be afaid to admit that you will ask for assistance if you are feeling overwhelmed.

If it's true, say you actually work better under pressure.

"What is the toughest problem you've had to face, and how did you overcome it?"

Try to make this about a problem that faced your company and not just you or your particular work group. The bigger the problem, the better. Give specific examples of the skills and techniques you used to resolve this problem. Emphasize the successful results. Be generous in sharing credit if it was a team effort, but be sure to highlight your specific role.

"Have you ever had to discipline a problem employee? If so, how did you handle it?"

This is a likely question if the position for which you are applying requires supervisory duties. Explain how you used problem-solving skills, listening skills, and coaching skills to help the employee. If those techniques turned the employee around, be sure to say so. If those techniques failed, tell how you followed the company's policies and what the end result was.

"Why do you want this position?"

Here's where your research about the company will help you stand out among the other candidates. Explain how you've always wanted the opportunity to work with a company that... provides a vital public service, leads the industry in innovative products, whatever... find something specific about that company that you can tie in with your answer. Explain how your qualifications and goals complement the company's mission, vision and values (use specific examples). If you are applying for a position in a company for which you already work, explain how you'll be able to apply and expand on the knowledge and experience you've gained from your current position, and will be able to increase your contributions and value to the company through your new responsibilities.

"Why are you the best person for this job?"

As with all other questions, be confident and enthusiastic when you answer this. Don't try to say you are the best qualified person, because you don't know the qualifications of the other applicants. Instead, emphasize several reasons why you should be hired. For example: "I've got extensive experience in [name the appropriate field] and have the specific skills you are looking for. I'm a fast learner who adapts quickly to change and will hit the ground running. I'm dedicated and enthusiastic about helping your company meet its goals, and will provide top-quality results with minimal oversite. I'm an outstanding performer who takes pride in my work. You won't have any regrets when you hire me."

QUESTIONS YOU SHOULD ASK

Often the interviewer's last question is, "Do you have any questions for me?" Candidates who do not have questions show a lack of initiative and give the impression that they have minimal interest in the position. Stand out from those lazy job seekers by asking questions!

Have your questions ready in advance. Relate them to the company or its accomplishments/challenges (your research of the company will show and further impress the interviewer). Don't ask any question that shows that you have not done your research about the company.

Do not ask questions related to you, such as "When will I be eligible for my first raise?" or "How often will I be subjected to a performance review?" Don't bring up money. (You can do that after you are offered the job.)

In addition to specific questions you develop based on what the company does, here are some sample generic questions:

What do you enjoy most about working here?

Be sure the person you ask actually works for the company. Some organizations, especially public agencies, have interview panels in which employees from other agencies participate.

Is there anything I've mentioned that makes you think I'm not the best candidate for this job?

If they do mention something that's bothering them about you, such as lack of specific experience, this gives you a last-ditch effort to change their opinion about you. If you've thought about your possible weaknesses in advance, you should have a prepared answer to those weaknesses. For example, "I know I have limited experience in this field, but what I lack in specific experience I make up for in enthusiasm and desire to excel. I'm a fast learner and I'll work harder than anyone else to be a top producer on your team."

When do you expect to make your final decision?

Be sure to ask that! Failure to do so may give the impression that you're not that interested, and you need to know when to follow up.

ALL THE BEST dONT Worry Be-HaPPY

Readonly vs const

2009-12-07T12:27:00.000-08:00

Within a class, const, static and readonly members are special in comparison to the other modifiers.

`const` vs. `readonly`

const and readonly perform a similar function on data members, but they have a few important differences.

`const`

A constant member is defined at compile time and cannot be changed at runtime. Constants are declared as a field, using the const keyword and must be initialized as they are declared. For example;

public class MyClass

  public const double PI = 3.14159;

PI cannot be changed in the application anywhere else in the code as this will cause a compiler error.

Constants must be of an integral type (sbyte, byte, short, ushort, int, uint, long, ulong, char, float, double, decimal, bool, or string), an enumeration, or a reference to null.

Since classes or structures are initialized at run time with the new keyword, and not at compile time, you can't set a constant to a class or structure.

Constants can be marked as public, private, protected, internal, or protected internal.

Constants are accessed as if they were static fields, although they cannot use the static keyword.

To use a constant outside of the class that it is declared in, you must fully qualify it using the class name.

`readonly`

A read only member is like a constant in that it represents an unchanging value. The difference is that a readonly member can be initialized at runtime, in a constructor as well being able to be initialized as they are declared. For example:

public class MyClass

  public readonly double PI = 3.14159;

public class MyClass

  public readonly double PI;

  public MyClass()

    PI = 3.14159;

Because a readonly field can be initialized either at the declaration or in a constructor, readonly fields can have different values depending on the constructor used. A readonly field can also be used for runtime constants as in the following example:

public static readonly uint l1 = (uint)DateTime.Now.Ticks;

Notes

readonly members are not implicitly static, and therefore the static keyword can be applied to a readonly field explicitly if required.

A readonly member can hold a complex object by using the new keyword at initialization.

readonly members cannot hold enumerations.

`static`

Use of the static modifier to declare a static member, means that the member is no longer tied to a specific object. This means that the member can be accessed without creating an instance of the class. Only one copy of static fields and events exists, and static methods and properties can only access static fields and static events. For example:

public class Car

  public static int NumberOfWheels = 4;

The static modifier can be used with classes, fields, methods, properties, operators, events and constructors, but cannot be used with indexers, destructors, or types other than classes.

static members are initialized before the static member is accessed for the first time, and before the static constructor, if any is called. To access a static class member, use the name of the class instead of a variable name to specify the location of the member. For example:

int i = Car.NumberOfWheels;

General Interview Question

2009-12-03T09:56:00.000-08:00

Project interview questions

1. Project skills interview questions

• Tell us about a successful project in which you participated and how you contributed to the success of that project.

• You are given the assignment of project manager and the team members have already been identified. To increase the effectiveness of your project team, what steps will you take?

• Do you understand milestones, interdependencies? Resource allocation?

• Do you know what Project Software the new company uses and is there training for it?

• What is EVM? how will you use it in managing projects?

• What is a project? and what is program?

• What are project selection methods?

• When you are assigned a project, what steps do you take to complete the project?

• As you begin your assignment as a project manager, you quickly realize that the corporate sponsor for the project no longer supports the project. What will you do?

• Your three month project is about to exceed the projected budget after the first month. What steps will you take to address the potential cost overrun?

• Companies have historically looked at technical skills, but more and more business managers are realizing that not have “people” skills tend to cripple projects.

• How many projects you handled in the past? Deadlines met? On time/ within budget? Obstacles you had to overcome?

• Which document will you refer for future decisions?

• How will you define scope?

• Do you inspect or plan for quality ?

• What is the output of scope definition process?

• What is quality management?

• What did you like about the project and dislike about the project?

• What did you learn from the project?

• What are two common but major obstacles for a project like this? What would you do in the face of these obstacles to keep your team on schedule?

• What is project charter? What are the elements in a project charter?

• What experience have you had in project management?

• Name five signs that indicate your project may fail.

• Tell us about a project in which you participated and your role in that project.

• Describe what you did in a difficult project environment to get the job done on time and on budget.

• What actions are required for successful executive sponsorship of a project?

• How did you get your last project?

• What were your specific responsibilities?

• In this field (the field you are interviewing for), what are three critically important things you must do well as a project manager in order for the project to succeed?

• What metrics would you expect to use to determine the on-going success of your project?

• What distinguishes a project from routine operations?

• What are the three constraints on a project?

• What are the five control components of a project?

• What qualifications are required to be an effective project manager?

• Your project is beginning to exceed budget and to fall behind schedule due to almost daily user change orders and increasing conflicts in user requirements. How will you address the user issues?

• You’ve encountered a delay on an early phase of your project. What actions can you take to counter the delay? Which actions will have the most effect on the result?

• What are the necessary steps to successful project management?

• How do you plan for a project?

• What is important to consider when planning a (your type of project)?

• What are things that you have found to be low priority when planning for (your type of project)?
• You have been assigned as the project manager for a team comprised of new employees just out of college and “entry-level” consulting staff. What steps can you take to insure that the project is completed against a very tight time deadline?

• What is a “project milestone”?

• What is “project float”?

• What methods have you used for estimation?

• How would you start a project?

• If you were to deliver a project to a customer, and timely delivery depended upon a sub-supplier, how would you manage the supplier? What contractual agreements would you put in place?

• Which tool would you use to define, manage and control projects?

• What is risk management and how will you plan risk response?

• What are outputs of project closure?

• What are the methods used for project estimation?

2. Leadership interview questions

• Tell me how you would react to a situation where there was more than one way to accomplish the same task, and there were very strong feelings by others on each position.

• Consider that you are in a diverse environment, out of your comfort zone. How would you rate your situational leadership style?

• Give me an example of your leadership involvement where teamwork played an important role.

• How do you handle non-productive team members?

• How do you motivate team members who are burned out, or bored?

• How do you handle team members who come to you with their personal problems?

• What are your career goals? How do you see this job affecting your goals?

• Explain how you operate interdepartmentally.

3. Judgment interview questions

• What would you do if you found out that a contractor was in a conflict of interest situation?

• If I were to contact your former employee, what would he say about your decision-making abilities?

• Give me an example of a win-win situation you have negotiated.
• Tell me about your verbal and written communication ability. How well do you represent yourself to others? What makes you think so?

• Give me an example of a stressful situation you have been in. How well did you handle it? If you had to do it over again, would you do it differently? How do you deal with stress, pressure, and unreasonable demands?

• Tell me about a tough decision you had to make?

4. Experience interview questions

• Describe what you did at your work place yesterday.

• How would you solve the following technical problem? (Describe a typical scenario that could occur in the new position.)

• What strengths did you bring to your last position?

• Describe how those contributions impacted results?

5. Competency interview questions

• Tell me about special projects or training you have had that would be relevant to this job.

• What are some things that you would not like your job to include?

• What are your current work plans? Why are you thinking about leaving your present job?

• Describe an ideal job for you.

• Why are you interested in this position?

• Describe what you think it would be like to do this job every day.

• What do you believe qualifies you for this position?

Project interview questions can be used for project management interview questions, project manager interview questions

Five Tips To Remove Stomach Fat You Can Use Today

2009-12-01T10:07:00.000-08:00

5 Tips To Remove Stomach Fat You Can Use Today

Getting rid of belly fat isn't something that you can do overnight, but there are methods that you can put in place today that will greatly reduce the appearance of your stomach fat and get you started on the road to a healthy body. The trick is patience. Getting in shape takes time and it is important to tone your whole body. If you just focus on your stomach, your stomach fat will simply reappear somewhere else on your body. That said, here are 5 tips to remove stomach fat you can use today:

1. Start an abdominal workout routine immediately. It is important to exercise your whole body but there is no rule that says you can't focus on one part of your body more than others. Instead of simply lounging in the evening, do crunches or squats while you watch television or listen to music. You don't have to do hundreds of them either to see results.

2. Talk with your doctor about drastically cutting your calorie intake for a few days. By cutting your calorie intake your body will start to burn its fat stores in an attempt to keep your body functioning at its usual energy level. It is imperative, however, that you start to increase your calorie intake over time. Remember, the goal is to be healthy!

3. Cut all of the processed foods out of your diet. Instead of choosing snacks from the snack aisle, stock up on fresh fruits and vegetables to snack on when you are between meals. At mealtimes opt for as many raw foods as you can as raw foods are far healthier than cooked foods.

4. Start sitting up straight. Proper posture, especially when you aren't used to it, can reduce the appearance of stomach fat (slouching can double the amount of flab that falls over your waistline). What's more, it takes energy to hold yourself upright all day long--energy that burns calories! It's a low burning energy, but it burns calories nonetheless!

5. Drink enough water! Instead of quenching your thirst with juice, soda, coffee or teas--opt for water. Water is essential to keeping your body healthy and your organs functioning properly. Water will help you sweat out your toxins instead of storing them as fat. What's more, water has zero calories so by cutting out the other beverages and replacing them with water, you'll be cutting your calorie intake by hundreds of calories a day!

These are just five tips that you can use to remove stomach fat today. By doing some research and talking to your doctor you will easily be able to come up with even more ways to get your body in shape, be healthy and reduce your "flab." Make sure you run any decisions about your body by your primary care physician. Together the two of you can put together a complete plan to keep the body fat at bay.

SQL Server, Drop All Tables in Database Quickly

2009-10-29T13:34:00.000-07:00

SELECT name INTO #tables from sys.objects where type = 'U'

while (SELECT count(1) FROM #tables)> 0

begin

declare @sql varchar(max)

declare @tbl varchar(255)

SELECT top 1 @tbl = name FROM #tables

SET @sql = ‘drop table [' + @tbl + ']‘

exec(@sql)

DELETE FROM #tables where name = @tbl

end

DROP TABLE #tables;

Page Life Cycle Events

2009-09-30T10:53:00.000-07:00

Mainly four type of life cycle in c#
1)page load
2)page init
3)page pre render
4)page unload

Page_Init
The server controls are loaded and initialized from the Web form's view state. This is the first step in a Web form's life cycle.
Page_Load
The server controls are loaded in the page object. View state information is available at this point, so this is where you put code to change control settings or display text on the page.
Page_PreRender
The application is about to render the page object.
Page_Unload
The page is unloaded from memory.
Page_Disposed
The page object is released from memory. This is the last event in the life of a page object.
Page_Error
An unhandled exception occurs.
Page_AbortTransaction
A transaction is aborted.
Page_CommitTransaction
A transaction is accepted.
Page_DataBinding
A server control on the page binds to a data source.
Process Request Method finally renders HTML Page

LINQ

2009-09-30T10:13:00.000-07:00

Disadvantages of LINQ over Stored Procedures

Network traffic: SP's need only serialize SP-name and argument data over the wire while LINQ sends the entire query. This can get really bad if the queries are very complex. However, LINQ's abstraction allows Microsoft to improve this over time.

Less flexible: SP's can take full advantage of a database's featureset. LINQ tends to be more generic in it's support. This is common in any kind of language abstraction (e.g. C# vs assembler).

Recompiling:If you need to make changes to the way you do data access, you need to recompile, version, and redeploy your assembly. SP's can sometimes allow a DBA to tune the data access routine without a need to redeploy anything.

Advantages of LINQ over Stored Procedures

Type safety:

Abstraction: This is especially true with LINQ-to-Entities. This abstraction also allows the framework to add additional improvements that you can easily take advantage of. PLINQ is an example of adding multi-threading support to LINQ. Code changes are minimal to add this support. It would be MUCH harder to do this data access code that simply calls sprocs.

Debugging support: I can use any .NET debugger to debug the queries. With SP's, you cannot easily debug the SQL and that experience is largely tied to your database vendor (MS SQL Server provides a query analyzer, but often that isn't enough).

Vendor agnostic: LINQ works with lots of databases and the number of supported databases will only increase. SP's are not always portable between databases, either because of varying syntax or feature support (if the database supports SP's at all).

Deployment: Others have mentioned this already, but it's easier to deploy a single assembly than to deploy a set of SP's. This also ties in with #4.

Easier: You don't have to learn T-SQL to do data access, nor do you have to learn the data access API (e.g. ADO.NET) necessary for calling the SP's. This is related to #3 and #4.

Difference between ADO.net Dataset and ADO Recordset

2009-09-29T06:08:00.000-07:00

Dataset:

1.With dataset you can retreive data from two different databases and merge them into one dataset.

2.All representations is done in xml.

3.Dataset can be transmitted on HTTP.

Recordset:

1.With recordset you cannot retreive data from two different databases and merge them into one recordset.

2.All representations is done using COM.

3.Recordset cannot be transmitted on HTTP

The out and ref Paramerter in C#

2009-09-21T03:28:00.000-07:00

The out and the ref parameters are used to return values in the same variables, that you pass an an argument of a method. These both parameters are very useful when your method needs to return more than one values.

In this article, I will explain how do you use these parameters in your C# applications.

The out Parameter

The out parameter can be used to return the values in the same variable passed as a parameter of the method. Any changes made to the parameter will be reflected in the variable.

public class mathClass
{
public static int TestOut(out int iVal1, out int iVal2)
{
iVal1 = 10;
iVal2 = 20;
return 0;
}
public static void Main()
{
int i, j; // variable need not be initialized
Console.WriteLine(TestOut(out i, out j));
Console.WriteLine(i);
Console.WriteLine(j);
}
}

The ref parameter

The ref keyword on a method parameter causes a method to refer to the same variable that was passed as an input parameter for the same method. If you do any changes to the variable, they will be reflected in the variable.

You can even use ref for more than one method parameters.

namespace TestRefP
{
using System;
public class myClass
{
public static void RefTest(ref int iVal1 )
{
iVal1 += 2;
}
public static void Main()
{
int i; // variable need to be initialized
i = 3;
RefTest(ref i );
Console.WriteLine(i);
}
}
}

Joins In Sql Server

2009-09-20T23:56:00.000-07:00

Table

Query
Inner Join

select * from car as a inner join
Dept as b On a.CarId=b.id

Outer Join -Full

select * from Emp as a full outer join
Dept as b On a.Id=b.id

Left
select * from Emp as a left outer join
Dept as b On a.Id=b.id

Right
select * from Emp as a right outer join
Dept as b On a.Id=b.id

Result

Interview question

2009-09-09T23:22:00.000-07:00

How to Insert Values into an Identity Column in SQL Server?
SET IDENTITY_INSERT IdentityTable ON

INSERT IdentityTable(TheIdentity, TheValue)
VALUES (3, 'First Row')

SET IDENTITY_INSERT IdentityTable OFF

How to clone table structure to another table?

1. select top 1 into [NewTable] from [ExistingTable] where ....
or
2. select top 0 into [NewTable] from [ExistingTable]
insert [NewTable] select * from [ExistingTable] where ...

What is Webparts?

Write a syntax for the Uesr Defined Function And Stored Procedure[Delete the data from some Table.]?

What is WebGarden & WebForm?

How to Maintain the CheckBox State in the GridView Paging?

What is Static Constructor?

Interface Vs Abstract ?

Sealed Class?

Serialized Class?

State Management?

Syntax for RAISERROR in Sql Server.?

how to Debug Client (java) Script in visual studio 2005?

2009-07-09T06:02:00.000-07:00

Go to IE Internet option and select the Advance Tab option and uncheck the Disable script Debugging(Internet Explore) (REF above image).
and Run your Application, then click the ALT+CTRL+N u got the New Window that name is called Script Explore you will get the file , you click the file it will open, u can use click the f9 function Key.then run your application .

caling javascript from codebehind file while using Ajax .

2009-04-09T03:46:00.000-07:00

CloseWindow = "alert('sundar')";//we have to call javascript function also.
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "CloseWindow", CloseWindow,true);

following code should be work in the page load time only

Page.RegisterClientScriptBlock("sundar", "")
Page.RegisterStartupScript("sundar", "");

Javascript Char Codes (Key Codes)

2009-04-03T06:30:00.000-07:00

Javascript Char Codes (Key Codes)

Summary

Javascript is often used on the browser client side to perform simple tasks that would otherwise require a full postback to the server. Many of those simple tasks involve processing text or characters entered into a form element on a web page, and it is often necessary to know the javascript keycode associated with a character. Here is a reference.

Key Pressed	Javascript Key Code
backspace	8
tab	9
enter	13
shift	16
ctrl	17
alt	18
pause/break	19
caps lock	20
escape	27
page up	33
page down	34
end	35
home	36
left arrow	37
up arrow	38
right arrow	39
down arrow	40
insert	45
delete	46
0	48
1	49
2	50
3	51
4	52
5	53
6	54
7	55
8	56
9	57
a	65
b	66
c	67
d	68
e	69
f	70
g	71
h	72
i	73
j	74
k	75
l	76
m	77
n	78
o	79
p	80
q	81
r	82
s	83
t	84
u	85
v	86
w	87
x	88
y	89
z	90
left window key	91
right window key	92
select key	93
numpad 0	96
numpad 1	97
numpad 2	98
numpad 3	99
numpad 4	100
numpad 5	101
numpad 6	102
numpad 7	103
numpad 8	104
numpad 9	105
multiply	106
add	107
subtract	109
decimal point	110
divide	111
f1	112
f2	113
f3	114
f4	115
f5	116
f6	117
f7	118
f8	119
f9	120
f10	121
f11	122
f12	123
num lock	144
scroll lock	145
semi-colon	186
equal sign	187
comma	188
dash	189
period	190
forward slash	191
grave accent	192
open bracket	219
back slash	220
close braket	221
single quote	222

Standard Javascript Validation Coding

2008-07-07T02:23:00.000-07:00

Dear All ,

i have list out the Standard Javascript Validation Coding ,I hope it may be usefully for all Web developer .

Example.js

function Validator(frmname)
{
this.formobj=document.forms[frmname];
if(!this.formobj)
{
alert("BUG: couldnot get Form object "+frmname);
return;
}
if(this.formobj.onsubmit)
{
this.formobj.old_onsubmit = this.formobj.onsubmit;
this.formobj.onsubmit=null;
}
else
{
this.formobj.old_onsubmit = null;
}
this.formobj.onsubmit=form_submit_handler;
this.addValidation = add_validation;
this.setAddnlValidationFunction=set_addnl_vfunction;
this.clearAllValidations = clear_all_validations;
}
function set_addnl_vfunction(functionname)
{
this.formobj.addnlvalidation = functionname;
}
function clear_all_validations()
{
for(var itr=0;itr < validationset =" null;" itr="0;itr" str =" var ret = " itemobj =" this.formobj[itemname];" validationset =" new" desc="desc;" error="error;" itemobj =" inputitem;" validate="vdesc_validate;" vset="new" add=" add_validationdesc;" validate=" vset_validate;" itemobj =" inputitem;" itr="0;itr= 0)
{
command = strValidateStr.substring(0,epos);
cmdvalue = strValidateStr.substr(epos+1);
}
else
{
command = strValidateStr;
}
switch(command)
{
case "req":
case "required":
{
if(eval(objValue.value.length) == 0)
{
if(!strError || strError.length ==0)
{
strError = objValue.name + " : Required Field";
}//if
alert(strError);
return false;
}//if
break;
}//case required
case "maxlength":
case "maxlen":
{
if(eval(objValue.value.length) > eval(cmdvalue))
{
if(!strError || strError.length ==0)
{
strError = objValue.name + " : "+cmdvalue+" characters maximum ";
}//if
alert(strError + "\n[Current length = " + objValue.value.length + " ]");
return false;
}//if
break;
}//case maxlen
case "minlength":
case "minlen":
{
if(eval(objValue.value.length) < length ="=" strerror =" objValue.name" length = " + objValue.value.length + " charpos =" objValue.value.search("> 0 && charpos >= 0)
{
if(!strError || strError.length ==0)
{
strError = objValue.name+": Only alpha-numeric characters allowed ";
}//if
alert(strError + "\n [Error character position " + eval(charpos+1)+"]");
return false;
}//if
break;
}//case alphanumeric
case "num":
case "numeric":
{
var charpos = objValue.value.search("[^0-9]");
if(objValue.value.length > 0 && charpos >= 0)
{
if(!strError || strError.length ==0)
{
strError = objValue.name+": Only digits allowed ";
}//if
alert(strError + "\n [Error character position " + eval(charpos+1)+"]");
return false;
}//if
break;
}//numeric
case "telephone":
{
var charpos = objValue.value.search("[^0-9 - ()]");
if(objValue.value.length > 0 && charpos >= 0)
{
if(!strError || strError.length ==0)
{
strError = objValue.name+": Only digits allowed ";
}//if
alert(strError + "\n [Error character position " + eval(charpos+1)+"]");
return false;
}//if
break;
}
case "alphabetic":
case "alpha":
{
var charpos = objValue.value.search("[^A-Za-z]");
if(objValue.value.length > 0 && charpos >= 0)
{
if(!strError || strError.length ==0)
{
strError = objValue.name+": Only alphabetic characters allowed ";
}//if
alert(strError + "\n [Error character position " + eval(charpos+1)+"]");
return false;
}//if
break;
}//alpha
case "txtlength":
{

if(objValue.value.length > 0)
{
var test=objValue.name
var test1=objValue.name.replace(/Name/, "Email")

if(document.forms["QubePayPal"][test1].value.length > 0)
{
return true;
}
else
{
alert('Enter the '+test1);
document.forms["QubePayPal"][test1].focus()
return false;

}

return false;
}
break;
}
case "txtlength1":
{

if(objValue.value.length > 0)
{
var test=objValue.name
var test1=objValue.name.replace(/Email/, "Name")

if(document.forms["QubePayPal"][test1].value.length > 0)
{
return true;
}
else
{
alert('Enter the '+test1);
document.forms["QubePayPal"][test1].focus()
return false;

}

return false;
}
break;
}
case "alnumhyphen":
{
var charpos = objValue.value.search("[^A-Za-z0-9\-_]");
if(objValue.value.length > 0 && charpos >= 0)
{
if(!strError || strError.length ==0)
{
strError = objValue.name+": characters allowed are A-Z,a-z,0-9,- and _";
}//if
alert(strError + "\n [Error character position " + eval(charpos+1)+"]");
return false;
}//if
break;
}
case "email":
{
if(objValue.value.length!=0)
{
if(!validateEmailv2(objValue.value))
{
if(!strError || strError.length ==0)
{
strError = objValue.name+": Enter a valid Email address ";
}//if
alert(strError);
return false;
}//if

}
else
{
return true;
}
break;
}//case email
case "lt":
case "lessthan":
{
if(isNaN(objValue.value))
{
alert(objValue.name+": Should be a number ");
return false;
}//if
if(eval(objValue.value) >= eval(cmdvalue))
{
if(!strError || strError.length ==0)
{
strError = objValue.name + " : value should be less than "+ cmdvalue;
}//if
alert(strError);
return false;
}//if
break;
}//case lessthan
case "gt":
case "greaterthan":
{
if(isNaN(objValue.value))
{
alert(objValue.name+": Should be a number ");
return false;
}//if
if(eval(objValue.value) <= eval(cmdvalue)) { if(!strError || strError.length ==0) { strError = objValue.name + " : value should be greater than "+ cmdvalue; }//if alert(strError); return false; }//if break; }//case greaterthan case "regexp": { if(!objValue.value.match(cmdvalue)) { if(!strError || strError.length ==0) { strError = objValue.name+": Invalid characters found "; }//if alert(strError); return false; }//if break; }//case regexp case "dontselect": { if(objValue.selectedIndex == null) { alert("BUG: dontselect command for non-select Item"); return false; } if(objValue.selectedIndex == eval(cmdvalue)) { if(!strError || strError.length ==0) { strError = objValue.name+": Please Select one option "; }//if alert(strError); return false; } break; }//case dontselect }//switch return true; } Then We have to add following line in yours Validation page and Include the Example.js file also. var frmvalidator = new Validator("FORM NAME"); frmvalidator.addValidation("FieldTextBoxName","req","Please enter your FieldTextBoxName"); frmvalidator.addValidation("FieldTextBoxName","maxlen=20","Max length for FieldTextBoxName is 20"); frmvalidator.addValidation("FieldTextBoxName","alpha"); the Above Example validate the Alphabets.

S.Vinothkumar: RoleManagement in Asp.Net

2008-07-01T22:56:00.000-07:00

S.Vinothkumar: RoleManagement in Asp.Net

How to Get Client IP using C#..?

2008-07-01T22:44:00.000-07:00

Following Lines are help us to get Client IP using C#.

string myHost = System.Net.Dns.GetHostName();

string myIP = System.Net.Dns.GetHostByName(myHost).AddressList[0].ToString();

S.Vinothkumar: Sql Server Function to get number of working days in given days.

2008-06-30T04:39:00.000-07:00

S.Vinothkumar: Sql Server Function to get number of working days in given days.

sundar

call javascript Function in Page load event in ASP.Net

struct and a class

Char Vs Varchar

Caching in ASP.NET

Introduction

The Types of Caching in ASP.NET

Output Caching

Fragment Caching

Data Caching

SQL injection

AutoEventWireup attribute in ASP.NET

Difference between user defined function and stored procedure

Advantages of User Defined Functions

Disadvantages of User Defined Functions

Types of User Defined Functions

Scalar UDFs

Inline Table UDFs

Multi Statement UDFs

Conclusion

Example for Interface and Abstract class

Left Outer join with Having in SQL Server

Personal Interview Questions

Readonly vs const

const vs. readonly

const

readonly

static

General Interview Question

1. Project skills interview questions

2. Leadership interview questions

3. Judgment interview questions

4. Experience interview questions

5. Competency interview questions

Five Tips To Remove Stomach Fat You Can Use Today

5 Tips To Remove Stomach Fat You Can Use Today

SQL Server, Drop All Tables in Database Quickly

Page Life Cycle Events

LINQ

Difference between ADO.net Dataset and ADO Recordset

The out and ref Paramerter in C#

Joins In Sql Server

Interview question

how to Debug Client (java) Script in visual studio 2005?

caling javascript from codebehind file while using Ajax .

Javascript Char Codes (Key Codes)

Javascript Char Codes (Key Codes)

Standard Javascript Validation Coding

S.Vinothkumar: RoleManagement in Asp.Net

How to Get Client IP using C#..?

S.Vinothkumar: Sql Server Function to get number of working days in given days.

`const` vs. `readonly`

`const`

`readonly`

`static`