通过管理端将新列动态添加到sql表 [英] To add new columns dynamically to sql table via admin side

问题描述

您可能已经猜到了，我想通过管理端向sql表动态添加新列(用于将来的季度).考虑提供一个文本框(列名)，下拉列表(可能的子类型)和添加按钮，这些按钮基本上将添加该列.我想要 可以在asp.net c#中执行此操作.

---

Nasirkhan

As you could have guessed, I want to add new columns dynamically (for future quarters) to sql table via admin side. Thinking of providing a text box (column name), drop down (subtypes possible) and add button which will basically add the column. I want to do this in asp.net c#.

---

Nasirkhan

推荐答案

您似乎想获得有关C#代码添加列的帮助；在表格旁，我建议您在C#开发人员论坛中查询，位于:

As you appear to want help with C# code to add col;umns to a table, I suggest you ask in the C# developer forums, found here:

http://social.msdn.microsoft.com/Forums/en-US/category /visualcsharp

您还可以通过在MSDN( http://msdn.microsoft.com )中搜索更改表C#"来找到可能有用的示例. ;.

You can also find potentially useful examples by searching MSDN (http://msdn.microsoft.com) for "alter table C#".

http://msdn.microsoft.com/en -us/library/microsoft.sqlserver.management.smo.table.alter.aspx

http://forums.asp.net/t/963372.aspx

这篇关于通过管理端将新列动态添加到sql表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！