我想在网格视图中获得帮助 [英] I want help in grid view

问题描述

1 - 在代码表的开头必须用组件列表（代码）填充组合框。



2 - 代码的选择，有关会员的信息，特别是显示的罚款和借款数量，以及该参与者尚未归还的所有贷款的门费（NUMEMP，CODOUV，DATEMP，NbrJourPassé）。



3 - 选择网格中的一行并单击确定按钮可保存所选项目的返回，返回日期等于系统日期



第一个问题我有这个代码

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";

在2个问题中，我曾经存储过，但我不知道我是如何使用的;这是程序的重新发布

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

3我不知道如何

the 3 i dont know how

推荐答案

我不知道我如何使用程序对gridview充电

i dont know how i gate charge the gridview with the procedur

我有一个存储过程在sql server中我想用这个storedprocedur充电一个gridview ..问题是怎么样？

I have a storedprocedure in sql server and i want charge a gridview with this storedprocedur .. The question is how ?

这篇关于我想在网格视图中获得帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！