By jbonnie on
Wednesday, December 28, 2005 11:41:05 AM
The DNN Module template for V4 is pretty sweet.Shaun Walker's post, http://forums.asp.net/1114393/ShowPost.aspx has 3 sections so far, describing the Starter Kit for the whole site, the module template and some background on the new module/file layout for ASP.NET 2.0.Creating DNN sites, and modules is getting nice and easy.That is good, since the nw features of ASP.NET and SQL server 2005 will keep us busy!I started playing with the Gridview component and was confused on how to bind it into DNN. It can bind to SQL Adapters or Objects. But what about the DNN DAL ? I found that I could just bind the datasource in the code behind the old fashioned way. But hooking it up to an object sure sounds interesting! Michael Washington has a sample, and a tutorial coming, http://adefwebserver.com/dotnetnuke/DotNetNuke/DNN4GuestBook/tabid/199/Default.aspxI was a bit...
Read More »
|
By jbonnie on
Tuesday, December 27, 2005 2:15:59 PM
Strange behavior with DNN 4 and VS 2005.
I have added a page called TEST and when building and running the site from VS 2005 the TEST page is not shown, just the default HOME page.
When hitting the HOME menu page, the TEST page appears...
Does this have something to do with an IIS setting or from the internal Web Server in VS 2005?
|
By jbonnie on
Monday, December 26, 2005 1:04:43 PM
Had a quick run with the starter kit for dotnetnuke and it went pretty well.There was a hick up or two.1. Downloaded the latest 4.02 variants2. Read the installation guide and decided to use the starter kit to build the site3. Installed the starter kit and used the new option for a new DNN website4. The welcome menu is very nice with detailed instructions on the next steps5. I decided to create a SQL Server 2005 DB using standard edition - Instructions were provided, nice job Charles!6. The release config file even had commented out connection strings to use7. Fired up the build and let the script go - The DNN logo image was not displayed properly8. The install went cleanly and there were no errors - but when calling up the new portal, none of the modules displayed, instead each had an error9. I clicked on the login page and then the webdev.webserver crashed!!!10. Did another build and run from VS 2005 and then the site came up ok....11. Oy yea - VS2005 showed 11 Warnings, and 90 messages - but no errors - so...
Read More »
|
By jbonnie on
Saturday, December 24, 2005 2:00:00 AM
Just a quick note to mark the start of the big migration for the retail store front application.I will be migrating an existing oracle based application to DNN and ASP.NET.This should be a great learning exercise with so many new tools:DNN 4.XSQL Server 2005 and new admin toolsVisual Studio 2005ASP.NET 2.0The port of the existing application should be a minor issue, but I plan on using the following approach. I will leave the existing Oracle Database and Application in place, and use a SQL Server 2005 Linked server to build a new ASP.NET application.This will allow me to avoid a big bang approach and roll out new bits over an extended period of time. Once all of the functionality (and more) is running in ASP.NET against SQL Server 2005 stored procedures (hitting the Oracle DB), I can then port the oracle tables over to SQL and retire the Oracle DB and application.I hope to be able to setup categories in the blog to keep the posts organized.Let the games begin!p.s. This is my first post using the Telerik RAD Editor....
Read More »
|
By jbonnie on
Monday, December 19, 2005 8:00:00 AM
Free .NET USER GROUP MEETING
When: Tuesday, January 3rd, 2006 at 6:00p.m
Where: UCONN Stamford Campus
Topics: XML in SQL Server 2005: Part I The XML Data Type XML in SQL Server 2005: Part II Using XQuery to Query and Manipulate
Speaker: Stephen Forte, Chief Technology Officer and co-founder of Corzen, Inc
Overview:
Blogs, Web Services and general interoperability has proliferated the use of XML in recent years. With all of that XML out there, there needs to be an easy way to incorporate XML data with SQL Server relational data. SQL Server 2000 introduced the FOR XML clause that produces XML from relational output and SQL Server 2005 greatly enhances that. What SQL Server 2000 lacked was a native way to store and work with XML, you were reduced to storing XML in a TEXT field. SQL Server 2005 has a new intrinsic XML data type that can be used in tables, variables, stored procedures, etc. The advantage is that you can use a whole...
Read More »
|
By jbonnie on
Monday, December 05, 2005 11:00:00 PM
Started playing with SQL Server 2005 and Linked Oracle Servers.
The SQL Server 2005 Management studio gave some framework errors and I was forced to re-install the dot net 2.0 framework to get a clean start up.
After that I ws able to get a linked server added from the graphical editor.
The parameters are in a slightly different order than the stored procedure so be careful.
For example,
sp_addlinkedserver 'GOLF', 'Oracle',
'MSDAORA', 'GOLF'
where the first GOLF is the name of the local DB, and the second GOLF is the TNSNAMES entry for the oracle would appear as follow:
|