Re: Question about forms and data storage

From: MDS_Work (mds_work_at_newsgroup.nospam)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 18:10:42 -0400

While true and that works for alot of situations, if you want to get the
data into a list so people can make their own views and such the only real
option to get the data into a list (something I've employed) is to write an
app that synchs the data from SQL to a list, using either XML Web Services
or the Excel object... or look at moving the core data into the sharepoint
list over the database...

P.S. Mike... how about "here is another approach" instead of "you are taking
the wrong approach"... seems nicer (IMO)

"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:uDubqsfdEHA.1652@TK2MSFTNGP09.phx.gbl...
> >Basically they want to take current data in sql and make >it viewable in
> sharepoint.
>
> If that is all they want you are taking the wrong approach (imho).
>
> All you need to do is FP 2003 Data View and access the database table
> containing that data they want to see.
>
> I add this table typically in a web part page.
>
> To see the latest database data they need to either access the page or if
> the page is open, do a refresh.
>
> Mike Walsh, Helsinki, Finland
> STS FAQ at www.collutions.com/Lists/FAQ
> WSS FAQ at wss.collutions.com
> Please reply to the newsgroup
> "Greg Merideth" <gmerideth.remove@this.forwardtechnology.net> wrote in
> message news:XYSdnYbdU_4mz5TcRVn-oA@comcast.com...
> > I've written some of our company apps to web parts using sql queries,
> > paging, implementation of Icellprovider to allow web part communications
> > but now I've been asked to put some form data and backend storage pages
> > up and I've got a question as to hows the best way to do this.
> >
> > If I create a custom list (template I believe) how do I get sharepoint
> > to use my custom fields and then do I need to write my own
> > implementation of add/remove/edit and filtering?
> >
> > Basically they want to take current data in sql and make it viewable in
> > sharepoint. instead of writing a paging app I'd rather experiment and
> > make it a sharepoint "list" but where do I start in making my own list
> > templates of data?
> >
> > Any thoughts or pages to start/look at would be appreciated.
>
>

Relevant Pages