datagridview

Question

     hai,

In my windows form one datagridview with sno,itemcode,itemname,unit,qty,price,value.
 When we enter the firstletter of the itemcode i want to display the corresponding Itemcode values from the databse displayed and also display the itemname of the itemcode which itemcode we selected.

also when we enter the first letter of the itemname ,to display the cooresponding names from the databse and display the corresponding itemcode which itemname we select.
how we do this ? plz help?