| Author |
Message |
Peter
Guest
|
Posted:
Tue Jan 11, 2005 2:09 pm Post subject:
WSS Lists & WebServices |
|
|
Hello!
Please, could someone advice me, is it possible to:
1. populate custom lists with sql server database data base on eg. customer
ID?
2. to populate custom lists with WebService's webmethod that returns
xmldocument?
3. or what is your opinion, what would be the best approach for the following:
I need a WebPart which displays customers that are assigned to some
particular
vendor and had not purchased anything during 3 months . Vendor's customers
should be queried from a database by vendor's logon name. WebPart should
contain a link to an asp.net application with querysting parameter (eg.
http://my.domain.com/appname/showcustomer.aspx?customerid=426).
The help is very much appreciated!
Thanks
Peter |
|
| Back to top |
|
 |
Ed Richard
Guest
|
Posted:
Tue Jan 11, 2005 3:29 pm Post subject:
Re: WSS Lists & WebServices |
|
|
Peter,
When you add a Dataview webpart to a page using Frontpage you will be able
to use an existing SQL-database as the DataSource. Is this what you are
looking for?
The same is true for a DataSet returned by a Web Service.
Ed Richard
"Peter" <Peter@discussions.microsoft.com> wrote in message
news:775E1290-9AED-4B1A-B038-E18311E6B57B@microsoft.com...
| Quote: | Hello!
Please, could someone advice me, is it possible to:
1. populate custom lists with sql server database data base on eg.
customer
ID?
2. to populate custom lists with WebService's webmethod that returns
xmldocument?
3. or what is your opinion, what would be the best approach for the
following:
I need a WebPart which displays customers that are assigned to some
particular
vendor and had not purchased anything during 3 months . Vendor's customers
should be queried from a database by vendor's logon name. WebPart should
contain a link to an asp.net application with querysting parameter (eg.
http://my.domain.com/appname/showcustomer.aspx?customerid=426).
The help is very much appreciated!
Thanks
Peter |
|
|
| Back to top |
|
 |
JOPX
Guest
|
Posted:
Tue Jan 11, 2005 3:33 pm Post subject:
RE: WSS Lists & WebServices |
|
|
You should definitely take a look at the dataviewwebpart in FrontPage 2003 -
check out "Building XML data driven websites with FrontPage 2003"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_fp2003_ta/html/odc_fpbldgxmlwebs.asp
friendly greetings,
Joris
http://jopx.blogspot.com
"Peter" wrote:
| Quote: | Hello!
Please, could someone advice me, is it possible to:
1. populate custom lists with sql server database data base on eg. customer
ID?
2. to populate custom lists with WebService's webmethod that returns
xmldocument?
3. or what is your opinion, what would be the best approach for the following:
I need a WebPart which displays customers that are assigned to some
particular
vendor and had not purchased anything during 3 months . Vendor's customers
should be queried from a database by vendor's logon name. WebPart should
contain a link to an asp.net application with querysting parameter (eg.
http://my.domain.com/appname/showcustomer.aspx?customerid=426).
The help is very much appreciated!
Thanks
Peter |
|
|
| Back to top |
|
 |
Mike Walsh
Guest
|
Posted:
Tue Jan 11, 2005 3:38 pm Post subject:
Re: WSS Lists & WebServices |
|
|
If you intend to do this by programming rather than by following Ed's
suggestion to use FP 2003's Data View, please note that the guys to help you
with creating web parts; writing jobs that access web services etc. hang out
in the subnewsgroup for WSS Programming which you'll find at
microsoft.public.sharepoint.windowsservices.development
where you also find the Questions and Answers on this sort of thing that
have been accumulated there in the past couple of months since the
subnewsgroup started.
(When you do post there, please post only there - not 'just in case' to here
too)
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
"Peter" <Peter@discussions.microsoft.com> wrote in message
news:775E1290-9AED-4B1A-B038-E18311E6B57B@microsoft.com...
| Quote: | Hello!
Please, could someone advice me, is it possible to:
1. populate custom lists with sql server database data base on eg.
customer
ID?
2. to populate custom lists with WebService's webmethod that returns
xmldocument?
3. or what is your opinion, what would be the best approach for the
following:
I need a WebPart which displays customers that are assigned to some
particular
vendor and had not purchased anything during 3 months . Vendor's customers
should be queried from a database by vendor's logon name. WebPart should
contain a link to an asp.net application with querysting parameter (eg.
http://my.domain.com/appname/showcustomer.aspx?customerid=426).
The help is very much appreciated!
Thanks
Peter |
|
|
| Back to top |
|
 |
Peter
Guest
|
Posted:
Tue Jan 11, 2005 5:51 pm Post subject:
RE: WSS Lists & WebServices |
|
|
Thanks for your help guys! I think I try to use DataView webpart first.
Peter
"Peter" wrote:
| Quote: | Hello!
Please, could someone advice me, is it possible to:
1. populate custom lists with sql server database data base on eg. customer
ID?
2. to populate custom lists with WebService's webmethod that returns
xmldocument?
3. or what is your opinion, what would be the best approach for the following:
I need a WebPart which displays customers that are assigned to some
particular
vendor and had not purchased anything during 3 months . Vendor's customers
should be queried from a database by vendor's logon name. WebPart should
contain a link to an asp.net application with querysting parameter (eg.
http://my.domain.com/appname/showcustomer.aspx?customerid=426).
The help is very much appreciated!
Thanks
Peter |
|
|
| Back to top |
|
 |
|
|
|
|