Specializations

Tuesday, November 13, 2012

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

Wednesday, January 9, 2008