ASP.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?

Re: ASP.NET Interface to SQL Server

Erik wrote:
> 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.

--
Microsoft 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.

Re: ASP.NET Interface to SQL Server

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.

"Bob Barrows [MVP]" wrote:

> Erik wrote:
> > 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.
>
> --
> Microsoft 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.
>
>
>

Re: ASP.NET Interface to SQL Server

That was why I said "There was no way for you to know it ... "
Rule of thumb:
..asp = classic ASP
..aspx = ASP.Net

Erik wrote:
> 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.
>
> "Bob Barrows [MVP]" wrote:
>
>> Erik wrote:
>>> 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.
>>
>> --
>> Microsoft 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.

--
Microsoft 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.

Re: ASP.NET Interface to SQL Server

Erik wrote:
> 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.
>

Darn! I meant to post this:
http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sq l-server/msde.html
--
Microsoft 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.

Re: ASP.NET Interface to SQL Server

"Erik" wrote in message
news:950110A6-07E2-4D3A-B66B-712F259FD225@microsoft.com...
>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?

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