Skip or bypass Rapidshare, Megaupload Waiting time

Yes, you are reading it correctly, its not a prank or joke, now you can easily avoid the waiting time or usually we say time limit when you download as a free user from the file sharing services such as rapidshare, megaupload, deposifiles, hotfile. Normally you have to wait for 20-60 minutes to download the second file after downloading the first one. They implement ways to invite users to purchase a premium service. But this way of limiting Free download limit and asking free users to wait for long time to start another download can be annoying one.
Skipscreen is an extension to browser to by pass waiting time on download. Unfortunately it can only be used with Firefox browsers to avoid waiting time while downloading files from some popular File hosting services like:

* Rapidshare.com
* zShare.net
* MediaFire.com
* Megaupload.com
* Sharebee.com
* Depositfiles.com
* Sendspace.com
* Divshare.com
* Linkbucks.com
* Uploaded.to
* Hotfiles.com
* 4shared.com
* Limelinx.com
* Link-Protector.com
Its use is very simple and does not require any configuration, just go to the addon page of the extension and install it, restart your browser and enter one of thesedownload sites and you will no longer have to wait.
Download Skip Screen Firefox Extention

Alternative Methods or Hacks to Beat Rapidshare Download Limits and Waiting Time

Method 1:  Using Java Script:
1. Goto the page you want to download
2. Select FREE button
3. In the address bar put the following: javascript:alert(c=0)
4. Click OK
5. Click OK to the pop-up box
6. Enter the captcha
7. Download Your File

Method 2:  Request a new IP address from your ISP server
Here’s how to do it in windows:
1. Click Start
2. Click run
3. In the run box type cmd.exe and click OK
4. When the command prompt opens type the following.
ENTER after each new line.
ipconfig /flushdns
ipconfig /release
ipconfig /renew
exit
Note: This might only work for DSL/Modem Internet Connection, not for Cable Internet users

Disclaimer: Some call this as hacking trick or Hacking Rapidshare, but its in no way related to hacking. All information mentioned above is not created by Codejunction.blogspot.com.

Top 10 unknown Google tricks

Below is a list of our top ten Google tricks many users don't know about.

1. Definitions - Pull up the definition of the word by typing define followed by the word you want the definition for. For example, typing: define bravura would display the definition of that word.
2. Local search - Visit Google Local enter the area you want to search and the keyword of the place you want to find. For example, typing: restaurant at the above link would display local restaurants.
3. Phone number lookup - Enter a full phone number with area code to display the name and address associated with that phone number.
4. Find weather - Type weather followed by a zip code or city and state to display current weather conditions and forecasts for upcoming days.
5. Track airline flight - Enter the airline and flight number to display the status of an airline flight and it's arrival time. For example, type: delta 123 to display this flight information if available.
6. Track packages - Enter a UPS, FedEx or USPS tracking number to get a direct link to track your packages.
7. Pages linked to you - See what other web pages are linking to your website or blog by typing link: followed by your URL. For example, typing link:http://codejunction.blogspot.com displays all pages linking to Computer Hope.
8. Find PDF results only - Add filetype: to your search to display results that only match a certain file type. For example, if you wanted to display PDF results only type: "dell xps" filetype:pdf -- this is a great way to find online manuals.
9. Calculator - Use the Google Search engine as a calculator by typing a math problem in the search. For example, typing: 100 + 200 would display results as 300.
10. Stocks - Quickly get to a stock quote price, chart, and related links by typing the stock symbol in Google. For example, typing: msft will display the stock information for Microsoft.

Pen drive displaying only shortcuts but space occupied

If you did not format your flash drive, then check whether the files are not in

hidden mode. Follow the following steps.

Step 1:

Click on the below link and download the file "AutorunExterminator"

http://en.kioskea.net/download/download-11613-autorun-exterminator

Extract it --> Double-click on "AutorunExterminator" --> Plug your pendrive now.

This will remove the autorun.inf files from your pendrive and also from drives.

Step 2:

Click on "Start" -->Run --> type cmd and click on OK.

Here I assume your pen drive letter as G:

Enter this command.

attrib -h -r -s /s /d g:\*.*

You can copy the above command --> Right-click in the Command Prompt and

paste it.

Note : Don't forget to replace the letter g with your pen drive letter.

Now press "Enter".

Now check for your files in Pen Drive.

Step 3:

After that, download the Malwarebytes' Anti-Malware from the below link

http://en.kioskea.net/download/download-105-malwarebytes-anti-malware

Update it --> Perform "Full Scan"

Note : Default selected option is "Quick Scan".

Good Luck.

140 Google Interview Questions

Here's a list of 140 Google interview questions. Many of our clients have interviewed and received Google job offers.

Link to Google interview questions for:

Product Marketing Manager

Product Manager

Software Engineer

Software Engineer in Test

Quantitative Compensation Analyst

Engineering Manager

AdWords Associate

Google Interview Questions: Product Marketing Manager

• Why do you want to join Google?
• What do you know about Google's product and technology?
• If you are Product Manager for Google's Adwords, how do you plan to market this?
• What would you say during an AdWords or AdSense product seminar?
• Who are Google's competitors, and how does Google compete with them?
• Have you ever used Google's products? Gmail?
• What's a creative way of marketing Google's brand name and product?
• If you are the product marketing manager for Google's Gmail product, how do you plan to market it so as to achieve 100 million customers in 6 months?
• How much money you think Google makes daily from Gmail ads?
• Name a piece of technology you’ve read about recently. Now tell me your own creative execution for an ad for that product.
• Say an advertiser makes $0.10 every time someone clicks on their ad. Only 20% of people who visit the site click on their ad. How many people need to visit the site for the advertiser to make $20?
• Estimate the number of students who are college seniors, attend four-year schools, and graduate with a job in the United States every year.

Google Interview Questions: Product Manager

• How would you boost the GMail subscription base?
• What is the most efficient way to sort a million integers?
• How would you re-position Google's offerings to counteract competitive threats from Microsoft?
• How many golf balls can fit in a school bus?
• You are shrunk to the height of a nickel and your mass is proportionally reduced so as to maintain your original density. You are then thrown into an empty glass blender. The blades will start moving in 60 seconds. What do you do?
• How much should you charge to wash all the windows in Seattle?
• How would you find out if a machine’s stack grows up or down in memory?
• Explain a database in three sentences to your eight-year-old nephew.
• How many times a day does a clock’s hands overlap?
• You have to get from point A to point B. You don’t know if you can get there. What would you do?
• Imagine you have a closet full of shirts. It’s very hard to find a shirt. So what can you do to organize your shirts for easy retrieval?
• Every man in a village of 100 married couples has cheated on his wife. Every wife in the village instantly knows when a man other than her husband has cheated, but does not know when her own husband has. The village has a law that does not allow for adultery. Any wife who can prove that her husband is unfaithful must kill him that very day. The women of the village would never disobey this law. One day, the queen of the village visits and announces that at least one husband has been unfaithful. What happens?
• In a country in which people only want boys, every family continues to have children until they have a boy. If they have a girl, they have another child. If they have a boy, they stop. What is the proportion of boys to girls in the country?
• If the probability of observing a car in 30 minutes on a highway is 0.95, what is the probability of observing a car in 10 minutes (assuming constant default probability)?
• If you look at a clock and the time is 3:15, what is the angle between the hour and the minute hands? (The answer to this is not zero!)
• Four people need to cross a rickety rope bridge to get back to their camp at night. Unfortunately, they only have one flashlight and it only has enough light left for seventeen minutes. The bridge is too dangerous to cross without a flashlight, and it's only strong enough to support two people at any given time. Each of the campers walks at a different speed. One can cross the bridge in 1 minute, another in 2 minutes, the third in 5 minutes, and the slow poke takes 10 minutes to cross. How do the campers make it across in 17 minutes?
• You are at a party with a friend and 10 people are present including you and the friend. your friend makes you a wager that for every person you find that has the same birthday as you, you get $1; for every person he finds that does not have the same birthday as you, he gets $2. would you accept the wager?
• How many piano tuners are there in the entire world?
• You have eight balls all of the same size. 7 of them weigh the same, and one of them weighs slightly more. How can you find the ball that is heavier by using a balance and only two weighings?
• You have five pirates, ranked from 5 to 1 in descending order. The top pirate has the right to propose how 100 gold coins should be divided among them. But the others get to vote on his plan, and if fewer than half agree with him, he gets killed. How should he allocate the gold in order to maximize his share but live to enjoy it? (Hint: One pirate ends up with 98 percent of the gold.)
• You are given 2 eggs. You have access to a 100-story building. Eggs can be very hard or very fragile means it may break if dropped from the first floor or may not even break if dropped from 100th floor. Both eggs are identical. You need to figure out the highest floor of a 100-story building an egg can be dropped without breaking. The question is how many drops you need to make. You are allowed to break 2 eggs in the process.
• Describe a technical problem you had and how you solved it.
• How would you design a simple search engine?
• Design an evacuation plan for San Francisco.
• There's a latency problem in South Africa. Diagnose it.
• What are three long term challenges facing Google?
• Name three non-Google websites that you visit often and like. What do you like about the user interface and design? Choose one of the three sites and comment on what new feature or project you would work on. How would you design it?
• If there is only one elevator in the building, how would you change the design? How about if there are only two elevators in the building?
• How many vacuum’s are made per year in USA?

Google Interview Questions: Software Engineer

• Why are manhole covers round?
• What is the difference between a mutex and a semaphore? Which one would you use to protect access to an increment operation?
• A man pushed his car to a hotel and lost his fortune. What happened?
• Explain the significance of "dead beef".
• Write a C program which measures the the speed of a context switch on a UNIX/Linux system.
• Given a function which produces a random integer in the range 1 to 5, write a function which produces a random integer in the range 1 to 7.
• Describe the algorithm for a depth-first graph traversal.
• Design a class library for writing card games.
• You need to check that your friend, Bob, has your correct phone number, but you cannot ask him directly. You must write a the question on a card which and give it to Eve who will take the card to Bob and return the answer to you. What must you write on the card, besides the question, to ensure Bob can encode the message so that Eve cannot read your phone number?
• How are cookies passed in the HTTP protocol?
• Design the SQL database tables for a car rental database.
• Write a regular expression which matches a email address.
• Write a function f(a, b) which takes two character string arguments and returns a string containing only the characters found in both strings in the order of a. Write a version which is order N-squared and one which is order N.
• You are given a the source to a application which is crashing when run. After running it 10 times in a debugger, you find it never crashes in the same place. The application is single threaded, and uses only the C standard library. What programming errors could be causing this crash? How would you test each one?
• Explain how congestion control works in the TCP protocol.
• In Java, what is the difference between final, finally, and finalize?
• What is multithreaded programming? What is a deadlock?
• Write a function (with helper functions if needed) called to Excel that takes an excel column value (A,B,C,D…AA,AB,AC,… AAA..) and returns a corresponding integer value (A=1,B=2,… AA=26..).
• You have a stream of infinite queries (ie: real time Google search queries that people are entering). Describe how you would go about finding a good estimate of 1000 samples from this never ending set of data and then write code for it.
• Tree search algorithms. Write BFS and DFS code, explain run time and space requirements. Modify the code to handle trees with weighted edges and loops with BFS and DFS, make the code print out path to goal state.
• You are given a list of numbers. When you reach the end of the list you will come back to the beginning of the list (a circular list). Write the most efficient algorithm to find the minimum # in this list. Find any given # in the list. The numbers in the list are always increasing but you don’t know where the circular list begins, ie: 38, 40, 55, 89, 6, 13, 20, 23, 36.
• Describe the data structure that is used to manage memory. (stack)
• What's the difference between local and global variables?
• If you have 1 million integers, how would you sort them efficiently? (modify a specific sorting algorithm to solve this)
• In Java, what is the difference between static, final, and const. (if you don't know Java they will ask something similar for C or C++).
• Talk about your class projects or work projects (pick something easy)… then describe how you could make them more efficient (in terms of algorithms).
• Suppose you have an NxN matrix of positive and negative integers. Write some code that finds the sub-matrix with the maximum sum of its elements.
• Write some code to reverse a string.
• Implement division (without using the divide operator, obviously).
• Write some code to find all permutations of the letters in a particular string.
• What method would you use to look up a word in a dictionary?
• Imagine you have a closet full of shirts. It’s very hard to find a shirt. So what can you do to organize your shirts for easy retrieval?
• You have eight balls all of the same size. 7 of them weigh the same, and one of them weighs slightly more. How can you fine the ball that is heavier by using a balance and only two weighings?
• What is the C-language command for opening a connection with a foreign host over the internet?
• Design and describe a system/application that will most efficiently produce a report of the top 1 million Google search requests. These are the particulars: 1) You are given 12 servers to work with. They are all dual-processor machines with 4Gb of RAM, 4x400GB hard drives and networked together.(Basically, nothing more than high-end PC’s) 2) The log data has already been cleaned for you. It consists of 100 Billion log lines, broken down into 12 320 GB files of 40-byte search terms per line. 3) You can use only custom written applications or available free open-source software.
• There is an array A[N] of N numbers. You have to compose an array Output[N] such that Output[i] will be equal to multiplication of all the elements of A[N] except A[i]. For example Output[0] will be multiplication of A[1] to A[N-1] and Output[1] will be multiplication of A[0] and from A[2] to A[N-1]. Solve it without division operator and in O(n).
• There is a linked list of numbers of length N. N is very large and you don’t know N. You have to write a function that will return k random numbers from the list. Numbers should be completely random. Hint: 1. Use random function rand() (returns a number between 0 and 1) and irand() (return either 0 or 1) 2. It should be done in O(n).
• Find or determine non existence of a number in a sorted list of N numbers where the numbers range over M, M>> N and N large enough to span multiple disks. Algorithm to beat O(log n) bonus points for constant time algorithm.
• You are given a game of Tic Tac Toe. You have to write a function in which you pass the whole game and name of a player. The function will return whether the player has won the game or not. First you to decide which data structure you will use for the game. You need to tell the algorithm first and then need to write the code. Note: Some position may be blank in the game। So your data structure should consider this condition also.
• You are given an array [a1 To an] and we have to construct another array [b1 To bn] where bi = a1*a2*...*an/ai. you are allowed to use only constant space and the time complexity is O(n). No divisions are allowed.
• How do you put a Binary Search Tree in an array in a efficient manner. Hint :: If the node is stored at the ith position and its children are at 2i and 2i+1(I mean level order wise)Its not the most efficient way.
• How do you find out the fifth maximum element in an Binary Search Tree in efficient manner. Note: You should not use use any extra space. i.e sorting Binary Search Tree and storing the results in an array and listing out the fifth element.
• Given a Data Structure having first n integers and next n chars. A = i1 i2 i3 ... iN c1 c2 c3 ... cN.Write an in-place algorithm to rearrange the elements of the array ass A = i1 c1 i2 c2 ... in cn
• Given two sequences of items, find the items whose absolute number increases or decreases the most when comparing one sequence with the other by reading the sequence only once.
• Given That One of the strings is very very long , and the other one could be of various sizes. Windowing will result in O(N+M) solution but could it be better? May be NlogM or even better?
• How many lines can be drawn in a 2D plane such that they are equidistant from 3 non-collinear points?
• Let's say you have to construct Google maps from scratch and guide a person standing on Gateway of India (Mumbai) to India Gate(Delhi). How do you do the same?
• Given that you have one string of length N and M small strings of length L. How do you efficiently find the occurrence of each small string in the larger one?
• Given a binary tree, programmatically you need to prove it is a binary search tree.
• You are given a small sorted list of numbers, and a very very long sorted list of numbers - so long that it had to be put on a disk in different blocks. How would you find those short list numbers in the bigger one?
• Suppose you have given N companies, and we want to eventually merge them into one big company. How many ways are theres to merge?
• Given a file of 4 billion 32-bit integers, how to find one that appears at least twice?
• Write a program for displaying the ten most frequent words in a file such that your program should be efficient in all complexity measures.
• Design a stack. We want to push, pop, and also, retrieve the minimum element in constant time.
• Given a set of coin denominators, find the minimum number of coins to give a certain amount of change.
• Given an array, i) find the longest continuous increasing subsequence. ii) find the longest increasing subsequence.
• Suppose we have N companies, and we want to eventually merge them into one big company. How many ways are there to merge?
• Write a function to find the middle node of a single link list.
• Given two binary trees, write a compare function to check if they are equal or not. Being equal means that they have the same value and same structure.
• Implement put/get methods of a fixed size cache with LRU replacement algorithm.
• You are given with three sorted arrays ( in ascending order), you are required to find a triplet ( one element from each array) such that distance is minimum.
• Distance is defined like this : If a[i], b[j] and c[k] are three elements then distance=max(abs(a[i]-b[j]),abs(a[i]-c[k]),abs(b[j]-c[k]))" Please give a solution in O(n) time complexity
• How does C++ deal with constructors and deconstructors of a class and its child class?
• Write a function that flips the bits inside a byte (either in C++ or Java). Write an algorithm that take a list of n words, and an integer m, and retrieves the mth most frequent word in that list.
• What's 2 to the power of 64?
• Given that you have one string of length N and M small strings of length L. How do you efficiently find the occurrence of each small string in the larger one?
• How do you find out the fifth maximum element in an Binary Search Tree in efficient manner.
• Suppose we have N companies, and we want to eventually merge them into one big company. How many ways are there to merge?
• There is linked list of millions of node and you do not know the length of it. Write a function which will return a random number from the list.
• You need to check that your friend, Bob, has your correct phone number, but you cannot ask him directly. You must write a the question on a card which and give it to Eve who will take the card to Bob and return the answer to you. What must you write on the card, besides the question, to ensure Bob can encode the message so that Eve cannot read your phone number?
• How long it would take to sort 1 trillion numbers? Come up with a good estimate.
• Order the functions in order of their asymptotic performance: 1) 2^n 2) n^100 3) n! 4) n^n
• There are some data represented by(x,y,z). Now we want to find the Kth least data. We say (x1, y1, z1) > (x2, y2, z2) when value(x1, y1, z1) > value(x2, y2, z2) where value(x,y,z) = (2^x)*(3^y)*(5^z). Now we can not get it by calculating value(x,y,z) or through other indirect calculations as lg(value(x,y,z)). How to solve it?
• How many degrees are there in the angle between the hour and minute hands of a clock when the time is a quarter past three?
• Given an array whose elements are sorted, return the index of a the first occurrence of a specific integer. Do this in sub-linear time. I.e. do not just go through each element searching for that element.
• Given two linked lists, return the intersection of the two lists: i.e. return a list containing only the elements that occur in both of the input lists.
• What's the difference between a hashtable and a hashmap?
• If a person dials a sequence of numbers on the telephone, what possible words/strings can be formed from the letters associated with those numbers?
• How would you reverse the image on an n by n matrix where each pixel is represented by a bit?
• Create a fast cached storage mechanism that, given a limitation on the amount of cache memory, will ensure that only the least recently used items are discarded when the cache memory is reached when inserting a new item. It supports 2 functions: String get(T t) and void put(String k, T t).
• Create a cost model that allows Google to make purchasing decisions on to compare the cost of purchasing more RAM memory for their servers vs. buying more disk space.
• Design an algorithm to play a game of Frogger and then code the solution. The object of the game is to direct a frog to avoid cars while crossing a busy road. You may represent a road lane via an array. Generalize the solution for an N-lane road.
• What sort would you use if you had a large data set on disk and a small amount of ram to work with?
• What sort would you use if you required tight max time bounds and wanted highly regular performance.
• How would you store 1 million phone numbers?
• Design a 2D dungeon crawling game. It must allow for various items in the maze - walls, objects, and computer-controlled characters. (The focus was on the class structures, and how to optimize the experience for the user as s/he travels through the dungeon.)
• What is the size of the C structure below on a 32-bit system? On a 64-bit?

struct foo {

char a;

char* b;

};

Google Interview: Software Engineer in Test

• Efficiently implement 3 stacks in a single array.
• Given an array of integers which is circularly sorted, how do you find a given integer.
• Write a program to find depth of binary search tree without using recursion.
• Find the maximum rectangle (in terms of area) under a histogram in linear time.
• Most phones now have full keyboards. Before there there three letters mapped to a number button. Describe how you would go about implementing spelling and word suggestions as people type.
• Describe recursive mergesort and its runtime. Write an iterative version in C++/Java/Python.
• How would you determine if someone has won a game of tic-tac-toe on a board of any size?
• Given an array of numbers, replace each number with the product of all the numbers in the array except the number itself *without* using division.
• Create a cache with fast look up that only stores the N most recently accessed items.
• How to design a search engine? If each document contains a set of keywords, and is associated with a numeric attribute, how to build indices?
• Given two files that has list of words (one per line), write a program to show the intersection.
• What kind of data structure would you use to index annagrams of words? e.g. if there exists the word "top" in the database, the query for "pot" should list that.

Google Interview: Quantitative Compensation Analyst

• What is the yearly standard deviation of a stock given the monthly standard deviation?
• How many resumes does Google receive each year for software engineering?
• Anywhere in the world, where would you open up a new Google office and how would you figure out compensation for all the employees at this new office?
• What is the probability of breaking a stick into 3 pieces and forming a triangle?

Google Interview: Engineering Manager

• You're the captain of a pirate ship, and your crew gets to vote on how the gold is divided up. If fewer than half of the pirates agree with you, you die. How do you recommend apportioning the gold in such a way that you get a good share of the booty, but still survive?

Google Interview: AdWords Associate

• How would you work with an advertiser who was not seeing the benefits of the AdWords relationship due to poor conversions?
• How would you deal with an angry or frustrated advertisers on the phone?

Sources

http://news.ycombinator.com/item?id=266663

http://tihomir.org/crazy-questions-at-google-job-interview/

http://www.drizzle.com/~jpaint/google.html

http://www.gamedev.net/community/forums/topic.asp?topic_id=299692

http://careers.cse.sc.edu/googleinterview

http://job-interview.blogspot.com/2005/02/google-interview-product-marketing.html

http://www.theregister.co.uk/2007/01/05/google_interview_tales/

http://money.cnn.com/2007/08/29/technology/brain_teasers.biz2/index.htm

http://blogs.lessthandot.com/index.php/ITProfessionals/EthicsIT/google-interview-questions

http://placementsindia.blogspot.com/2007/09/google-top-interview-puzzles.html

http://linkmingle.com/user/interview_questions/google_interview_questions

http://discuss.joelonsoftware.com/default.asp?interview.11.626758.33

http://mindcipher.com/puzzle/78-clock-works

http://www.glassdoor.com

http://bluepixel.ca/blog/?p=69

http://www.businessinsider.com/my-nightmare-interviews-with-google-2009-11

AutoCompleteBox to auto complete data entry.

I ran into a situation where, I need a way to provide a user with auto complete text box with predefined list of data. If the data already exists in the list, then user select it and continue, if the data does not contain in the list, the user data will be added to the list thus it is available for the future auto completion. It is pretty simple, if you know there is a control called ‘AutoCompleteBox’ available in the toolkit.

In my case the auto completion is part of the grid, so I will stay on the same sample to illustrate how easy to implement this. This is a very rudimentary implementation and can be improved a lot to meet your needs.

First thing we start by adding a cell edit template to the the column in question where we need to provide the auto completion. A simple XAML definition would look like the following

 1: <c1:Column.CellEditingTemplate>
 2:     <DataTemplate>
 3:          <sdk:AutoCompleteBox Text="{Binding ReferencePath,Mode=TwoWay}"
 4:                Populating="tester_Populating" MinimumPrefixLength="0" IsDropDownOpen="True" LostFocus="tester_LostFocus"/>
 5:     </DataTemplate>
 6: </c1:Column.CellEditingTemplate>

There are few important pieces in line 4. The first one is the event called ‘tester_Populating’ event. This event, will filter the data collection and return only matching values as the user types to show in the drop down.

MinimumPrefixLength to 0 will show the drop down even when there is no data entered in the text box.

IsDropDownOpen set to true will open the drop down on double click on the cell.

LostFocus event will trigger a method to check and see if the data user enter already in the list and if it is not available then add it to the collection to show in the future.

Lets look at the events implementation

tester_Populating:

 1: private void tester_Populating(object sender, PopulatingEventArgs e)
 2: {
 3:      if (_names == null)
 4:      {
 5:           _names = new List<string>();
 6:           _names.Add("Kumar");
 7:           _names.Add("Ram");
 8:           _names.Add("Krishna");
 9:           _names.Add("John");
 10:       }
 11:       List<string> data = new List<string>();
 12:       AutoCompleteBox box = sender as AutoCompleteBox;
 13:       foreach (string name in _names)
 14:       {
 15:            if (name.ToUpper().StartsWith(box.Text.ToUpper()))
 16:                data.Add(name);
 17:       }
 18:       box.ItemsSource = data;
 19:       box.PopulateComplete();
 20: }

Line 3-10 to create first time collection. Line 13-17 is where you check and see if the user input data matches any in our collection and if so, then add it to temperory collection and binding it to auto complete box. As done in line 18.

 1: private void tester_LostFocus(object sender, RoutedEventArgs e)
 2: {
 3:      AutoCompleteBox box = sender as AutoCompleteBox;
 4:      if (box.Text.Length > 0)
 5:      {
 6:          bool found = false;
 7:          foreach (string name in _names)
 8:          {
 9:              if (name.ToUpper().Equals(box.Text.ToUpper()))
 10:             {
 11:                 found = true;
 12:                  break;
 13:              }
 14:           }
 15:           if (!found)
 16:             _names.Add(box.Text);
 17:    }
 18: }

Hope this helps.

Entity Framework 4.0- Bind Stored Procedure with Result Entity class

Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of a new features which will create a new Entity class based on stored procedure result. We will use same table for this example for which they have used earlier for Linq Binding with Custom Entity.
Below is the table which have simple fields like first name,last name etc.

Let’s insert some data like following.



Below is the stored procedure which I am going to use for this example which will simply fetch data from the table.

?

1 2 3 4 5 6 7 8 9 10 11 12 13

CREATE PROCEDURE dbo.GetAllUsers AS SET NOCOUNT ON SELECT UserId, UserName, FirstName, LastName, FirstName + ' ' + LastName AS [FullName] FROM dbo.Users

Now let’s create Entity model class just like below via Project->Add New Item->Go to Data tab and then select ADO.NET Entity Data Model.

Once you click add a dialog box will appear which will ask for Data Model Contents there are two options Generate From Database and another one is Empty Model. Generate from database will create a Entity model from the ready made database while Empty model enable us to create a model first and then it will allow us to create a database from our model. We are going to use Generate From database for this example. Select Generate From Database like following and click Next.

After click on the next it will ask for database connection string like following where you need to apply connection string for that. I am already having connection string in my web.config so i just selected like below otherwise you need to create one via clicking on new connection. Also you need to specify the connection string name in web.config so it will put a connection string in connection string section with that name.

Once you click next it will fetch the all database objects information like Tables,Views and Stored Procedure like following. Here our purpose is to work with stored procedure so I just selected the stored procedure and selected the GetAllUsers Stored Procedure.

After that it will create a Entity Model class in solution explorer.Now we want to bind the stored procedure with result class so first we need to create function which will call ‘GetAllUser’ stored procedure. To create function we just need to select Our Entity Model class and then go to Model Browser and select the Stored Procedure and right click->Add Function Import like following image.

It will start a new wizard and will go to next step like following image which will have four options 1. None 2. Scalars 3. Complex 4. Entities and there will be a button Get Column information once you click it. It will gather all the column information of stored procedure result set and then click ‘Create New Complex Type’ It will create a new complex type from the gathered column information.

You can also rename that class so I have renamed the class as ‘User Info’ like following.
Now click ok and now it will create function which call the stored procedure and will return Object Result set of Type ‘UserInfo’ which we have just created. Now let’s bind that to a simple grid view to see how its works. So Let’s take a simple grid view like below.

?

1 2	<asp:GridView ID="grdUserList" runat="server"> </asp:GridView>

Now Let’s bind that grid view like following from the code behind file of asp.net like following.

?

1 2 3 4 5 6 7 8 9 10 11 12

protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (BlogEntities myEntity = new BlogEntities()) { grdUserList.DataSource = myEntity.GetAllUsers(); grdUserList.DataBind(); } } }

Just run it with Ctrl + F5 and below it the output in browser.

That’s it very easy and simple to bind complex type with stored procedure using ADO.NET Entity Framework 4.0. Hope this will help you.. Happy Programming!!!

Entity Framework 4.0- Bind Stored Procedure with Result Entity class

Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of a new features which will create a new Entity class based on stored procedure result. We will use same table for this example for which they have used earlier for Linq Binding with Custom Entity.
Below is the table which have simple fields like first name,last name etc.
Let’s insert some data like following.

Below is the stored procedure which I am going to use for this example which will simply fetch data from the table.

?

1 2 3 4 5 6 7 8 9 10 11 12 13

CREATE PROCEDURE dbo.GetAllUsers AS SET NOCOUNT ON SELECT UserId, UserName, FirstName, LastName, FirstName + ' ' + LastName AS [FullName] FROM dbo.Users

Now let’s create Entity model class just like below via Project->Add New Item->Go to Data tab and then select ADO.NET Entity Data Model.

Once you click add a dialog box will appear which will ask for Data Model Contents there are two options Generate From Database and another one is Empty Model. Generate from database will create a Entity model from the ready made database while Empty model enable us to create a model first and then it will allow us to create a database from our model. We are going to use Generate From database for this example. Select Generate From Database like following and click Next.

After click on the next it will ask for database connection string like following where you need to apply connection string for that. I am already having connection string in my web.config so i just selected like below otherwise you need to create one via clicking on new connection. Also you need to specify the connection string name in web.config so it will put a connection string in connection string section with that name.

Once you click next it will fetch the all database objects information like Tables,Views and Stored Procedure like following. Here our purpose is to work with stored procedure so I just selected the stored procedure and selected the GetAllUsers Stored Procedure.

After that it will create a Entity Model class in solution explorer.Now we want to bind the stored procedure with result class so first we need to create function which will call ‘GetAllUser’ stored procedure. To create function we just need to select Our Entity Model class and then go to Model Browser and select the Stored Procedure and right click->Add Function Import like following image.

It will start a new wizard and will go to next step like following image which will have four options 1. None 2. Scalars 3. Complex 4. Entities and there will be a button Get Column information once you click it. It will gather all the column information of stored procedure result set and then click ‘Create New Complex Type’ It will create a new complex type from the gathered column information.

You can also rename that class so I have renamed the class as ‘User Info’ like following.
Now click ok and now it will create function which call the stored procedure and will return Object Result set of Type ‘UserInfo’ which we have just created. Now let’s bind that to a simple grid view to see how its works. So Let’s take a simple grid view like below.

?

1 2	<asp:GridView ID="grdUserList" runat="server"> </asp:GridView>

Now Let’s bind that grid view like following from the code behind file of asp.net like following.

?

1 2 3 4 5 6 7 8 9 10 11 12

protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (BlogEntities myEntity = new BlogEntities()) { grdUserList.DataSource = myEntity.GetAllUsers(); grdUserList.DataBind(); } } }

Just run it with Ctrl + F5 and below it the output in browser.

That’s it very easy and simple to bind complex type with stored procedure using ADO.NET Entity Framework 4.0. Hope this will help you.. Happy Programming!!!

Entity Framework 4.0- Bind Stored Procedure with Result Entity class

Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of a new features which will create a new Entity class based on stored procedure result. We will use same table for this example for which they have used earlier for Linq Binding with Custom Entity.
Below is the table which have simple fields like first name,last name etc.
Let’s insert some data like following.

Below is the stored procedure which I am going to use for this example which will simply fetch data from the table.

?

1 2 3 4 5 6 7 8 9 10 11 12 13

CREATE PROCEDURE dbo.GetAllUsers AS SET NOCOUNT ON SELECT UserId, UserName, FirstName, LastName, FirstName + ' ' + LastName AS [FullName] FROM dbo.Users

Now let’s create Entity model class just like below via Project->Add New Item->Go to Data tab and then select ADO.NET Entity Data Model.

Once you click add a dialog box will appear which will ask for Data Model Contents there are two options Generate From Database and another one is Empty Model. Generate from database will create a Entity model from the ready made database while Empty model enable us to create a model first and then it will allow us to create a database from our model. We are going to use Generate From database for this example. Select Generate From Database like following and click Next.

After click on the next it will ask for database connection string like following where you need to apply connection string for that. I am already having connection string in my web.config so i just selected like below otherwise you need to create one via clicking on new connection. Also you need to specify the connection string name in web.config so it will put a connection string in connection string section with that name.

Once you click next it will fetch the all database objects information like Tables,Views and Stored Procedure like following. Here our purpose is to work with stored procedure so I just selected the stored procedure and selected the GetAllUsers Stored Procedure.

After that it will create a Entity Model class in solution explorer.Now we want to bind the stored procedure with result class so first we need to create function which will call ‘GetAllUser’ stored procedure. To create function we just need to select Our Entity Model class and then go to Model Browser and select the Stored Procedure and right click->Add Function Import like following image.

It will start a new wizard and will go to next step like following image which will have four options 1. None 2. Scalars 3. Complex 4. Entities and there will be a button Get Column information once you click it. It will gather all the column information of stored procedure result set and then click ‘Create New Complex Type’ It will create a new complex type from the gathered column information.

You can also rename that class so I have renamed the class as ‘User Info’ like following.
Now click ok and now it will create function which call the stored procedure and will return Object Result set of Type ‘UserInfo’ which we have just created. Now let’s bind that to a simple grid view to see how its works. So Let’s take a simple grid view like below.

?

1 2	<asp:GridView ID="grdUserList" runat="server"> </asp:GridView>

Now Let’s bind that grid view like following from the code behind file of asp.net like following.

?

1 2 3 4 5 6 7 8 9 10 11 12

protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (BlogEntities myEntity = new BlogEntities()) { grdUserList.DataSource = myEntity.GetAllUsers(); grdUserList.DataBind(); } } }

Just run it with Ctrl + F5 and below it the output in browser.

That’s it very easy and simple to bind complex type with stored procedure using ADO.NET Entity Framework 4.0. Hope this will help you.. Happy Programming!!!

Entity Framework 4.0- Bind Stored Procedure with Result Entity class

Microsoft Entity Framework version 4.0 is a brand new ORM(Object Relational Mapper) from Microsoft. It’s provides now some new features which are not there in the earlier version of Entity framework. Let’s walk through a simple example of a new features which will create a new Entity class based on stored procedure result. We will use same table for this example for which they have used earlier for Linq Binding with Custom Entity.
Below is the table which have simple fields like first name,last name etc.
Let’s insert some data like following.

Below is the stored procedure which I am going to use for this example which will simply fetch data from the table.

?

1 2 3 4 5 6 7 8 9 10 11 12 13

CREATE PROCEDURE dbo.GetAllUsers AS SET NOCOUNT ON SELECT UserId, UserName, FirstName, LastName, FirstName + ' ' + LastName AS [FullName] FROM dbo.Users

Now let’s create Entity model class just like below via Project->Add New Item->Go to Data tab and then select ADO.NET Entity Data Model.

Once you click add a dialog box will appear which will ask for Data Model Contents there are two options Generate From Database and another one is Empty Model. Generate from database will create a Entity model from the ready made database while Empty model enable us to create a model first and then it will allow us to create a database from our model. We are going to use Generate From database for this example. Select Generate From Database like following and click Next.

After click on the next it will ask for database connection string like following where you need to apply connection string for that. I am already having connection string in my web.config so i just selected like below otherwise you need to create one via clicking on new connection. Also you need to specify the connection string name in web.config so it will put a connection string in connection string section with that name.

Once you click next it will fetch the all database objects information like Tables,Views and Stored Procedure like following. Here our purpose is to work with stored procedure so I just selected the stored procedure and selected the GetAllUsers Stored Procedure.

After that it will create a Entity Model class in solution explorer.Now we want to bind the stored procedure with result class so first we need to create function which will call ‘GetAllUser’ stored procedure. To create function we just need to select Our Entity Model class and then go to Model Browser and select the Stored Procedure and right click->Add Function Import like following image.

It will start a new wizard and will go to next step like following image which will have four options 1. None 2. Scalars 3. Complex 4. Entities and there will be a button Get Column information once you click it. It will gather all the column information of stored procedure result set and then click ‘Create New Complex Type’ It will create a new complex type from the gathered column information.

You can also rename that class so I have renamed the class as ‘User Info’ like following.
Now click ok and now it will create function which call the stored procedure and will return Object Result set of Type ‘UserInfo’ which we have just created. Now let’s bind that to a simple grid view to see how its works. So Let’s take a simple grid view like below.

?

1 2	<asp:GridView ID="grdUserList" runat="server"> </asp:GridView>

Now Let’s bind that grid view like following from the code behind file of asp.net like following.

?

1 2 3 4 5 6 7 8 9 10 11 12

protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { using (BlogEntities myEntity = new BlogEntities()) { grdUserList.DataSource = myEntity.GetAllUsers(); grdUserList.DataBind(); } } }

Just run it with Ctrl + F5 and below it the output in browser.
That’s it very easy and simple to bind complex type with stored procedure using ADO.NET Entity Framework 4.0. Hope this will help you.. Happy Programming!!!