?
Solved

Add columns in form web part to search multiple fields in data view

Posted on 2010-03-23
4
Medium Priority
?
868 Views
Last Modified: 2013-12-24
I am fairly new to Sharepoint development.  I have created a data view that queries an external SQL server.  I want to bind a few text boxes to this data view so I can search for matches.

I have been fooling around with the form web part, and it seems promising, but I can't seem to get more than one text box in the web part.  How can I do this?  Also, I'd like to be able to do wildcard searching, but I'll take anything I can get at this point.

Thanks!
screen-shot.PNG
0
Comment
Question by:IntercareSupport
  • 2
  • 2
4 Comments
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 2000 total points
ID: 28358251
wildcard searching, and multiple searching, is tricky with DVWP.  i found these articles to be helpful:

http://philwicklund.com/archive/2009/04/11/using-the-data-view-web-part-to-search-a-sharepoint-list.aspx
http://praveenbattula.blogspot.com/2009/10/sharepoint-list-view-web-part-wild-card.html


with the help of those two articles, i have set up a DVWP that has 3 associated "search" boxes (they are really filters and not searches).  so, i have a search box for City, one for State and one for Company.  each box filters/searches a column in my DVWP.
0
 

Author Comment

by:IntercareSupport
ID: 28571441
What kind of search boxes?  I was using the Form Web part, but it only lets me bind to one list field.  I will read these pages closer.
0
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 28801212
i used those articles to get the basic idea of how it works.  the step by step instructions worked for me, and gave me the groundwork to then take the next step and implement a second search/filter on a second column.  it's the exact same premise... just do it for every column you want to filter/search.
0
 

Author Closing Comment

by:IntercareSupport
ID: 31706106
Oops.  I didn't realize I didn't close this question.  Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question