Member Avatar for kinv001

hi anyone who can help me with this project?
<EMAIL SNIPPED>

Please see the attachment

Assign2.doc (28 KB)
Edited by peter_budo because: Removing email from old post
  • 9 Contributors
  • 12 Replies
  • 431 Views
  • 5 Years Discussion Span
  • Latest Post Latest Post by AndreRet

Dani AI

Generated

Practical, short add‑on for this VB/Access thread: two reliable patterns cover add/update/delete in VB.NET — (1) parameterized OleDbCommand for single-row operations, and (2) OleDbDataAdapter + DataSet (with an OleDbCommandBuilder or explicit commands) for data‑bound UIs and batch updates. This note complements the original attachment from and the later question from ; it also follows and ’s guidance to show code and errors when asking for help. Update data sources with DataAdapters. (learn.microsoft.com)

A minimal, safe single‑row update (use parameterized queries and positional parameters — OleDb uses ? placeholders, so parameter order matters):

Dim connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\MyDb.accdb;"
Using cn As New OleDbConnection(connStr)
    Using cmd As New OleDbCommand("UPDATE MyTable SET Name = ?, Email = ? WHERE ID = ?", cn)
        cmd.Parameters.Add("Name", OleDbType.VarWChar).Value = txtName.Text
        cmd.Parameters.Add("Email", OleDbType.VarWChar).Value = txtEmail.Text
        cmd.Parameters.Add("ID", OleDbType.Integer).Value = Integer.Parse(txtID.Text)
        cn.Open()
        Dim rows = cmd.ExecuteNonQuery()
    End Using
End Using

See the ADO.NET guidance on parameters and the requirement that OleDb parameter placeholders are positional. Configuring parameters and parameter data types. (learn.microsoft.com)

For grids or bulk edits use a DataAdapter: da.Fill(ds) → edit ds.Tables("X") → da.Update(ds). An OleDbCommandBuilder can generate INSERT/UPDATE/DELETE if the SELECT returns a single table with a primary key; otherwise set InsertCommand/UpdateCommand/DeleteCommand explicitly. Watch AcceptChangesDuringUpdate and handle RowUpdated for concurrency and autoincrement retrieval. OleDbCommandBuilder class. (learn.microsoft.com)

Common pitfalls to note: “Provider not registered” or no effect on updates is often a driver / bitness issue — Jet/ACE drivers are architecture‑specific (install the matching Access Database Engine or target x86/x64 accordingly), and ACE may not be available on some server/hosted environments. When requesting help include the exact connection string (mask passwords), the Access file type (mdb/accdb), target platform (x86/x64), .NET version, table schema (primary key), and the full exception text. See Microsoft notes on Jet/ACE driver bitness. (learn.microsoft.com)

Recommended Answers

All 12 Replies

Member Avatar for wchitamb

Did yu get the help for the project or yu are still stuck?? Let me know if yu still need help

Member Avatar for Comatose

Ok.

Let me just reiterate that we DO NOT do homework assignments for people. If you are putting forth a strong amount of effort, and are stuck on a problem, we will gladly help you overcome such a situation. Once you start on the project, upload the code, and I'll be glad to look at it for you.

Member Avatar for wchitamb

BELOW IS MY ORIGINAL MESSAGE!!

Did yu get the help for the project or yu are still stuck?? Let me know if yu still need help

let me just explain i said did yu get some help this does not mean doing the project for the person thus why i even stress that if yu still stuck. someone cannot be stuck without giving it a try first.

I know we do do pple's homework or projects because at the end of the day they wont gain anything that wont benefit them we will be doing them no good.

Thankx anyway!!! This will help other pple in case they did not know.

Member Avatar for Comatose

Which is exactly why I posted it. I was never infering that you intended to do the assignment for him, so much as I was unsure if he was expecting someone to write it for him. Anyway, thanks for the clarification for the benefit of other viewers.

Member Avatar for w00dy

I checked, and Kinv001 actually started a new thread a week later, had made a good effort but got stuck, and got some help from a couple of members.

I wouldn't do peoples homework for them either, what I do is test them by saying something like "what have you done so far? Post your code", to see if they have made an honest attempt before getting stuck. If its a freeloader, that stops them dead.
If they deserve it, I will try to help.

Member Avatar for Comatose

*Nods*

That adds tact to a touchy situation. A lot of times, people post here, expecting someone to do their assignments. I've even been asked to help someone who was taking a final examination at the very moment.... W00dy has shown a very elegant way of making sure they are putting forth honest effort.

Member Avatar for w00dy

Thanks for the compliment, Comatose, have a good day!

Member Avatar for mjdesai16

hi
iam doing an asignment in VB .NET and iam able to add, delete and search my records but i dont have a code to edit my records can anyone help me in this please iam using ms access as my database

Member Avatar for gmchun83

I came here to find coding and learn.We are expect that to learn coding and not learn about your website problem.It is waste our time for register and login.Then see all this trash...

Regards,
Wallace Goh.

Member Avatar for vickyfunyy

hey plz,give me some help on above topic.....

Member Avatar for krizza

hey guys,,,,,,,,,,,,,,anyone ho can help me with this assignment,,,,,,,,,i find 8 difficult,,,,,,,,,,,,

Member Avatar for AndreRet

Krizza, we do not do others homework here!!!

If you would have done some effort of your own and read the other posts, you would have seen that we just do not do it.

If you have a question, then ask it by opening your own thread/post. Show us what you have done, where you are getting errors etc. and we will gladly assist.:)

Please read our posting rules HERE .

Edited by AndreRet because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.