Using SQL in a Web Part to Return Data

S

Shawn Everingham

Is it possible, and if so, how would I get started creating a web part that
makes a sql call to a database and returns 1 or 2 fields for display?

We have an external HR system that tracks our Personal Time and Vacation
Time. I'd like to have the balance displayed on everyones home page, so they
don't have to switch between systems.

Can I do this? how?

thanks in advance?

Shawn
 
S

Shawn Everingham

ok, first of all what the heck is a NG?

and I echo Stephen Sanderlin, isn't this microsoft.public.project.developer?

just point me in the right direction, like where to start. I've dll'd the
SDK, have VS.net 2005 installed...just need some pointers to get me rockin'.

Thanks!
 
S

Stephen Sanderlin

The intricacies of building web parts are much too detailed to go into
here. there's plenty of resources on the 'net available.



Essentially, the web part will need to query SQL which you would then
display in some kind of control in the web part.



Have you installed MOSS along with PS? If so, there are capabilities in
that product that may be of use here.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com
 
S

Steve

This is really a SharePoint thing rather than Project Server, which rides on
top of it.

For simple read-only SQL queries, you can use SharePoint Designer to add a
SQL source and Data Form Web part. This is much easier than VS2005, as you
get a GUI interface to build it.

If you want to go the custom webpart route, google "Sharepoint 2007 web part
SQL query" and you'll get loads of examples.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Web Part 401 2
Working on birthday "book" for my wife and having layout/editing trouble 0
Publishing a project via command line? 1
Bringing a chart web part into an Access 2010 web db 0
Data Validation Tool and Tables Trouble 0
Project Server 2007 and SSRS 2005 integration: issue withauthentication when running to the reports 3
My client is looking for SAP HR ... 0

Top