本文介绍了单列中的perticluar项的多行数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 限时删除!! 我为Goat Data开发了软件。在一份报告中我有山羊数据和她的孩子喜欢: GoatNumber1 | Child1 | ChildColor | ChildAge GoatNumber1 | Child2 | ChildColor | ChildAge GoatNumber1 | Child3 | ChildColor | ChildAge GoatNumber2 | Child1 | ChildColor | ChildAge GoatNumber2 | Child2 | ChildColor | ChildAge 我必须这样做: GoatNumber1 | Child1 | ChildColor | ChildAge | Child1 | ChildColor | ChildAge ... GoatNumber2 | Child1 | ChildColor | ChildAge | Child2 | ChildColor | ChildAge 这只能通过SQL查询来实现。 每个建议都是赞赏的。 谢谢和问候。 Firdaus Shaikh。 我有什么试过: 我用两个DataGridView实现了它,一个用于SQL数据,一个用于每个山羊的计算输出。大数据的计算部分需要5分钟以上。对于每个过滤器/更改,如出生日期,颜色等,它需要相同的时间。解决方案 I have Developed software for Goat Data. In one Report I have Data for Goat and her Childs Like:GoatNumber1 | Child1 | ChildColor | ChildAgeGoatNumber1 | Child2 | ChildColor | ChildAgeGoatNumber1 | Child3 | ChildColor | ChildAgeGoatNumber2 | Child1 | ChildColor | ChildAgeGoatNumber2 | Child2 | ChildColor | ChildAgeI Have to Do it Like:GoatNumber1 | Child1 | ChildColor | ChildAge | Child1 | ChildColor | ChildAge ...GoatNumber2 | Child1 | ChildColor | ChildAge | Child2 | ChildColor | ChildAgeCan this will be achieved by only SQL Queries.Every suggestion is Appreciated.Thanks and Regards.Firdaus Shaikh.What I have tried:I have Implemented it with Two DataGridView, One For SQL Data and One for Calculated Output for each Goat. It takes more than 5 Minutes for Calculation part for Big Data. For each Filter/Changes like Birthdates, Color etc it take Same Time. 解决方案 这篇关于单列中的perticluar项的多行数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 1403页,肝出来的.. 09-09 00:55