如何以2种形式区分客户和供应商 [英] How do I differentiate between customers and suppliers in 2 forms

问题描述

我在一个迷你项目上工作，但是当问题我只为供应商和客户制作一张桌子时就停止了，因为我已经用这种方式分析了数据库，但我想把它们中的每一个都带到一个不同形式你怎么能帮助我？注意：使用linQ连接数据库

I work on a mini-project, but stopped when the problem i made ​​only one table for suppliers and customers, because I've analyzed the database this way but I want to bring each and every one of them in a different form how do can you help me? Note: Use linQ to connect with database

推荐答案

据推测，您已在该字段中添加了一列，以便您区分供应商和客户。如果你没有，那么计算机永远无法分辨，所以你最好希望你拥有它！



如果你有，那么只使用一个WHERE子句来选择基于您在列中设置的值的记录......





你能帮我写一个简单的代码吗？澄清？

[来自评论发布的解决方案，现已删除]





对不起，但没有 - 我不知道你的数据库是什么样的，更不用说你存储的数据了！

你现在有什么？到目前为止你做了什么？

Presumably you have added a column in the field which allows you to differentiate between suppliers and customers. If you haven't, then the computer can never tell, so you had better hope you have!

If you have, then just uses a WHERE clause to only select records based on the value you set into the column...


"Can you help me making a simple code for clarification؟"
[From comment posted as a solution, now deleted]


Sorry, but no - I have no idea what your database looks like, let alone what data you have stored in it!
What have you got at the moment? What have you done so far?

这篇关于如何以2种形式区分客户和供应商的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！