使用VB.NET的SQL Server 2005 [英] SQL Server 2005 with VB.NET

问题描述

嗨我请在表A2中的数据库Final中有一个表，它包含有关客户订单的一些信息，因此客户可以在同一列中重复多次。 。

我想读这个表中的所有这些行（Client是列的名称）....



如果此客户端的编号已经重复，那么我想在列表框中添加另外两个名为（IDD和IDR）的列，这与该客户的编号相关





和谢谢你...... :)：D





如何读取这些相似的行并将其添加到列表框中

Hi Please i have a table in my database "Final" in the table "A2" and it contains some informations about clients orders so a client can be repeated in the same column many time ...
And i want to read all these rows in this table ("Client" is the name of the column) ....

If the number of this client has been repeated, so i want to ADD two other columns named ("IDD" and "IDR") in a listbox witch is related to this client's number


AND THANK U .... :) :D


How To read these similar rows and add it in the listbox

推荐答案

您可以查询数据，在其中，您可以计算具有多个条目的客户端。获得计数后，您可以对数据执行任何操作。

You can query the data and in it, you can count for the clients which have multiple entries. Once you get the count, you can do whatever you want to do with that data.

这篇关于使用VB.NET的SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！