Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-08-09 : 09:34:27
|
Rather than making a frivolous post just because its a new forum how about I get it started off with a question. How many out there are using .NET in development? I'm using it in two projects currently and find it to be alot nicer than classic ASP.Justin |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-08-09 : 09:49:52
|
I certainly second that. Much, much nicer! I'm also a huge C# fan.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-08-09 : 11:47:21
|
I absolutely LOVE C# and .NET. Thankfully I have some application development (desktop) experience (C++, VB3-6) and have an understanding of OOP so the transition has been pretty nice.Can't wait for the next version of SQL Server [Yukon], coding sprocs in C# will be very nice.I just picked up a great ASP.NET book if anyone is interested. I got ASP.NET Unleashed and it's been extremely helpful. The code is all in VB but it's the concepts that matter, converting to C# isn't that difficult, typically.Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
 |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-09 : 11:48:07
|
Bit upset that you don't seem to be able to use unnamed parameters for SPs.Funny forum this - surely query analyser is the only tool anyone needs?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 08/09/2002 11:48:59 |
 |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-08-09 : 12:22:34
|
quote: Can't wait for the next version of SQL Server [Yukon], coding sprocs in C# will be very nice.
I'm less and less certain this will happen in the way I described in my article. I think it will be like the XP_ approach that someone mentioned in the comments.quote: surely query analyser is the only tool anyone needs?
You bring up an interesting point. Maybe for future versions of SQLTeam I should open up the database read-only just tell everyone that the articles are out there. Go use query analyzer to read them. I could supply some stored procedures to post in the forums. I think you're onto something!Heck, if we could train end users on SQL we could do away with this pesky web and everyone could just query the databases directly! Think how much money Amazon could save!Actually, does this mean that a web site or application is just a fancy way of documenting a database?===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-09 : 12:23:20
|
Query Analyzer SUCKS as a front-end though... And it really doesn't handle HTML and .Net code at all. |
 |
|
joldham
Wiseass Yak Posting Master
300 Posts |
Posted - 2002-08-09 : 12:32:36
|
Just started using .NET and have to say that I like it a lot. Unfortunately, I am not yet adapt at using C#, so I revert back to good ole reliable VB. One of the coolest tutorials I have seen is at [url]http://www.dnzone.com/ShowDetail.asp?NewsId=48[/url]. Basically, you load a 24-bit bmp image as a template and through the System.Drawing namespace, it loads each individual RGB combination on the template as a different region. You can then change the regions colors to whatever you want. This is great to show top sales areas on a world map based on data in a database.JeremyEdited by - joldham on 08/09/2002 12:36:03 |
 |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-09 : 12:40:01
|
quote: You bring up an interesting point. Maybe for future versions of SQLTeam I should open up the database read-only just tell everyone that the articles are out there. Go use query analyzer to read them. I could supply some stored procedures to post in the forums. I think you're onto something!
Should make sure that the questions were all interesting as it would ensure some basic expertise.Actually I thought it meant development tools like code generators, enterprise manager, maintenance wizard and such.This front end is a means of accessing the web site (which happens to have some data stored in sql server) not a tool for developing on sql server.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|