It's true that ASP.NET 1.1 doesn't have anything as simple/elegant as
CFQUERY. This is being remedied in ASP.NET 2.0, which adds "DataSource
controls". Here's an example:
<asp:SqlDataSource ID="Employees"
Runat="server"
SelectCommand="SELECT * FROM Employees"
ConnectionString="<%$ ConnectionStrings: Employees %>">
</asp:SqlDataSource>
The ConnectionString attribute in this example is being read from the
web.config file--you can also hardcode a connection string here if you want,
or use variables.
Here's a good article that shows you how to bind the DataSource control to a
GridView control to create a master/detail display that includes sorting and
the ability to insert, edit, and delete records, all without writing any
code:
http://www.devx.com/dotnet/Article/22141/0/page/1
There's definitely a lot of cool stuff happening in ASP.NET.
Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com
> -----Original Message-----
> From: Phil Cruz [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 10, 2004 7:55 PM
> To: CF-Talk
> Subject: Re: Blackstone Beta
>
> I've been meaning to look more into ASP.NET but never seem to
> get around to it. One mental hurdle for me is the last I
> looked it seemed like you had to write a bunch of code to do
> simple queries. Nothing as simple/elegant as <cfquery>.
>
> If it really took you 15 minutes, would you consider using
> Camtasia or some screen capture software to record the
> process and share it with others and share the source code as
> well. I'd be interested in seeing it.
>
> -Phil
>
> > ASP.NET is lookin' pretty strong. I've always been a CF guy, but I
> > recognize the power of .NET now. I built a .NET Contacts app in
> > literally 15 minutes the other night. Fully functional, DONE!
> >
> > I'm sorry, but Blackstone has an uphill battle if it's going to
> > compete with .NET. MM needs to take it further than it has!
> >
> > Will
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187200
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
