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
Eric
NA
8
0
Database tables not reflecting changes made during run-time
Mar 17 2008 10:01 PM
Hello. I am currently working on a project that makes several insert, update, and delete queries on a database. Everything works fine while the program is running. For example, after an insert, a Select * query shows that that row was successfully added. However, when I exit the program and return to the database explorer in Visual C# and click "Show Table Data", the item I just added during program execution is not in the table. I have tried doing adaptermanager.Update() and dataset.AcceptChanges() calls as well as using SqlCommand queries directly and none seem to be inserting the data into the actual database on the hard drive. Can you please tell me what I am doing wrong or what I should try instead? The database I am using is a Service-based Database added as a new item from the solution explorer window in Visual C# Express 2008, and is stored in the same folder as the project solution. Please let me know if you need anymore information that will clarify my problem. Thank you and I look forward to your reply.
Reply
Answers (
6
)
SqlParameter Int64/Int32 conversion
Define an Identity Column