How to Display Data from Sql Server 2000 in windows application

Question

Hi all,im back with yet another problem,i have three tables in my database : customer_info,dealer_info,client_info.I developed a form(Windows application),which includes 3 gridview controls displaying data of 3 tables..The problem is tht i need to display data of 3 tables simultaneously as i type my query into a textbox...hope ppl undertsand my problem and waiting eagerly for a response...Tahnks in advance.