How to rename columnnames in a table in .NET

[Guest]

Hi,

I would like to know if there is any way to rename a column in a table in
access database using .Net programmatically.

Thank you

 

[Cor Ligthert [MVP]]

Jayashri,

AFAIK you can use the SQL Alter Table, how far it is supported in Access is
something I don't know, however I assume it would go.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp

I hope this helps,

Cor

 

[clintonG]

Its done using ADOX (as I've done using ASP) but I don't know how to use
ADOX via ADO/ASP.NET yet. I do know ADOX is documented at MSDN and more can
be found by searching the web.

--
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/