Hi everyone,
We recently installed Windows Server 2003 and Sharepoint Portal Server,
and after a few days of using it and scouring the web for ways to pull
data from MS SQL within SPS, I'm finding myself looking at C# as a
possible solution. Some comments and questions though...
First let me say I'm coming from an extensive ColdFusion and MS SQL
background, so from a CF/MSSQL standpoint I know exactly how to do this
-- but with Sharepoint Portal I'm finding it's not that simple. Many
folks said to retrieve data from MS SQL and pull it into SPS I need to
use C#, but after looking at sample code I feel like I'm back in the
early 90's programming in Boreland C++ 3.5 for DOS! I guess ColdFusion
has spoiled me because to throw a SQL statement at MS SQL and show the
output on the web is like 10 lines of code, and very clean code at
that. Does anyone have experience doing this with SPS? Is C# the way
to go? If so, any starting point you can suggest?
I've already posted a similar message on the SPS Developer group, and
the couple of replies I had were to use C#, which is why I'm here. I'd
love to keep everything on the SPS server to take advantage of the
Active Directory features, but pulling data from databases is vital for
us.
As for SPS, I assumed it would have a simple, outta the box method of
pulling data from MS SQL, but I guess I was wrong. It's nothing more
then an overpriced content manage/document management system, both of
which I already have via open source and custom-written software in
ColdFusion... we just hoped Sharepoint would do all this with
integration into our active directory network.
Sorry for getting on a soap box, but with the money we spent on SPS I'd
think it'd have more features then what it has. Other then the Active
Directory integration, there's plenty of opensource apps that do the
exact same thing, and better at it from what i've seen. Without the DB
integration it'll make a good messageboard or Intranet, but nothing
more. Back to Cold Fusion for all the real work.
Thanks for any comments or suggestions ---
Sam Alex 2 3242
Hi Alex,
If you would like to pull data from MSSQL with minimum number of codes, you
can use FrontPage to open your web-part page and insert a "Data View". What
you have to do is to create a database connection, construct you query and
define the XSLT to render your output. Actually, it doesn't require C#.
However, with this method, your web-part page will be unghosted and hard to
maintain (in my own point of view only).
Raymond
"Alex" wrote: Hi everyone,
We recently installed Windows Server 2003 and Sharepoint Portal Server, and after a few days of using it and scouring the web for ways to pull data from MS SQL within SPS, I'm finding myself looking at C# as a possible solution. Some comments and questions though...
First let me say I'm coming from an extensive ColdFusion and MS SQL background, so from a CF/MSSQL standpoint I know exactly how to do this -- but with Sharepoint Portal I'm finding it's not that simple. Many folks said to retrieve data from MS SQL and pull it into SPS I need to use C#, but after looking at sample code I feel like I'm back in the early 90's programming in Boreland C++ 3.5 for DOS! I guess ColdFusion has spoiled me because to throw a SQL statement at MS SQL and show the output on the web is like 10 lines of code, and very clean code at that. Does anyone have experience doing this with SPS? Is C# the way to go? If so, any starting point you can suggest?
I've already posted a similar message on the SPS Developer group, and the couple of replies I had were to use C#, which is why I'm here. I'd love to keep everything on the SPS server to take advantage of the Active Directory features, but pulling data from databases is vital for us.
As for SPS, I assumed it would have a simple, outta the box method of pulling data from MS SQL, but I guess I was wrong. It's nothing more then an overpriced content manage/document management system, both of which I already have via open source and custom-written software in ColdFusion... we just hoped Sharepoint would do all this with integration into our active directory network.
Sorry for getting on a soap box, but with the money we spent on SPS I'd think it'd have more features then what it has. Other then the Active Directory integration, there's plenty of opensource apps that do the exact same thing, and better at it from what i've seen. Without the DB integration it'll make a good messageboard or Intranet, but nothing more. Back to Cold Fusion for all the real work.
Thanks for any comments or suggestions ---
Sam Alex
Hi Raymond,
Thanks for the suggestion, but I guess I'm too oldschool... I like to
code things by hand and forego tools like Frontpage. If I learn the
ASP.Net code by hand then I'll have better control over it. Besides, I
don't have Frontpage, and with what we've spent on SPS and books thus
far I doubt they'll spend the bucks for it.
Thanks though --
Sam Alex
"Raymond Yuen" wrote: Hi Alex,
If you would like to pull data from MSSQL with minimum number of codes,
youcan use FrontPage to open your web-part page and insert a "Data View".
Whatyou have to do is to create a database connection, construct you query
anddefine the XSLT to render your output. Actually, it doesn't require
C#.However, with this method, your web-part page will be unghosted and
hard tomaintain (in my own point of view only).
Raymond
--
Sent via .NET Newsgroups http://www.dotnetnewsgroups.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: dave |
last post by:
if i created a web part in vs.net like http://www.devx.com/dotnet/Article/17518/0/page/2 is it possible to use the web part in both the sharepoint services environment and the sharepoint portal...
|
by: bhiyavudh |
last post by:
Hi all,
I am currently developing GIS web portal application based on Opensource
technology called Jetspeed from apache but as our company do develop GIS
application using Microsoft technology...
|
by: Alex |
last post by:
Hi everyone,
We recently installed Windows Server 2003 and Sharepoint Portal Server,
and after a few days of using it and scouring the web for ways to pull
data from MS SQL within SPS, I'm...
|
by: Ananta Kumar Jena |
last post by:
Hi!
Can anyone help me in finding,how we can connect
Sharepoint Portal Server 2003 from Visual Studio.Net 2003
using VB.NET winfrom,to manipulate images,files that are
stored in the above server....
|
by: cherry |
last post by:
Dear All,
I have written a program in sharepoint, in which will call a Web
Service of another Sharepoint portal server so that documents from
sharepoint portal server A can push document to...
|
by: (PeteCresswell) |
last post by:
Got a sample of MS's "Advisor Guide To Microsoft Access" in the mail today -
accompanied by a sample "Advisor Guide To Microsoft SharePoint".
I skimmed both, but the SharePoint explanation is too...
|
by: George Shui |
last post by:
I first installed Visual Studio .net on my local computer without installing
Frontpage Server Exetension 2002 and I tried creating Web Sites and find it
work well.
Then I installed Sharepoint...
|
by: wale |
last post by:
Yesterday I attempted to install sharepoint portal server 2003 on windows server 2003.
Once we had installed it I realised that we had followed the setup instructions for a server farm set up as...
|
by: GaryDean |
last post by:
I got and read the first few chapters of Scot Hillers book on sharepoint
2007 for C# and it appears to address Portal server, which is expensive to
license, and it appears to be a huge investment...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |