Updating table in Sql Server Express

[shalan99]

Hi Everyone!

I have a SQL Server Express db within my windows application (no username/password and user instances is set to true).

I've successfully read data into a Listbox using a dataset. I'm trying to add a new row into the same table being read from, using a stored procedure, and then refreshing the listbox to show the change. At first, it appears that the insert works and displays as an additional item in my listbox. But when i end the app & then reopen it, the addition doesn't appear! I know it has something to do with a final commit statement, but I cant for the life of me figure out what to do.

I should be updating the dataset but I have no idea how. I googled this, & since then have just been clicking links after links and getting nowhere! Im quite a noice at all of this, but does anyone a good tutorial or can advise me on my situation?

Much thanx!
Shalan99

 

[Arg81]

But when i end the app & then reopen it, the addition doesn't appear!

This comes up about 1,000,000 times a week. Searching the forums for this will always lead you to the same place: http://vbdotnetforums.com/showthread.php?p=54914

Have a read, it should sort your issues out.

Regards

 

[shalan99]

Hi Arg81 and sorry for the delayed reply. THANX A MIL for the link....the article explained it very nicely and it did solve my problem.

Thank u!