Specializations

Tuesday, November 13, 2012

Avoid Acting Desperate During an Interview

  1. Be balanced. When summing up your work experience for the interviewer and your skills, take an approach that shows you have learned from your experience and still retain optimism for the future. Avoid using terms that describe current and previous experiences as totally dire or terrifically amazing, because both extremes will be discounted by an interviewer as unrealistic and unbalanced. Find the middle way to describe your experience and you won't sound desperate to convey exaggerated viewpoints.

  2. Present well from the moment you enter the interview room. Dress well, even if the potential workplace consists of people who don jeans every day. Contrary to a desire to "be yourself" through appearing "casual as" or devil-may-care, you can't afford to give any impression of sloppiness, as it imprints "desperate" across your forehead. Be sure that your clothing is neat, ironed if appropriate for the fabric, adjusted to the standard of the workplace you're hoping to join, tucked in where needed (and nothing hanging out that shouldn't be) and that your hair is one hundred percent dry (wet hair suggests you only just made it out the door).
    • Have a firm handshake. Not too strong, not too weak––a handshake speaks volumes about your self confidence. In particular, a floppy handshake will cause the interviewer to feel that you aren't really into this interview from the start.
  3. Never make excuses for any inadequacies. If you have a few hiccups in your resume, a long stretch of time out of work, or questionable happenings that may not be in writing but are likely to be known in the industry, don’t excuse them with self-effacing excuses. Interviews are a moment of self sales pitching, and making comments about your lack of skills, lack of confidence and not feeling worthy will scare the employer off––remember that they have a wide choice of people and understanding your personal issues isn't their top priority.
    • See a recruitment counselor, coach or therapist if the job seeking is bringing you down. It is important to get your anger, frustration, shyness, etc. dealt with away from the interview situation and the professionals in these fields are there to do just that. They can make a difference, especially if you start ruminating too much and begin to see the whole search as hopeless.
  4. Never fingerpoint. Things go wrong at work for everyone at times. Sometimes, they are wrong enough to cause you to want to leave a job or to end up in being fired. Yet, a potential employer isn't going to feel reassured if you explain that the reason for no longer being in your old job is because "X did such and such to me". Once you start placing blame or making excuses, you're going to look weak, lacking in the ability to be either a team player or to lead/manage, and you'll most likely come across as desperate. Avoid placing blame on someone else. Regardless of the situation, never tell your interviewer that you lost your job or a project fell apart due to the incompetence of another person. Instead, be confident when you state the facts and explain what it would take to create a successful situation (if you were able to do it over again).
    • Don’t just blame the economy or the job market. Once again, blame is typically frowned upon during an interview as it's an indicator of a wider tendency to place blame rather than accept responsibility––something few employers want to see in their employees. Your interviewer knows that the economy is down in the dumps and that jobs in various industries are scarce, so pointing out this obvious fact, or making it the reason you're unemployed, will only have a negative effect on your interview.
    • Never badmouth another person or previous employer in order to lay blame for a mistake. Employ the cardinal rule of “never burning your bridges”, no matter how much another person tormented you or perhaps even sabotaged your life. If you badmouth another, you may end up looking like a whiner, bad guy or worse... a victim.
  5. Be calm and confident during your discussion. The best way to approach feeling nervous, being asked challenging questions and worrying about your general prospects, is to remain calm and cool during your interview. Don’t dwell on problems in the past. Instead, punctuate your strengths and play up what you can bring to the potential employer’s company now and for the future.

    • In preparation for an interview, write out your strengths on paper. This will help you to identify them, as well as giving you the chance to focus on those that truly stand out for you in relation to the particular job you're interviewing for. Read through these strengths many times and elaborate on them out loud, as if talking to the interviewer. The more that you know this aspect of yourself inside out, the easier it will flow for you during the interview.
    • Do the same preparation for common interview questions. Write them down and write down answers. Then role play scenarios in the lead-up to the interview so that when you're actually asked the questions, they are already familiar to you and you feel calm in answering them. There will always be questions that differ from those you've prepared for, but you will have enough basic material well ordered in your head to work from that these shouldn't throw you.
    • Do plenty of background research into the company you're applying for. If they ask you what their last year's sales figures were, what their corporate logo means, who started the company and why, what the corporate philosophy is, etc., you'll know if you've read their website and annual report or equivalent, inside out. While researching, never hesitate to call the company with factual questions that need clarification. It is better to have shown the initiative to find out than to panic and go blank.
  6. Avoid using “desperate” language during the interview. There are certain phrases and language that are definitely off limits if you don’t want to look desperate. These include:
    • Stop yourself from saying that you’ll “do anything” to land the job. As opposed to having the right experience or education to handle the job, telling the employer you’ll literally do anything to land it may turn him or her off. It suggests that you no longer have credible skills or value yourself enough.
    • On the other hand, don't oversell yourself. Identify your strengths, but be humble when talking about your accomplishments. If you come on too strong you’ll look desperately aggressive––and possibly a little scary. Nobody wants to hear a narcissistic rant about how brilliant you are or how you single-handedly saved the company; keep it realistic and always remember that it takes a village as far as the interviewer is concerned.
    • Monitor how many times you communicate that you are the right person for the job. It’s okay to let the prospective employer know that you're the ideal fit for the job (after you’ve discussed the dimensions of the job as compared to your qualifications), but it will look like you are laying it on too thick if you keep telling him or her that you're the best person for the job after each statement or comment. Spread it thinly––they hear you.
  7. 7
    Be careful with throwaway comments. Sometimes desperation shows in the little things you after a perfectly well presented answer––things best left unsaid. For example, you might have just explained why you want the job to the interviewers and really impressed them. And then, you add a final comment like "because my current job is just crazy and I don't really know why I'm still doing it." You've just undone all the good that came from what you said! Throwaway comments, even if a poor attempt at humor, are nervousness creeping in. Consciously avoid this nervous tic, as it's what the interviewer will remember.
    • Don't try to turn the interviewer into your co-conspirator. It may feel tempting to try and get the interviewer "on side" but the fact you've got an interview should already reassure you that they're interested enough. By saying things like "you know what I mean", or "I'm sure you know the kind of thing I'm talking about" or "I bet you've had a similar experience", etc., you cross a line from formal discussion into informal and rather invasive presumptions about the interviewer. You're not there to know their mind; rather, they're there to get to know yours. Doing this won't win you a friend and it may lose you the job.
  8. Watch your body language and tone. Body language (demeanor) and the manner in which you speak can be a dead giveaway that you're feeling “desperate.” Practice a role play interview in front of the mirror, seated. Notice how you're coming across when you say certain things, such as describing why you want the job, talking about the company's background and answering standard (or not-so-standard) interview questions. You might even video yourself using your computer. Whatever method you use, look for body and demeanor tell-tale signs of confidence or desperation. For example, a confident interviewee will sit tall but not rigidly, will lean slightly in toward the interviewers and will smile more often than not. A desperate interviewee might fidget, look down, push the chair back a little and make poor eye contact.
    • Breathe regularly and slow down while you're talking. One of the telltale signs of desperation and anxiety is talking too fast and/or sounding like you're trying to get as much information out as fast as possible (so that you don’t forget what you wanted to say). Without being overly obvious, take a breath before you speak and consciously try to control the speed in which the words leave your mouth. It is okay to ask for a moment to restore your composure if you feel blank or overly nervous.
    • Never interrupt and never talk over the interviewer or answer questions too quickly. You may be overly enthusiastic about making sure the interviewer knows you're qualified, which may prompt you to talk over what he or she is saying. Or, your might try to jump in and answer questions before the interviewer finishes asking them. This will worry the interviewer that you're impatient, incapable of listening or just plain rude. Slow down, you will still get across everything in the time given.
    • Gently place your hands in your lap and relax. The idea is that if you appear relaxed but confident, your interviewer will see you as a viable candidate that could be an asset to the company. Relaxed people reassure others, so above all, work on looking confidently relaxed.
    • Sit tall, but avoid looking too stiff. Posture is an important subconscious indicator of a person's sense of self worth. Don’t lean too far forward or slouch––either position will give off the wrong signal that you're desperate or have simply given up.
  9. Don’t act too available. Once again, the rules of dating apply. Without stating that you're interviewing with other firms, give your prospective employer the impression that other companies––possibly competitors, are pursuing you (even if they aren’t).
    • Bring your planner to the interview (that should be filled with “appointments”) to make sure your interviewer doesn’t think your dance card isn’t filled.
    • If the interviewer calls you back, don’t jump to answer the phone on the first ring. In fact, let the first call go to voicemail, listen to what the interviewer has to say and then call back within a few hours. If you do answer the phone, always ask for time to consider their offer.
    • Give the impression that you're fielding offers. Listen intently to what the interview has to offer and say. If he or she makes you an offer, thank the interviewer and ask if you can call him or her back later that day. Don’t wait too long or else the employer may think you aren’t interested, however don’t just jump with an answer of “yes” the minute the interviewer presents the offer. You still want to obtain the best scenario for you.
  10. Follow up with your interviewer, but within reason. Calling your interviewer from your car five minutes following your discussion will most certainly make you look desperate. When it comes to follow up, apply a few rules typically reserved for dating:

    • Contact your interviewer after 48 hours of your interview with a thank you phone call and brief card. Don’t jump on the horn immediately but don’t drag your feet with follow up. A two business day wait time will make you still appear interested in the job but not desperate. Also, the two-pronged follow-up allows you to verbally touch base and answer any questions the interviewer may have, and the card keeps you front and center on paper.
    • Avoid re-stating why you should have the job. Instead focus on why you enjoyed meeting the interviewer. Your interviewer most likely knows the reasons why you want the job (based on your interview), so re-stating those reasons during your follow up may lend you toward appearing desperate. Instead, just re-iterate that you enjoyed meeting him/her and mention that you are open to any questions not covered during the interview.
    • Only follow up once, but make sure your follow-up left a positive (and not desperate) impression. If you follow up two days later but don’t hear anything a day or two later, leave it alone. At this point the interviewer knows you're very interested in the job and if you keep calling and/or following up, he or she may get annoyed with you. Also, when you make that follow up call, be upbeat and to the point. Tell the interviewer you were touching base in case he or she had any additional questions, and then mention something about the positive exchange you had.


Tips

  • Let much of your true personality come through by having confidence in yourself. Who you really are will ensure a good click with the interviewers if this is the right job for you, so do your best to relax and shine. On the other hand, don't be so much "yourself", that you think it's okay to take up residence in the interview room and parade your eccentricities, personal quirks and intense dislikes. Balance and propriety are more important than airing your personal laundry (which can make you seem desperate and unhappy with life in general).
  • Answer questions or make your point using succinct, concise sentences––avoid rambling on and on during an interview.
  • Remember to ask your interviewer questions––he or she should know that you too are interviewing the company to determine if the company is a match for you. Prepare these in advance so that you're not left scrambling for ideas once in the actual interview. Again, your research on the background of the company will help you to target good questions.
  • Ask questions about things you know this employer's good for - tell them that you're looking for a better working environment if it seems like a casual workplace, or if you see a plaque for "Best psychologically healthy workplace." If it looks stressed and busy emphasize how you are looking for a fast paced, intense job. Stay reality focused but put a positive spin on the questions. This gives an impression that you're choosing the company over several offers and are good enough that you're the one doing the choosing.
  • Choose the companies you interview with and jobs you interview for well. Choose them for personal reasons so that when you do feel something about it, you like that company for real reasons. The feeling is likely to be mutual.
  • Make it reality that you're choosing between multiple possibilities. Try cold calling companies that have the job you want to do. Choose the type of working conditions, pay scale, type of tasks, mission of the job you want and then look for companies that have those jobs. Cold call companies that employ people for that job. If you've heard something good about a company, cold call them and ask if they have an opening. If they don't, ask if you can put your resume on file with them. This can get you the job ahead of their advertising for it. You've just been very professional and assertive by calling them first, then sending resume. Cold calling means "call dozens and hundreds of places." Most will say no. But when you find the one that just had an opening come up, they might hire you fast instead of paying for an ad and interviewing hundreds of people.
  • Do your homework prior to the interview. This will not only give you a leg up on someone who goes in blind, knowledge will provide you with confident power and insight on how your talents can be valuable to the company. Do not bother to interview with companies that you would hate for their policy or the type of work. They don't want you if you don't want them, a bad match isn't worth the time and someone else who thinks well of them is who they'll hire.

Source: http://www.wikihow.com/Avoid-Acting-Desperate-During-a-Job-Interview

Clear all control values using conditions in C#.net

 // we want to clear controls with in the panel or with in the group or with in the screen. we have to pass that contol if you want complete screen controls just pass this

Calling method:FindAllTextBox(this, false);


method implimentation:


public void FindAllTextBox(Control ctrl, bool flag)
        {

            if (ctrl != null)
            {
                foreach (Control c in ctrl.Controls)
                {
                    if (c is TextBox)
                    {
                        if (flag) ((TextBox)c).Text = string.Empty;
                        else
                            if ((c.ID != "txtCustomer") && (c.ID != "txtExporter") && (c.ID != "txtSONum") && (c.ID != "txtSODate"))
                                ((TextBox)c).Text = string.Empty;
                        if (c.ID == "txtSODate") ((TextBox)c).Text = DateTime.Now.ToString("MM/dd/yyyy");

                    }
                    if ((c is CheckBox) && (c.ID != "chkValidateParts"))
                        ((CheckBox)c).Checked = false;
                    if (c is DropDownList)
                        ((DropDownList)c).SelectedIndex = 0;

                    FindAllTextBox(c, flag);
                }
            }
        }


If you pass flag value is "true" controls are clear other wise exect condition control are not clear the values.


if you dont want any condition using bellow method

Method Calling:FindAllTextBox()


method implementations



public void FindAllTextBox()
        {

            if (ctrl != null)
            {
                foreach (Control c in this.Controls)
                {
                    if (c is TextBox)
                    {
                        if (flag) ((TextBox)c).Text = string.Empty;                       
                    }
                    if ((c is CheckBox) && (c.ID != "chkValidateParts"))
                        ((CheckBox)c).Checked = false;
                    if (c is DropDownList)
                        ((DropDownList)c).SelectedIndex = 0;
                    FindAllTextBox();
                }
            }
        }





Linq with Grid view in ASP.net and C#.net

We have a grid view and it contains check boxes we want selected grid view information using Linq
 
1) Gridview checkbox seleted row values getting and updated list<> values
(from GridViewRow msgRow in gvSalesOrder.Rows
             where ((CheckBox)msgRow.FindControl("chkPONO")).Checked
             select ((Label)(msgRow.FindControl("ltlPNO"))).Text).ToList().ForEach(delegate(string p)
            {
                liEXPSOPO.Where(x => x.POID == p).ToList().ForEach(delegate(EXPSOPO di)
                {
                    if (di.STATUS == "N")
                        liEXPSOPO.Remove(di);
                    else di.STATUS = "R";
                });

            });
 FindControl("your controlname"):--This method is use full to get the control with in the grid row or with in the group controls. here we are using to get the infor mation with in the grid row.

(or)
another way to getting results

Using Lambda expressions to get the gridview selected row information with generic methods list
2)  Getting Grid view seleted valuesusing link
var checkedIDs = from GridViewRow msgRow in gvSalesOrder.Rows
                        where ((CheckBox)msgRow.FindControl("chkPONO")).Checked
                          select ((Label)(msgRow.FindControl("ltlPNO"))).Text;
//convert  checkedIDs  to list
string[] poids = checkedIDs.ToArray();

//list view content updation
liEXPSOPO.Where(x => x.POID == p).ToList().ForEach(delegate(EXPSOPO di)
               {
                 if (di.STATUS == "N")
                       liEXPSOPO.Remove(di);
                  else di.STATUS = "R";
              });

Monday, November 12, 2012

4 Mistakes Employers Are Sure To Notice


During the hunt for a job, it’s common to continually seek new ways to stand out to your potential employers. While job seekers are busy developing their unique elevator pitches, they might be overlooking the little mistakes that set them apart in a negative way to potential employers.
Not having the success you expected during your job search? Here are four mistakes employers might be noticing:
1. You’re Underprepared. It’s all too common for job seekers to “wing it” during the search for a new position. When it comes to the application process and interview, a potential employer is certain to notice your preparedness. Candidates who plan to successfully and positively stand out to employers spend time preparing their application before submitting it, as well as prior to each and every interview.
During the application process, it is essential that you customize both your cover letter (yes, you always need one) and resume for each position. A quick glance at the company website can provide you with important knowledge to accurately customize your application materials to the position, although even deeper research is highly recommended. This will show the employer you’re familiar with the company’s mission, values, and that you have the necessary skills for the position. Don’t waste an employer’s time by applying unprepared.
Preparation is also important when interviewing. You’ve certainly stood out to an employer if you’ve made it to the interview portion of the hiring process, but they will be able to quickly tell whether or not you have properly prepared for the conversation as soon as it begins. Stand out by knowing exactly how to discuss the previous experiences listed on your resume, as well as having in-depth knowledge about the company. Practice general interview questions and how to effectively communicate your skills to set yourself apart from the competition.
2. You Have a Poor Attitude. During the job search, the power of a positive attitude is everything. No one wants to hire a downtrodden, negative employee, and an easy way to showcase yourself in a negative light is by expressing anything less than positivity during your interactions with a potential employer.
A positive and energetic attitude will not only get you noticed, but also it will certainly set you apart from the competition. Employers want to hire candidates who not only are easy to work with and can accomplish tasks, but also those who have a smile on their face and will fit in well with the company culture.
During your interview, remain focused on your body language. Do you have a content expression on your face? Where are your hands? Do you look attentive? Your ability to communicate your excitement for the position will certainly allow you to stand out to your employers in a positive way.
3. You’re Overly Confident. While confidence is certainly an important aspect of a successful job search, too much of it is certain to have employers running in the opposite direction. Expressing too much confidence during an interview can easily set you up as a poor candidate to potential employers. Too much confidence is often attributed to those who aren’t humble workers — or are even hard to work with in general. During an interview, respectfully focus on your achievements and what you can bring to the position and company, without imposing an air of pretension on your interviewers.
4. You are Unprofessional. Whether in-person, on the phone, or online, employers find it easy to note the professionalism of their candidates. This could be as simple as an inappropriate tweet or even the way a candidate dresses for an interview.
With a quick online search, potential employers can easily access your personal brand via your social networks and blog. Anything that is less than professional will stick out like a sore thumb. Utilize your online presence to stand out in a positive way by sticking to appropriate topics.
As a job seeker, your search depends on standing out to your potential employer. Make sure you’re doing this in a positive way to ensure getting hired.4 Mistakes Employers Are Sure To Notice

10 Reasons Employees Resign


Good managers know very well how expensive employee turnover can be and work diligently to keep those costs at a minimum. It is a fact that not every employee can be retained no matter how fairly they are treated, and some are actually welcome to leave.
Below are ten reasons employees resign, along with suggestions for retaining those valuable players that are hard or impossible to replace:
  1. Employees Feel Underappreciated. Those who leave for this reason aren’t looking for a pat on the back every time they show up for work on time or finish a task. They simply need to be reminded from time to time that their contributions are a value to the team. Ignore them for too long, and they will seek that appreciation elsewhere.
  2. A Lack of Proper Compensation. This is a big one and should be addressed even if the company feels it is being fair. It is no secret that companies that are the most generous in this arena are also some of the most successful.
  3. Insufficient Time Off. In an attempt to do more with less, some employers are saddling their employees with additional workloads to compensate for a leaner staff. Initially, this approach may result in a healthier bottom-line, but ultimately it will lead to higher turnover cost and lower production as workers begin to tire of the rigorous schedule forced on them.
  4. Change In Management. Companies that fail to recognize the impact of this decision risk losing valuable personnel. Taking the time to speak with those most affected is of the utmost importance for keeping morale up and the transition smooth.
  5. Outdated Machinery and Equipment. Whether it’s warehouse equipment or the office phone system, tools that make life more difficult for those that use them play a major role in employees running for the exit. Continuing to replace these workers may prove more expensive than replacing the tools over the long run.
  6. Unrealistic Goals. Setting goals and quotas is important for maintaining production levels and achieving maximum results. This is true in all aspects of life be it personal or business.  Constantly moving the “carrot” without regard for what it takes to reach it will usually wind up in a breakdown in morale and desire. Employees who are consistently put to the test in this manner will eventually decide it is simply not worth it.
  7. Lack of Management Support. Managers who are unwilling to back up those who depend upon them will find it difficult to maintain a staff. This doesn’t mean being the “dumping ground” for every grievance, but it does mean having a certain intestinal fortitude as it concerns righting legitimate wrongs–even when it involves putting those issues above your own career goals. This is how you become a respected leader.
  8. The Need to Be Challenged. If school-aged children get bored with their studies, their minds wander and their grades drop. When working adults get bored with their jobs, their minds wander and they start seeking a more challenging position. Keeping a bright employee challenged with rewarding tasks is the best way to keep a bright employee, period.
  9. Lack of a Joyful Environment. Look around your place of business. Do your employees seem happy to be there? Is there a certain positive energy among your staff that seems to reverberate from department to department? If not, why not? Work places needn’t be all drudgery, and those that are have bigger problems than the frowns that everyone is wearing. This doesn’t mean it needs to be a constant party atmosphere. But it should at least be pleasant.
  10.  Lack of a Clear Pathway to Success. Many times an employee will become frustrated with the inability or unwillingness of management to provide them with a working model for success with the firm. Most people will not set out on a journey without some idea of the direction they are headed. And if they get lost along the way, they will generally head in another direction. Good and attentive management will take the time to nurture those with an eye on the future and see their value from a long-range perspective.
Companies spend a lot of time, energy and money to hire the right people. All of these resources are wasted if they can’t keep the people they’ve invested so much in already.10 Reasons Employees Resign

Limitations of the XML Data Type


XML Limitations

Limitations of the XML Data Type
Although the XML datatype is treated like many other datatypes in SQL Server 2005, there are specific limitations to how it is used. These limitations are:
  • XML types cannot convert to text or ntext data types.
  • No data type other than one of the string types can be cast to XML.
  • XML columns cannot be used in GROUP BY statements.
  • Distributed partitioned views or materialized views cannot contain XML data types.
  • Use of the sql_variant instances cannot include XML as a subtype.
  • XML columns cannot be part of a primary or foreign key.
  • XML columns cannot be designated as unique.
  • Collation (COLLATE clause) cannot be used on XML columns.
  • XML columns cannot participate in rules.
  • The only built-in scalar functions that apply to XML columns are ISNULL and COALESCE. No other scalar built-in functions are supported for use against XML types.
  • Tables can have only 32 XML columns.
  • Tables with XML columns cannot have a primary key with more than 15 columns.
  • Tables with XML columns cannot have a timestamp data type as part of their primary key.
  • Only 128 levels of hierarchy are supported within XML stored in the database.

Thursday, July 12, 2012

How To Prepare Interview