如何根据某些条件在datagridview中显示 [英] how to display in datagridview depending on some criteria

问题描述

我有1个表工厂，它有lot_no，group，type，shape，description，件，weight_given，issue_dt

作为列

和另外1个表名facsort有lot_no，group，type，shape，description，pieces，weight_given，issuedt，wt_return和return dt as columns。



现在我想在gridview中只显示那些数据其返回日期尚未输入数据库。



即已签发日期但未在退货日期退回石头。



这是给出但未退回的宝石。



任何人都可以帮助我。



i将有义务。



提前感谢。

i have 1 table factory which has lot_no,group,type,shape,description,pieces,weight_given,issue_dt
as columns
and another 1 table name facsort which has lot_no, group,type,shape,description,pieces,weight_given,issuedt,wt_return and return dt as columns.

now i want to display in gridview only those data whose returned date has not been entered in database.

that is date has been issued but the stones are not returned on return date.

that is which are the stones given but not returned.

can anyone please help me.

i will be obliged.

thanks in advance.

推荐答案

IT IS简单，你写下SQL SELECT QUERY CODE并运行它，你将得到你想要的数据。现在在DATAGRID展示它。简单如此。

IT IS SIMPLE, YOU WRITE DOWN THE SQL SELECT QUERY CODE AND RUN IT, YOU WILL GET THE DATA YOU DESIRED. NOW DISPLAY IT IN THE DATAGRID. AS SIMPLE AS.

这篇关于如何根据某些条件在datagridview中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！