how to insert rollnumber of a student like 04331A1209 (alfa numeric) into database and searching for that number in c#

Question

hi friends,

               I have a  roll number 04331A1209 which is alfa-numeric . so I want this kind of  numbers  to be inserted into database .

 if I want a particular students details which has to  be searched based on the roll-number .so please explain me how to do that searching in c# language.

ex :                                                               ------------
      please enter roll no.   04331A1209    | search |
                                                                     ------------
 after clicking search button then the students details has to be printed in detailsview..

thanks in advance

 chiranjeevi