Add/update/delete data

  • Hi!

    A pretty simple question i guess...

    I've developed a software in VB.NET for time-tracking.

    But a simple question has popped up...

    I'm using a flexgrid which isn't bound to my dataset in any way. The columns of the flexgrid contains different projects, and the rows the selected months' days. The user reports the time he's spent on the projects for every day.

    Now to my question. What's the best method to add/update/delete my data. Should I have a method which calls a stored procedure on the server which updates the data, or should I update the data in the local dataset and thereafter call the dataadapters update method?


    Best Wishes,
    Stefan Johansson

  • This was removed by the editor as SPAM

  • Time related programming in SQL Server can get complex because time interval is not implemented in SQL Server. But there is a starter kit with most of the code you need and this version is in VB, so try the link below for all you need to get going.  Hope this helps.

    http://asp.net/TimeTrackerStarterKit/Docs/Docs.htm

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • I would save your changes in the local dataset, and modify the insert/update/delete commands of the dataset to use your stored procedures to insert/update/delete.

  • Ten,

    I saw your reply to a post and want to present you with a question.

    I have been a dba for over 11 years now. Our company will be migrating from Windows XP to Vista and 7 and Windows 2000 server to either Windows Server 2003 or 2008. I, as it appears, will be forced to use the .net framework where I basically have no experience. I am use to using classic ASP with vbscript, javascript, classic CDO, COM, as so on. I have read the benefits of .net (asp.net) but until now have not found the time to look at any tutorials for developing a front end user interface in .net (apparently asp.net) to insert, update, and delete data from both sql server 2005 and sql server 2008 enterprise databases. If I could be pointed to a few links where I could gain some understanding on how to (1) migrate from IIS 5 and 6 to apparently IIS 7 and (2) either migrate the classic asp code to .net or spend the time to develop new asp.net interfaces for the sql transactions that would be a great help. Our company cannot afford to hire another developer or bring someone in on a contract basis so I have to get this rolling as soon as possible.

    Thanks in advance for any help.

    Regards,

    HopingForHelp

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply