窗体应用的数据绑定问题

Question

标签控件能不能直接绑定具体的数据？ 例如我在SQL数据库里存有用户的地址信息，在给标签绑定数据时，建立新查询：select 地址信息 from user.dbo where 用户名='张三'，但是系统总是说：新查询所返回的架构与基查询不同。

是不是标签控件只能绑定一列而不能绑定具体的信息？如果我想显示具体的信息怎么绑定，而且我需要绑定的信息还是实时更新的？

求各位帮帮忙！

Answer 1

标签控件只允许对某个数据源的某个字段进行绑定，而不是绑定这个数据源。

如果你要绑定一批数据，用dataGridView+Timer（实时更新）。

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Answer 2

我不是要绑定一批数据，而是用一个标签实时显示数据库里的特定信息。例如用一个标签实时显示数据库里某一产品的数量，该怎么绑定？

Answer 3

label1.DataBindings.Add("Text",SomeDataTable,"字段名");

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Answer 4

这种绑定是绑定的整个字段吧，我是想要字段里的特定数据。例如在商品数量字段里有鞋子的数量、衣服的数量等，怎样让标签只显示商品数量字段里的鞋子的数量？

Answer 5

不能。你只能通过SqlCommand执行一个汇总的SQL语句，然后使用ExecuteScalar方法得到结果，赋值给该Label。

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Answer 6

那怎么对数据进行实时更新啊？比如商品的数量是要实时更新的。

Answer 7

那怎么对数据进行实时更新啊？比如商品的数量是要实时更新的。

使用Timer每隔一定时间读取数据表的数据，（SqlCommand+DataReader）。

---

If you think one reply solves your problem, please mark it as An Answer, if you think someone's reply helps you, please mark it as a Proposed Answer

Help by clicking：
Click here to donate your rice to the poor
Click to Donate
Click to feed Dogs & Cats

Answer 8

这个是数据层抛出的异常，你的table adapter写得有bug，结果集和table里面定义的不符，和你数据绑定不绑定没关系。

用table adapter把结果存到data table的话，做不到实时更新，ado.net dataset是为离线数据而设计的。关于如何处理产品数量的同步，去搜索Offline Concurrency Pattern

---

---

Visual C++ MVP