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