如何创建动态SQL表ASP.NET?

时间:2022-08-19 03:42:33

I am trying to create a website using ASP.NET, Microsoft SQL and C#. I am creating a food recipe site where the users can upload their own recipes. In the recipe submitting form there are the ingredients section and the steps section. The data collected in the form is sent to a SQL DB table. However the number of steps and ingredients is indefinite. So how to I add it to the table. Is it possible to create a dynamic table. Any kind of help is much appreciated.

我正在尝试使用ASP.NET,Microsoft SQL和C#创建一个网站。我正在创建一个食品配方网站,用户可以上传自己的食谱。在食谱提交表格中有成分部分和步骤部分。表单中收集的数据将发送到SQL DB表。然而,步骤和成分的数量是无限的。那么如何将它添加到表中。是否可以创建动态表。任何形式的帮助都非常感谢。

PS. I know this question may sound stupid to many developers out there but I'm still a newb. thanks :)

PS。我知道这个问题听起来对很多开发人员来说都很愚蠢,但我还是个新手。谢谢 :)

1 个解决方案

#1


0  

Think about redesigning your database. If you have columns for each step, that could be a design flaw. Think about how you can avoid the problem altogether by using a different database design.

考虑重新设计数据库。如果每个步骤都有列,那可能是一个设计缺陷。想想如何使用不同的数据库设计完全避免这个问题。

#1


0  

Think about redesigning your database. If you have columns for each step, that could be a design flaw. Think about how you can avoid the problem altogether by using a different database design.

考虑重新设计数据库。如果每个步骤都有列,那可能是一个设计缺陷。想想如何使用不同的数据库设计完全避免这个问题。