From Listbox the Faculty code goes to form2 dsiplay in DGV

Question

 Data base as follows;

 SNO                Int

 Faculty_Code       Varchar

 Faculty Name       Varchar

 SNO    Faculty_Code  Faculty Name Table name(Faculty Details)

 

 1       GS                   G sekar

 2       VB                  V Bala    

in this table faculty code data are stored here.

Form1 Design

Listbox1     Button      Listbox2

GS             ADD         GS

VB                              VB

in listbox when i click load button all  Faculty_Code  is retrived from the data base and display in to the Listbox1.

when i lcik the ADD button form the Listbox1 Faculty_code goes to Listbox2.

I have one  button  called  Draw Schedule when i click that button the Faculty_Code(from the Listbox2    Faculty_Code ) goes to another Form2, in the data grid view in column that FAculty_Cod to be displayed.

Form2 design

Date       Period   Column name   column name column name  (in data grid view)

13/1 2013    1

13/1 2013    2     

Ouput asfollows;

Date        Period      GS  VB (the column name  is retrieved from  Faculty Details table,from   Listbox2 Form1  ) in data  grid view.         

13/1 2013    1

13/1 2013    2 

how to do.please send the code.