且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在vb.net中的现有Access数据库表中添加列?

更新时间:2023-02-03 16:10:55

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



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

如何通过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.