MSaccess表的Datagrid视图 [英] Datagrid view for MSaccess table

问题描述

如何在MSaccess表中显示数据网格视图中的选定字段。任何人都可以提供这方面的帮助。

解决方案

您是否从OriginalGriff读到了您的问题数据库Retriving Code的答案？

数据库检索代码 [ ^ ]

同样的原则适用，只需更改

 myListBox.DataSource = dt; 

to

 myDtatgridview.DataSource = dt; 

您好，

两行代码可以满足您的要求。首先，你已经在查询中写了四列，所以不需要定义列名和分配数据成员属性。





< pre lang =xml> DataTable DT = DS.Tables [0]

dataGridView1.DataSource = DT;


如果你需要隐藏一些列，那么只需编写代码
dataGridView1.Columns [Boxes]。Visible = false;

还有一点：你的查询不正确，需要更多的空间和条件。

string str =选择详情，质量，数量，来自additems的方框，其中fno =+ fn +和receiptno =+ rn +;

我希望它对你有用。

谢谢

How to display selected fields in data grid view from MSaccess table . .Can anyone help in this .

解决方案

Did you read the answer from OriginalGriff to your Question "Database Retriving Code"?
Database retriving code[^]
Same principle applies, just change

myListBox.DataSource = dt;

to

myDtatgridview.DataSource = dt;

Hi,
Two line code is ok for your requirement. first all you are already write four column in your query so don't need define column name and assign data member property.

DataTable DT = DS.Tables[0]

    dataGridView1.DataSource = DT;


if you need hide some column so just write the code
dataGridView1.Columns["Boxes"].Visible = false;

one more point: your query is not correct, need more space before and condition.

  string str = "select particulars,quality,quantity,boxes from additems  where fno=" + fn + " and receiptno=" + rn + ""; 

I hope that it is useful for u.

Thanks

这篇关于MSaccess表的Datagrid视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！