Home > MOSS 2007 > SPSqlDataSource and DFWP

SPSqlDataSource and DFWP

August 20th, 2008 Leave a comment Go to comments

Creating custom Data Form Web parts (formerly known as Data View Web part or DVWP)  that call into your line of business applications , extract data and land it onto your SharePoint pages is as easy as pop corn 😉

The reason they changed the name from Data View Web Part (V2.0) to Data Form Web part (V3.0)  was because it works way more than just giving you the ability to “View”.  You can insert, update and delete. What else do you want?  What? You can’t use Windows Authentication? Well, no problem , use Single Sign On service instead. If you neglected it in previous version, give this poppy another chance!We use this Web part in our day-to-day developments a lot. I agree! there are some limitations , but you will hear more about this guy and you will see improvements as well . FYI, Data Form Web Part is as powerful as Content Query Web Part (IMHO: It is even more powerful!).

For more information Please see my notes here.

SPSqlDataSource class and Data Form Web Part:

spsqldatasource.png

Categories: MOSS 2007 Tags:
  1. Pete
    August 21st, 2008 at 16:58 | #1

    I think the link to your notes for DFWP is incorrect…

  2. Rashmi
    August 21st, 2008 at 17:30 | #2

    Hello,

    I had a quick question on wss 3.0 (I am not using MOSS).

    When user clicks on OK button in newform.aspx, I would like to read all the input values and then validate them and store to our own SQL database.

    How do I do this? I want to store data to my own database.

    Also after storing, how can I restore it when user comes back to edit through editform.aspx?

    Thanks.

  3. Reza Alirezaei
    August 21st, 2008 at 22:16 | #3

    Fixed. Thanks for the heads up Pete!