Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 16219 | Replies: 6
 |
•
•
Join Date: Nov 2004
Posts: 13
Reputation: 
Rep Power: 5
Solved Threads: 0
Newbie Poster
i have a mock site im working on in asp.net/vb.net using an access database. after employees log in they can update there employee profile by filling out a form. i need to know the code for updating an access DB with vb.net from the form fields. im lookin for the syntax on the SQL string and the execute commands afterwards. could someone help me with this or perhaps show me your code for some ideas to point me in the right direction?
also, what would be a good DB to use online? i know access well but i've heard that it doesnt work well online because only one person can access the DB at a time. any free DB's out there that i can scoop?
also, what would be a good DB to use online? i know access well but i've heard that it doesnt work well online because only one person can access the DB at a time. any free DB's out there that i can scoop?
•
•
Join Date: Dec 2004
Posts: 1,592
Reputation:
Rep Power: 7
Solved Threads: 35
You're asking for a lot. You collect your form data from the properties of the various server controls. The syntax for SQL is the same regardless of the underlying database, more or less. MySQL is a good server-side database program.
If you are completely new to data-drive web development, then you need to break things down into discrete steps.
1) Connect to a database, retrieve information, display it on a page. That will teach you how to interact with your database.
2) Build a form with server controls. When the user submits a form, gather the information and post it back to the user. That will teach you how to gather form data.
3) Put it all together.
If you are completely new to data-drive web development, then you need to break things down into discrete steps.
1) Connect to a database, retrieve information, display it on a page. That will teach you how to interact with your database.
2) Build a form with server controls. When the user submits a form, gather the information and post it back to the user. That will teach you how to gather form data.
3) Put it all together.
•
•
Join Date: Nov 2004
Posts: 13
Reputation:
Rep Power: 5
Solved Threads: 0
Newbie Poster
prob should have been a little more clear with my question. i was just looking for the syntax for an UPDATE with sql (which if i just took 2 seconds i could find myself because i did :cheesy: ) the only question i have now is with a SELECT query i would run ExecuteReader() but this doesn't seem to be right with an update. is there another execute to use?
•
•
Join Date: Dec 2004
Posts: 1,592
Reputation:
Rep Power: 7
Solved Threads: 35
Oh. Yep, you use .ExecuteNonQuery().
•
•
Join Date: Nov 2004
Posts: 13
Reputation:
Rep Power: 5
Solved Threads: 0
Newbie Poster
pimp, thanks again tgreer
•
•
Join Date: May 2008
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi,
I have a form in which i want to update data if there is a repeated data in tne table. the table is in access, and i use: vb.net2003.
but i recieve the syntax error in update command. will you please help me:
i put cname and network as key in the table.
thx
I have a form in which i want to update data if there is a repeated data in tne table. the table is in access, and i use: vb.net2003.
but i recieve the syntax error in update command. will you please help me:
ASP Syntax (Toggle Plain Text)
thx
Last edited by peter_budo : May 24th, 2008 at 8:20 pm. Reason: Keep It Organized - please use [code] tags
•
•
Join Date: Dec 2003
Location: Nashville, TN
Posts: 2,336
Reputation:
Rep Power: 12
Solved Threads: 102
•
•
•
•
Originally Posted by azaran2oo2 
Hi,
I have a form in which i want to update data if there is a repeated data in tne table. the table is in access, and i use: vb.net2003.
but i recieve the syntax error in update command. will you please help me:
objCmd = New OleDbCommand("UPDATE Table1 WHERE (cname=" & txtcname.Text & " AND network=" & txtnet.Text & ")) set(usb=" & txtusb.Text & ",cd=" & txtcd.Text & ",position=" & txtpos.Text & ",", New OleDbConnection(cmd))
i put cname and network as key in the table.
thx
Hi,
Start your own thread with this question. That way, you'll get the information that you require, and you won't muddle up someone else's thread with a question that might not be directly related...
Alex Cavnar, aka alc6379
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
