TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
idan hen
NA
1
0
c# Database file Update
Jul 10 2007 8:15 PM
I have a lil problem , maybe someone here can help me ? i have an access database called "UserDetails". I can Write to it , i can read from it , all is good . now i wana Update some fields in it , maybe even a full row , i dont really mind . so my code goes like this : [QUOTE] string stAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=TestDriveDatabase.mdb"; OleDbConnection DBconn = new OleDbConnection(stAccessConn); OleDbCommand MyAccessCommand = new OleDbCommand(stAccessSelect, DBconn); OleDbDataAdapter MyDataAdapter = new OleDbDataAdapter(MyAccessCommand); DBconn.Open(); DataSet myds = new DataSet(); MyDataAdapter.Fill(myds, "UserDetails"); myds.Tables[0].Rows[1]["FirstName"] = "fuckit"; OleDbCommandBuilder mybuilder = new OleDbCommandBuilder(MyDataAdapter); MyDataAdapter.Update(myds.Tables[0]); DBconn.Close(); [/QUOTE] it looks like it all works , yet the file wont change !! :( anyone ??
Reply
Answers (
1
)
c# StreamReader/StreamWriter Not Working Correctly
HELPFUL TO OTHERS