Dim cmd As new SQLCommand Dim dt As DataTable '= DataTables("合同明细_table1") cmd.C Select Case e.sender.name Case "未发货" cmd.CommandText = "Select * Fr om {合同明细} Where [合同编号] not In ( Select 合同编号 Fr om {发货明细} Where 合同编号 Is not Null)" dt=cmd.ExecuteReader()