如何在vb.net中的现有Access数据库表中添加列？ [英] How do I add a column to an existing Access database table in vb.net?

问题描述

我是vb.net的新手，但我有使用Access vba的经验。我需要帮助代码将列添加到现有的Access数据库表。有人可以为我提供代码的开头或引用我的代码示例。我有三本vb.net书籍，我找不到代码的示例来更改或更新visual basic.net中的现有Access数据库表。感谢您提供的任何帮助。

解决方案

我找到了一些资源供您查看：



来自此帮助论坛的一个较旧的问题，其答案是：

如何通过C＃中的数据表向数据库添加列（MS Access） [ ^ ]

（那里没有太多的C＃）



来自Microsoft ASP.NET论坛的一个问题，答案是：

http：//forums.asp .net / t / 1520021.aspx？添加+列+到+一个+现有+ Ms + Access +数据库+永久+ [ ^ ]

（不是特定于ASP.NET）



Codeproject文章：

使用vb.net在运行时动态添加访问数据库列 [ ^ ]

（虽然它似乎做你想要的东西但它得到了upvotes，对我来说它看起来喜欢它有点过于复杂了。）



请查看是否有帮助，如果不成功，请发布另一个问题并解释您的具体问题

I am new to vb.net, but I have experience with Access vba. I need help with the code to add a column to an existing Access database table. Can someone provide me with a start on the code or refer me to a code example. I have three vb.net books and I cannot find an example of the code to either alter or update an existing Access database table in visual basic.net. Thanks for any help you may be able to provide.

解决方案

I found some resources for you to take a look at:

An older question from this help-forum with an accepted answer:
how to add a column to a database (MS Access) through Datatable in C#[^]
(There's not much C# in there)

A question from the Microsoft ASP.NET forums with an accepted answer:
http://forums.asp.net/t/1520021.aspx?Add+columns+to+an+existing+Ms+Access+database+permanently+[^]
(It isn't specific to ASP.NET)

A Codeproject article:
Dynamically add access database columns at runtime using vb.net[^]
(While it seems to do what you want and it got upvotes, to me it looks like it's overcomplicating things a bit.)

Please have a look if that helps and if you don't succeed, please post another question with an explanation of your specific problem.

这篇关于如何在vb.net中的现有Access数据库表中添加列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！