数据库中的动态行和列

本文介绍了数据库中的动态行和列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好， 我在Excel中的质量和样式之间有关系.水平列线代表各种品质和垂直图案.这种关系是多对多的.我需要将Excel推入数据库，然后使用C#提取数据.请建议是否可以使用datagrid.这里的问题是行和列都不固定.以及找到质量和图案之间关系的逻辑. 谢谢 Amit

Hello, I have relation between quality and pattern in excel. Horizontal columns line represents various qualities and vertical patterns. The relationship is many to many. I need to push the excel into DB and then fetch the data using C#. Please suggest whether it will be possible using datagrid. Problem here is both the rows and columns are not fixed. And the logic to find the relation between the quality and pattern. Thanks Amit

推荐答案

一个数据网格将显示一个数据表，该数据表可以是任何SQL查询的结果.可以使用两个网格创建一个主视图/详细视图.您剩下的问题毫无意义，我们怎么能告诉您在不了解架构和需求的情况下遍历数据? A datagrid will show one table of data, which can be the result of any SQL query. A master/detail view can be created with two grids, which may be what you want. the rest of your question makes no sense, how can we tell you to traverse your data without knowing the schema and your requirements ?