none
how to update , insert , delete in ODBC dataset ( foxpro database file )

    Question

  • I wrote a Visual Foxpro application, using VFP database file.

    success to publish the data in web using Visual Web Developer 2005 Express,

    but it can only Read those data ( but do not know how to delete or update or insert the data )

    pls help me to  explain how to work with this ..

    Thursday, June 22, 2006 3:32 AM

All replies

  • Hi LVT,

    Can you post the code you are using to read the data? It will help to know what approach you are taking.

    Thursday, June 22, 2006 3:59 AM
  •  Liew Vai Teng wrote:

    I wrote a Visual Foxpro application, using VFP database file.

    success to publish the data in web using Visual Web Developer 2005 Express,

    but it can only Read those data ( but do not know how to delete or update or insert the data )

    pls help me to  explain how to work with this ..

    pls goto http://file.uploadr.com/7d4e download my simple Visual Web Developer Project file ,, pls help me to solve it ,, thankyou

     

    Thursday, June 29, 2006 9:04 AM
  • Hi!

    I've seen your file and found that you are not passing any parameters. You must pass parameter for insertion,deletion and updation. That can be done by selecting the DataSource and look for Insert,delete and update query in property windows and there you add query and its parameters.

     

    Cheers.

    Sohail.

    Thursday, June 29, 2006 10:23 AM