 |  |  |  |  |  |  |  |
change the name of the fieldname
Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site
 |
I have a button and on the click of that button i want to change a the name of few fielnames of Ms access table In Vb.net coding.
There's no RENAME in SQL. AFAIK the only way to rename field name in Access table is to first DROP field then add field (ALTER). With SQL Server you can rename fields with a stored procedure.
So the options left are:
1) change the field name manually
2) leave the field name as it is and when you read (SELECT) from the table use an alias for the field name
So the options left are:
1) change the field name manually
2) leave the field name as it is and when you read (SELECT) from the table use an alias for the field name
Teme64 @ Windows Developer Blog
|
Similar Threads
- most urgent (Visual Basic 4 / 5 / 6)
- How to use fieldname in 'if' condition ? (VB.NET)
- Changing a datagridview's combobox items based on another combobox (C#)
- Will the jsp code will change if we connected to the oracle database ? (JSP)
- can i use mysql database with asp (ASP)
- Database question.. Can someone help... (Database Design)
- E-mail form data quick and easily with PHP (PHP)
- Need Help Creating a Search Page (ColdFusion)
Other Threads in the VB.NET Forum
- Previous Thread: help with this code
- Next Thread: problem in dropdownlist
Views: 602 | Replies: 1
| Thread Tools | Search this Thread |
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for VB.NET
.net .net2008 2005 2008 access account application array arrays basic beginner browser button buttons center checkbox client code convert cuesent data database datagrid datagridview date datetimepicker design designer dissertation dissertations dissertationtopic eclipse excel fade filter forms generatetags gridview html images input insert intel internet lib listview mobile monitor net objects open panel passingparameters pdf picturebox port position print printing problem read remove richtextbox save searchvb.net select serial settings shutdown sorting sqlserver studio survey table temperature textbox time timer timespan transparency update user validation vb vb.net vb.netformclosing()eventpictureboxmessagebox vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winforms wpf wrapingcode year
