如何区分同一表中的信息 [英] how to differentiate information in the same table

问题描述

大家好
我在这里有一张桌子，我存储了所有向内和向外的文件.在这种情况下，我具有i字段事务类型"的意思(向内/向外)，但是我只想访问DataGridView中的向内文档.我如何才能访问plz告诉我的代码的唯一向内或向外文档.我糊涂了.请一些身体帮助我.请
以下是我的TransactionMaster表中的字段.

TransactionId
CreateFor
CreateBy
主题
留言
DocNumber
AttachmentPath
AttachmentType
TransactionType
CreatedDate
ToBeReplyDate
RepliedDate
NumberOfReminders
Status

Hello all
i have a 1 table in this i were store the all the inward and outward documents. and in this i have the i field Transaction Type means (inward/outward)but i want to access only inward document in DataGridView. how can i access the only inward or outward documents plz tell me code. i m confused. plz some body help me. plz.
the following are the field in my TransactionMaster Table.

TransactionId
CreateFor
CreateBy
Subject
Message
DocNumber
AttachmentPath
AttachmentType
TransactionType
CreatedDate
ToBeReplyDate
RepliedDate
NumberOfReminders
Status

推荐答案

如果您不知道该怎么做，那么我认为这是无偿的作业，因为答案的确是最基本的.您编写的SQL仅选择要查看的值，例如

从mytable中选择*，其中transansactiontype = x

如果有，您应该与您的老师交谈；让有薪给您的人承认您被薪给后，您将无法完成这项工作；或者，如果您想自学，请选择一个更基本的任务.

If you don''t know how to do this, then I assume this is unpaid homework, because the answer really is as basic as it gets. You write SQL that selects only the values you want to see, such as

select * from mytable where transansactiontype = x

You should talk to your teacher if you have one, admit to the person paying you that you can''t do this work if you''re being paid, or choose a more basic task if you''re trying to teach yourself.

这篇关于如何区分同一表中的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！