I've got existing data stored on a SQL 2000 Server, and want to move to SQL Server 2005 Std.
I want to design a website with forms to look up, edit and add new data to the SQL server. I have specific pages in mind, i.e. a page for scanning in S/Ns for products, a page for allocating products that are in stock, etc.
Is Sharepoint capable of allowing access to SQL server and letting me design such custom pages? Or should I go with Visual C# and use ASP.NET to create the kind of site that I want?
i do not think that sharepoint alone will help you, you might have to use Infopath forms to use the sharepoint option. Or you could right some custome web parts to plug into the sharepoint system. My advice (My own point of view) is that you would be better creating your own custom solution using asp.net, this way you will have more control of the editing of the data. Also with the way that ASP.Net 2.0 is you can do some really quick development using the build in controls. Remember if you are going to ask some specific questions about asp.net you should direct you browser to http://forums.asp.net as this is where most of the asp teams hang out.
|||I have configured SharedPoint 2007 server with sql server 2005. In this environment you can create portals, blogs and manage enterprise contents. For your requirements you can simply use SharedPoint 2007 server and sql server 2005 and then can whatever you wnat. Don miss it.
Note: you can write vast programming in this environment also with C# for managing your web pages/outlooks/etc...
Shahidul Haque.
No comments:
Post a Comment