Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Text Box, Button and DVWP Linked to Stored Procedure

  Asked By: Korey    Date: Jan 19    Category: Sharepoint    Views: 2358

I create a Web Part Page.

I edit it in FrontPage

I add a Data View Web Part (DVWP) attached to a stored procedure
that requires a last name parameter and retrieves all the customers
with that last name.

I tell the DVWP that the parameter is set at runtime.

I add a textbox and a button.

How do I make the button get the text out of the text box and stuff
it in the stored procedure and refresh the DVWP with the answer set?

Wouldn't that be a trick?

Can I do this in Visual Studio .Net? Should I be looking for a
FrontPage discussion board? Know of any good ones?



2 Answers Found

Answer #1    Answered By: Jasper Hatfield     Answered On: Jan 19

add Form web  part -

on DVWP set  filter to Input Parameter

Fr Form Web part  make a connection to DVWP using Modify View Using ...

Answer #2    Answered By: Rashawn Hopper     Answered On: Jan 19

I believe that someone else already answered your specific question so
this reply is just for edification.

The core of SharePoint is the Web Part Framework. So much so that VS.NET
is stealing the concept and making it (and other SharePoint concepts
like direct-mode master pages) the primary focus of the next release.
So, our goal should be to use Web Parts to accomplish whatever goal we
are trying to achieve.

Step two below always unghosts the page  even if all you do is click
Save. As I've previously described, unghosting is bad.

Step five can be accomplished using a Form WebPart rather than rather
than coding these controls directly on the page. If you can encapsulate
the functionality in a component that runs within a Web Part Zone that
manages all those details as metadata in the content database, I suspect
that you will be "light years" ahead when it comes time to upgrade to
the next release of SharePoint.

Didn't find what you were looking for? Find more on Text Box, Button and DVWP Linked to Stored Procedure Or get search suggestion and latest updates.