如何使用vb.net代码从sql server表访问必填字段 [英] how to access the required fields from sql server table using the vb.net code

问题描述

您好，先生/女士
我有一个关于我的项目的查询.我的项目是保留进出文件的记录.在这种情况下，我只有一张桌子可以记录内向和向外的记录.但是现在我要2在datagridview的1个表单上访问内部文档，而在另一个表单上访问外部文档.在此表中，TransactionType字段可用于标识文档类型.请给我答案.

Hello sir/Madam
i have a 1 query regarding my project. my project is to keep record of inward and outward documents. in this i have only one table to keep record for inward and outward. but now i want 2 access the inward document on 1 form in the datagridview and the outward documents on another form. in this table the TransactionType field is available to identify document type. plz give me the answer.

推荐答案

仅获取内部文档:

To get only inward documents:

SELECT *
FROM Documents
WHERE TransactionType = Inward

要仅获取外部文件:

To get only outward documents:

SELECT *
FROM Documents
WHERE TransactionType = Outward

如何获取数据?使用 ADO.NET [

How to fetch data? Use ADO.NET[^]

这篇关于如何使用vb.net代码从sql server表访问必填字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！