title: Reducing database round trip
body: <p>I have an option in my application where some data has search based on the text which input in a textbox.</p>
  
  <p>So I do perform search (Call a stored procedure which take string as input) on textbox <code>text- change</code> event. </p>
  
  <p>I have reading an article about <a href="http://msdn.microsoft.com/en-us/library/ff647768.aspx" rel="nofollow">Improving ADO.NET Performance</a> where I found reducing round trip to database can increase performance.</p>
  
  <p>Is there any better approach for these kinds of situations?</p>