Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Form elements and database

  Asked By: Stacey    Date: Oct 22    Category: Sharepoint    Views: 969

I need to display 3 drop down lists on my wss home page, whose values
need to be picked from the database. Further, selection in one drop
down will filter the contents of the other two. Is there any easy way
of achieving this?



4 Answers Found

Answer #1    Answered By: Titus Sweet     Answered On: Oct 22

From what database  are you pulling information? SQL server on the backend that happens to sit on the same SQL server that runs sharepoint? Access database using some other connection? Lists that you have information in?

Answer #2    Answered By: Laura Walker     Answered On: Oct 22

The data is getting pulled from a SQl DB different from the
sharepoint db and may not reside on same server. I need to query a
table from our data warehouse.

Answer #3    Answered By: Christop Mcfadden     Answered On: Oct 22

Note: If you are using Integrated Authentication (this is the default)
and you plan to use the authenticated user's credentials to access your
remote database  server you will need to consider the "double-hop issue".
There are only three solutions that I am aware of:

1. Hard code static credentials into a config file.
2. Turn on Basic Authentication and turn off Integrated Authentication.
Users will always be prompted to enter their credentials and the
credentials will be sent to the Web site in plain text (SSL is advised
if packets will be on the Internet).
3. Install SharePoint SP2, Win2K3 SP1, and implement Kerberos

Answer #4    Answered By: Victoria Bell     Answered On: Oct 22

The easy  way to achieve this is called "InfoPath", Microsoft's
non-developer form  tool of the future. All products in the Microsoft
stack will eventually sport InfoPath forms. All other form creation
tools (except VS.NET via ASP.NET) will be changed over to use InfoPath.

Didn't find what you were looking for? Find more on Form elements and database Or get search suggestion and latest updates.