Hi all,

I want to use ASP.net to build a query builder project to display data on 
our intranet. This project should have ability to allow user join tables, 
select fields, set criteria and sort fields. Can anyone shed some light on 
this? Code samples would be even better.
Thanks in advance!

Li

Li,

How complex/idiot-proof do you want to make this?  If people know the schema
of the database then a simple text area for query entry is all you really
need.  Then you execute the query and if there are any rows returned, you
just return a nice little HTML table with data in it.  Of course, being that
you are in .Net, you should be able to just drop a datagrid on a page, then
bind the recordset of the returned query to it and it will handle all the
display for you.  You just need to add a text area to the page and execute
that.

Peter

-----Original Message-----
From: Li Wu [mailto:liwu@w...]
Sent: Wednesday, January 15, 2003 09:08
To: ASP.NET
Subject: [aspx] Query Builder


Hi all,

I want to use ASP.net to build a query builder project to display data on
our intranet. This project should have ability to allow user join tables,
select fields, set criteria and sort fields. Can anyone shed some light on
this? Code samples would be even better.
Thanks in advance!

Li

Hi Peter,
Thanks for your response. It could be very complicated one since my users 
don't know sql statement well. I would like to allow the users visually 
select tables, relationship, columns and where condition for our Oracle 
databases. Any idea?

Regards,
Li

Li,

YIKES!!  That's a tall order.  If you are going to build this, you are going
to get into all kinds of fun SQL interactions for viewing the schema and
stuff.  I would probably invest a short bit of time searching around and
seeing if you can find something that's already made for this sort of thing.
I have never dreamed much less done anything of that magnitude.

Peter

-----Original Message-----
From: Li Wu [mailto:liwu@w...]
Sent: Tuesday, January 21, 2003 09:03
To: ASP.NET
Subject: [aspx] Re: Query Builder


Hi Peter,
Thanks for your response. It could be very complicated one since my users
don't know sql statement well. I would like to allow the users visually
select tables, relationship, columns and where condition for our Oracle
databases. Any idea?

Regards,
Li

I would guess oracle would have such a front end tool as part of the
oracle database because I know Microsoft Access and MS SQL Server have
query builder tools that do that as we all know, when we developers and
admins want a select or a view based on a select, we don't have to write
it, in the microsoft databases, we can use the builders, oracle must
have an equivalent. If however you want to build an equivalent web front
end, then you're nuts.


-----Original Message-----
From: Peter Lanoie [mailto:planoie@n...] 
Sent: Wednesday, January 22, 2003 5:30 PM
To: ASP.NET
Subject: [aspx] Re: Query Builder


Li,

YIKES!!  That's a tall order.  If you are going to build this, you are
going to get into all kinds of fun SQL interactions for viewing the
schema and stuff.  I would probably invest a short bit of time searching
around and seeing if you can find something that's already made for this
sort of thing. I have never dreamed much less done anything of that
magnitude.

Peter

-----Original Message-----
From: Li Wu [mailto:liwu@w...]
Sent: Tuesday, January 21, 2003 09:03
To: ASP.NET
Subject: [aspx] Re: Query Builder


Hi Peter,
Thanks for your response. It could be very complicated one since my
users don't know sql statement well. I would like to allow the users
visually select tables, relationship, columns and where condition for
our Oracle databases. Any idea?

Regards,
Li


---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to