 |  |  |  |  |  |  |  |
change the name of the fieldname
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
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
| Thread Tools | Search this Thread |
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for VB.NET
.net 2005 2008 access account application arithmetic array arrays basic bing button buttons c# center check checkbox code combobox component convert crystalreport data database datagrid datagridview date dissertation dissertations dropdownlist excel fade file-dialog ftp generatetags google gridview hardcopy images inline input insert intel internet listview mobile monitor ms net networking objects output passingparameters peertopeervideostreaming picturebox picturebox1 port print printing problem problemwithinstallation project remove save searchbox searchvb.net select serial server shutdown soap sorting survey table tcp temperature text textbox timer toolbox trim update updown user validation vb vb.net vb.netcode vb.netformclosing()eventpictureboxmessagebox vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web winforms wpf
