数据库中的动态行和列 [英] dynamic row and column from DB

问题描述

你好，

我在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 ?

这篇关于数据库中的动态行和列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！