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?
Loading
Vilas GitePosted Jun 25, 2011, 9:44 AM
you need to index on that particular coloumn. please refer below link for syntax of Index in sql server.
http://www.w3schools.com/sql/sql_create_index.asp
----------
If this reply hepls your post…then "MARK AS ANSWER"!