|
A S P.Net Enterprise Manager (0.5.0)
|
Email
|
| Submitted on: |
9/29/2002 3:06:04 PM |
| By: |
Wes Grant
|
| Level: |
Intermediate |
| User Rating: |
By 36 Users |
| Compatibility: |
VB.NET, ASP.NET |
| Views: |
74460 |
|
|
|
|
|
This is a web-based version of Enterprise Manager for SQL Server and MSDE. An online demo is available at http://www.aspenterprisemanager.com/. This is an Open Source Project in VB.Net, ASP.Net and ADO.Net that is in the early stages, so any contributions, feedback or additions are greatly appreciated.
ASP Enterprise Manager will allow you to create and edit tables, stored procedures and views, manage logins and database users, manage basic permissions, and query your database returning multiple recordsets.
This is the version 0.5.0 release of the code and structures most of the code with better .Net structures (on most of the pages), introduces a class structure (I am working on documenting the classes), cuts down on the number of connections that are made to the SQL Server, introduces an XP style interface and adds a few new features and interface enhacements.
This code is not a Visual Studio Project so it only requires the .Net Framework, Someone is also working on a version of this project as a Visual Studio Project using C#, that code can be downloaded from the website (http://www.aspenterprisemanager.com/)
|
 |
| |
Can't Copy and Paste this?
Click here for a copy-and-paste
friendly version of this code!
//**************************************
// for :A S P.NetEnterprise Manager (0.5.0)
//**************************************
This is released as Open Source and can be tracked at http://sourceforge.net/projects/asp-ent-man/ | |
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 2 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 9/30/2002 12:23:19 AM: ellymd
Nice..5 from me, but you should use code-behind files in ASP.NET (aspx.vb)
(If this comment was disrespectful, please report it.)
|
9/30/2002 4:56:17 AM: Jos Keuter
4 from me! :) Nice ASP coding but not truly using "the powers" of ASP.NET. Probably converted (which is ok of course)... so I rated the original ASP version with 5.
(If this comment was disrespectful, please report it.)
|
9/30/2002 12:40:55 PM: Pete {vbAVI}
Great idea!
(If this comment was disrespectful, please report it.)
|
9/30/2002 6:57:08 PM: Ian Ippolito (psc)
Nice job!
Ian
(If this comment was disrespectful, please report it.)
|
9/30/2002 7:14:41 PM: Wes Grant
Thanks for all your comments and support. I hope to clean up the code and use Code Behinds once I figure out the process of using the SQL Stored Procedures and INFORMATION_SCHEMA to manipulate the database and provide all of the functionality that I can figure out from SQL Server Books Online. Any and all suggestions are greatly appreciated, I am learning the SQL System Stored procedures and .NET both so any help is more than welcomed.
(If this comment was disrespectful, please report it.)
|
10/1/2002 9:16:30 AM:
Cool concept. Code needs a little work to be truly .net but other wise great work.
(If this comment was disrespectful, please report it.)
|
10/1/2002 12:43:30 PM: MJC
Easy to install and to run, and very nice interface. [*****]
(If this comment was disrespectful, please report it.)
|
10/17/2002 5:04:41 AM: Craig Waggoner
Now this is some thing I will be keeping a close eye on! 5 Stars from me
(If this comment was disrespectful, please report it.)
|
11/18/2002 2:59:46 AM: Struja
Great code!!!!! *****
(If this comment was disrespectful, please report it.)
|
11/18/2002 4:57:52 AM: Marek Adar
It's excactly what I'm looking for.
Thanks.
5 Globes from me
(If this comment was disrespectful, please report it.)
|
11/18/2002 11:26:09 PM: Fredrick Bartlett
Very useful, great implementation but only 3 star's with out source. This is Planet-"SOURCE"-Code
(If this comment was disrespectful, please report it.)
|
11/19/2002 7:47:55 AM: Wes Grant
Learn how to use PLanet-"SOURCE"-Code Freddie..... Click on the Zip Icon Above to download the code from PSC...
Or go to http://www.aspenterprisemanager.com/ to download the latest ( http://new.aspenterprisemanager.com/SourceCode.zip ) version of the code and all previous versions.
(If this comment was disrespectful, please report it.)
|
11/19/2002 4:27:00 PM: computrz
looks pretty sweet, you got my vote!
(If this comment was disrespectful, please report it.)
|
11/30/2002 6:18:29 AM: { pHroZeN GeeK }
great work... 5 from me
(If this comment was disrespectful, please report it.)
|
12/18/2002 11:23:32 AM: Xybex
Impresive peace of code *****
(If this comment was disrespectful, please report it.)
|
4/26/2003 1:30:14 AM: computrz
great code, but i would like to edit rows that exist in the table already, other than that, great product
(If this comment was disrespectful, please report it.)
|
6/4/2003 9:27:57 AM:
Please help! What do you do with the files after unzipping them to get this application running?
(If this comment was disrespectful, please report it.)
|
6/5/2003 9:50:19 PM: Walter Berman
Very nice and useful project. I give it 5 globes.
(If this comment was disrespectful, please report it.)
|
10/13/2003 3:50:49 AM:
In IE 6.0 I can display only the default.asp page.
Server Address: p1000, UserName : sa, Password: xxxx. when I click on connect button, I stay on this page !!
WHY?
(If this comment was disrespectful, please report it.)
|
12/23/2003 2:29:32 AM:
I am new to ASP.Net.. It is great. I am SQL SERVER guy. This will be very useful for me when I am outside of the office.. I have downloaded the code but I have no idea how to confgure and run the application in my webserver. Please anybody help me in running the application after unzpping the application.
(If this comment was disrespectful, please report it.)
|
1/7/2004 1:28:27 PM: Gandolf_The_GUI
And you're THE SQL SERVER GUY? I think not.
Good code, Wes!
(If this comment was disrespectful, please report it.)
|
1/21/2004 12:23:20 PM:
Muy buen codigo, gracias por compartirlo con nosotros.
(If this comment was disrespectful, please report it.)
|
2/3/2004 4:31:11 PM:
Very nice! i like it because it solves many problems i had to access the server from outdoor. But one thing i want to know - i loaded it down from source-forge it works but has not the sources only the .aspx - is this right and if - can i have a look at them too to learn from them? I want to make some ASPX too - i only worked wit ASP till now.
(If this comment was disrespectful, please report it.)
|
10/11/2004 4:24:16 PM: Jim Wilson
Is there a free Windows Application version of this? I'd rather not use Internet Explorer.
(If this comment was disrespectful, please report it.)
|
12/6/2004 12:18:33 AM:
can anyone help with this please?
Parser Error Message: Could not load type 'ASPEnterpriseManager.ConnectionString'.
Source Error:
Line 1: id=
(If this comment was disrespectful, please report it.)
|
5/25/2005 3:17:33 AM: Arvin Meralpis
Excuse me. Where is the project file (*.vbproj) or the solution file (*.sln)? Thank you.
(If this comment was disrespectful, please report it.)
|
2/9/2006 10:52:16 PM: Oscar Onorato
Where are your site? I cannot find it.
(If this comment was disrespectful, please report it.)
|
2/16/2006 8:15:49 AM: sharon
Hi, very good project indeed but i need a favour of how to execute it.It will a great help if you could jus let me know the process to execute.
(If this comment was disrespectful, please report it.)
|
6/28/2006 5:19:36 PM: hakan
I read some people are having problem when installing. I suggest you put everything in the root folder first. If you already have default.asp then rename it to something else because ASP Net Man. already has one. First install it to a test server with a .net frame work then check your setting in IIS at >.NET section. Make sure .net account has permissions to that folders. make sure web.config global.asa is in the root I also have
_codebehind classes bin folders in the root. Then once you understand the concept you can change the folders and code. May be you will be asking more valuable questions then.
(If this comment was disrespectful, please report it.)
|
7/15/2006 10:30:22 PM: hendra sutiono
Very nice! i like it because it solves many problems i had to access the server from outdoor. But one thing i want to know - i loaded it down from source-forge it works but has not the sources only the .aspx
http://studyaspnet.blogspot.com
(If this comment was disrespectful, please report it.)
|
12/12/2006 7:25:34 PM: saran
It's good really good but now I just
study on vb.net
(If this comment was disrespectful, please report it.)
|
3/25/2007 2:43:49 PM: hi
i dont know how to import my database with this program. my hosting uses it , how can i do it?
(If this comment was disrespectful, please report it.)
|
5/31/2007 8:51:16 AM: amandiya
Hi, Pls help me and I'm sure you can...
I am unable to compile your code and spending hours and hours... I get the following error for Could not load type 'ASPEnterpriseManager.ConnectionString' and 7 warnings for "Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated."
Earlier there were 28errors but I managed to remove those.
FYI, The Project lies at the location: D:\Development\Net\ASP\
and I am working on VS.net2005.
Please tell me what exactly do i need to do before I run your code in .net
Regards,
Diya
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
