I want help in grid view

See more:

C#

ADO.NET

1-At the start of the code sheet must fill the combo box with the list of members (the code).

2-The choice of a code, information about the member in particular the number of penalty and borrowing being displayed and a gate charge of all loans not yet returned by that Participant (NUMEMP, CODOUV, DATEMP, NbrJourPassé).

3-The choice of a row in the grid and click on the OK button saves the return of the selected item, with a return date equal to the system date

the firste question I have this code

AD.Fill(DS.ADHERENTS);

comboBox1.DataSource = DS.Tables["ADHERENTS"];

comboBox1.ValueMember = "CODE_ADHERENTS";
comboBox1.DisplayMember = "CODE_ADHERENTS";

in the 2 question i had storedprocuder but i dont knon how i used ; this is the requetes of the procedure

SELECT     dbo.EMPRUNTS.CODE_EMPRUNTS, dbo.EMPRUNTS.CODE_ADHERENTS, dbo.EMPRUNTS.CODE_OUVRAGES, DATEDIFF(day,DATE_EMPRUNTS,getdate()) as NBRJOURPASSé, 
                      dbo.OUVRAGES.EMPRUNTE
FROM         dbo.EMPRUNTS INNER JOIN
                      dbo.OUVRAGES ON dbo.EMPRUNTS.CODE_OUVRAGES = dbo.OUVRAGES.CODE_OUVRAGES

the 3 i dont know how