 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / December 2007ASP.NET Interface to SQL Server
I have a coworker who would like to build up her experiance with SQL queries. To that effect, however, the only real way for her to do this is to play around. I can create a demo database for her on the server, that's easy... however creating an interface that doesn't require sitting at the server (or remote desktopped into it) is slightly different. Basically, I'm looking for a way to emulate the query analyzer tool, via a web browser window (in ASP.NET if at all possible). I had figured that a simple multi-line textbox would suffice for the area to type a query into, and a gridview object will be more than enough for the results returned, but: How would I get/display messages such as "the command completed successfully", or "xx rows updated" or anything like that? Or if a query fails, returning back all the messages that the analyzer returns back saying where the problem is? > Basically, I'm looking for a way to emulate the query analyzer tool, > via a web browser window (in ASP.NET if at all possible). There was no way for you to know it (except maybe by browsing through some of the previous questions before posting yours - always a recommended practice), but this is a classic asp newsgroup. ASP.Net is a different technology from classic ASP. While you may be lucky enough to find a dotnet-savvy person here who can answer your question, you can eliminate the luck factor by posting your question to a newsgroup where the dotnet-savvy people hang out. I suggest microsoft.public.dotnet.framework.aspnet. There are also forums at www.asp.net where you can find a lot of people to help you.  SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. I had looked for other threads which might have answered this question, but didn't seen any differentiation between ASP and ASP.NET in this group. I appologise for the confusion, and will mark it as answered to keep others from spending time on it. > > Basically, I'm looking for a way to emulate the query analyzer tool, > > via a web browser window (in ASP.NET if at all possible). [quoted text clipped - 9 lines] > There are also forums at www.asp.net where you can find a lot of people > to help you. That was why I said "There was no way for you to know it ... " Rule of thumb: .asp = classic ASP .aspx = ASP.Net > I had looked for other threads which might have answered this > question, but didn't seen any differentiation between ASP and ASP.NET [quoted text clipped - 22 lines] >> header is my spam trap, so I don't check it very often. You will get >> a quicker response by posting to the newsgroup. SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. > I have a coworker who would like to build up her experiance with SQL > queries. To that effect, however, the only real way for her to do [quoted text clipped - 3 lines] > however creating an interface that doesn't require sitting at the > server (or remote desktopped into it) is slightly different. Darn! I meant to post this: http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. >I have a coworker who would like to build up her experiance with SQL >queries. [quoted text clipped - 19 lines] > saying > where the problem is? I don't know whether you are still watching this thread, but why don't you just install Sql Server Express with its Management Studio on her machine and let her play with that? It's free to download. And it will be a heck of a lot quicker than coding an ASP.NET or ASP or other web based version of the management tool. -- Mike Brind |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.