Read/Update to Access DB

Question

0.00/5 (No votes)

See more:

Hi guys,

I'm working on simple database programming using C# and MS Access. Well i'm very new to database kind of stuffs.

My DB:

Student Table
ID FIRST_NAME LAST_NAME ADDRESS CONTACT_NO. EMAIL_ADD

My questions:
1)What is the most efficient way to read/update the table in access db?
2)I need to search according to the ID, how I need to search in the db?Do I need to load the table to DataSet and do the searching or else?
3)After search, I will EDIT the columns, and how to UPDATE that particular COLUMN of that particular ROW.

Maybe some of you might think that this question looks sort of "spoon-feeding", if that so, kindly suggest me some good websites which you guys came across as a good place to learn DB stuffs.

My search couln't help me to find a good answers for this.

Thanks.
Skunkhead :)

Posted 30-Jan-11 15:35pm

skunkhead

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yusuf · Answer 1 · 2011-01-30T15:49:00

Solution 1

1. There are many articles on CP http://www.codeproject.com/KB/database/#ADO.NET[^], for example Using ADO.NET for beginners[^]

2. Select * from StudentTable where ID = [insert the id you want to search here]

3. Update what? are you asking SQL question or data access? for sql

<br />
UPDATE StudnetTable<br />
set First_name = 'Joe'<br />
where ID = [insert the id you want to search here]<br />

If your question is about data access, you will find your answer in the tutorial.

Posted 30-Jan-11 15:49pm

Yusuf

Comments

skunkhead 30-Jan-11 21:55pm

thanks Yusuf,

2)this means that each time I search for ID, need to connect to db? is it possible to copy the DB to memory and do all the searching there?

3) I search the db for an ID and load the information on that ID to a windows Form. Now i change the address for that ID, and how do i update this change to the Db?this is what i mean.