how to find disticnt record to bind dropdownlist??
                            
                         
                        
                     
                 
                
                    Dear members
                        i have a page where i m inserting multiple records with same name like (ShortName) and a ShortNameID which is auto generated according to date now i want to show it another page with distinct name with thier  ShortNameID