Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

O/T Northwest Traders

  Asked By: Guy    Date: Aug 10    Category: Sharepoint    Views: 1017

This is no doubt OT and I apologize in advance for asking but I
know no better place.

I was going through Frontpage books and asp.net C# books and sharepoint
books (novice still) and trying to get some kind of big picture for data
connections and
how they are used in Sharepoint in a real world business environment
(kind of stuff aside from document library's and contact lists etc)..
Anyway I connected the SQL northwest traders database to a blank
teamsite (just so I knew more about it and not for any particular
reason) and just wanted to know what good it is? Is the database just
some useless demo made for illustration purposes or can it actually be
renamed, reworked and used as a real world application for sales and
invoicing and so forth?

In other words, does it do anything?

I don't expect a masters level explanation, but some brief insight would
be much appreciated.



10 Answers Found

Answer #1    Answered By: Carley Lott     Answered On: Aug 10

Its just for demo/training purposes. MS uses it in examples. There is no other
purpose that I know of.

Answer #2    Answered By: Aastha Tatpatti     Answered On: Aug 10

That's kinda what I thought... Thanks for putting that to rest.

Answer #3    Answered By: Roop Kapoor     Answered On: Aug 10

Sorry again, but it begs another question I have about C# standard...
Since it only "works" with the MSDE SQL engine and Sharepoint is built
on SQL 2000, what good  is the standard edition and why did I get it? lol

Is it possible with the small business  suite coming out soon that C#
standard will play some role other than just form making?

Answer #4    Answered By: Kelley Obrien     Answered On: Aug 10

Not sure what you mean by C# "standard". C# is a programming language, just
like VB.Net, that has access to the full .Net library, and as such can access
any database  that is supported by .Net - which includes SQL 2000 and Oracle. C#
is not a toy but a full-blown development environment.

Answer #5    Answered By: Ashleigh Neal     Answered On: Aug 10

The version of visual studio.net that I have includes Visual Basic.Net,
C#.Net and C++,... I got it because I wanted  to create plug-ins for 3d
graphic applications. Anyway, the version I have is "standard" and
everywhere I go it says: "C# Standard will not work with SQL 2000" and
you must use the MSDE database  etc...

That's all, I didn't mean to imply it was a toy or anything.

I thought the best place  to start learning would be on a seperate web
site like my personal one www.whitcombpalace.com and start making simple
forms and stuff  but I was under the impression that since "standard"
doesn't work with SQL 2000 that I wouldn't be able to get very far on
the web end of things. Anyway, I started working with database
connections in Frontpage and this is where it all sort of took a life of
it's own and got me interested.
I'd be happy as peach pie if it actually did "work' with SQL 2000 so I
could start making web forms that tied into SQL 2000.

Sorry for being a noob, but I gotta start somewhere...

Answer #6    Answered By: Mitali Panchal     Answered On: Aug 10

Sorry if I was a bit abrupt earlier.

There is nothing in Visual Studio or C# that limits it to the type of database
you can connect to that I've ever heard. The .Net framework comes with a set of
classes that are part of the System.Data namespace that include support for SQL
Server - MSDE is just a stripped down version of SQL Server that you can run on
a desktop for development purposes.

If you have access to a server running SQL 2K, you can develop C# applications
to access the data on that server.

Look in the .Net SDK help file (or online help at Microsoft's MSDN site) under
"System.Data.SqlClient ".

Answer #7    Answered By: Wanda Petersen     Answered On: Aug 10

No need for any apology, it's me who introduced an off topic thread and I
don't want to be a troll. Most of you guys have a deeper understanding than
I do about databases and web based application  building and even non-web
based coding than I do, I just want to begin the learning process with a
little broader understanding of the big  picture than what I currently have,
which is just what I've read in Front Page 2003 by (Jim Buyens) and his
Sharepoint book as well and to some extent on Microsoft. They're great books
both of them, but they leave off when it comes to actually building stuff  in
Sharepoint that's not out of the box like chat applications and how to
actually implement a sensible form processing model in a real  world business
environment and these are things I want to learn more about. I can save an
info-path form to Sharepoint and that's all great and fine but then what the
devil do they do with it? How does it "roll up" and what is it "Rolling up"

Anyone can save a word doc to a doc library or make a new list with some
custom columns, but I want to integrate Sharepoint as deeply as possible
with our little drug testing company and I'm just a one man IT dept. Most of
my time is spent fixing printer bugs on terminal services or helping people
setup email boxes or updating web pages and anti-virus stuff etc... It's not
very glamorous work, but I get to learn along the way and do graphics hobby
junk too.

I can whip around in Sharepoint and look under the hood some using front
page etc... And I have the basic skills to follow some of the customizations
which are either free or cheap 3rd party. We did get a handy little chat
application going in Sharepoint, which is really quite simple and nice as an
internal office communication system, because you can just pop open the page
once you're on Sharepoint and type away without IM (Which needs a practical
work over IMO and less "cutesy" gimmicks and annoying timeouts and stuff).

I continue to read and watch and learn and while I don't always grasp what
some of you are talking about sometimes

I do listen and take notes.

Answer #8    Answered By: Eric Davis     Answered On: Aug 10

I know everyone has their favorite resources, here are a few books  that I've
found particularly useful:

Microsoft SharePoint: Building Office 2003 Solutions (Paperback)
by Scot P. Hillier

Advanced sharepoint  Services Solutions (Books for Professionals by
Professionals) (Paperback)
by Scot P. Hillier

Microsoft SharePoint Products and Technologies Resource Kit (Pro - Resource Kit)
by Microsoft Corporation, Bill English

The SDK can be found online at MSDN, and who can live without Google!

Answer #9    Answered By: Giselle Glass     Answered On: Aug 10

Cool, I have the SDK and admin guide and office web part development kit and
will check out the office 2003 solutions books  by Scot Hillier.

Those look interesting and I didn't know they existed, I'm also reading
Sam's SQL server 2000 unleashed.

Bit by bit it will all come together eventually, I have nothing but time. I
think I also saw some Google research gizmo you could drop in Sharepoint,
but maybe I misread it.

Answer #10    Answered By: Kendra Webb     Answered On: Aug 10

I think that you can still use the "Standard" edition of Visual Studio
.NET to write applications that access SQL Server 2000 databases,
however you will have to hand code those elements. Server Explorer
won't connect to them unless you have at least the "Professional"
edition of Visual Studio.NET.

Microsoft has designed this so that if you want more functionality you
have to pay more for it. On the positive side, it is possible to code
ASP.Net apps with a plain text editor. :o) But they do cripple the
Standard edition like this.

Didn't find what you were looking for? Find more on O/T Northwest Traders Or get search suggestion and latest updates.

Related Topics:



Related Post