DOTNET POWER PLAY
.NET stuffings and MICROSOFT (C) technologies
Tuesday, November 29, 2005
Enjoy Every Sandwich : SQL Server Express failed to generate user instance
Enjoy Every Sandwich :: "SQL Server - Otherwise (RSS)
Think of it as a default constraint
A fix for that annonying per-user instance problem with SQLExpress
Thanks to fellow DevelopMentor 'Brain' Kevin Jones (RSS) for pointing this one out.
These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following 'Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.' and if I set 'User Instance' to false the following 'An attempt to attach an auto-named database for file C:\[app_path]\ASPNetDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.'
..
If you don't want to follow the link, the short answer is that SQLExpress creates a directory per user in 'c:\Documents and Settings\[user]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' that it uses to store information. Deleting this directory has fixed both of my problems. "
ASPFAQ : SQL Server 2005
ASPFAQ : SQL Server 2005: "Number of articles: 29
Last update: 2005-10-29
What version of SQL Server 2005 do I have?
What should I know about Express Manager (XM)?
Where do I post issues and questions about SQL Server 2005?
What happened to IntelliSense?
Can I download Books Online separately?
Why does SQL Server 2005 break SQL Server 2000 tools?
How do I view the code for system objects?"
Monday, November 28, 2005
SQL 2005 - advanced querying Richard Campbell Blogs Too
Richard Campbell Blogs Too: "I'm hanging out in the United Kingdom in Reading, just outside of London, attending the VBUG Conference.
Carl and Mark Miller are here as well.
Yesterday I did my famous advanced querying session, I've attached my demo files here for the folks who wanted them.
AdvQuerying_Setup.sql (3.48 KB)
AdvQuerying.sql (23.52 KB)
I'm also including my error handling queries, since I had enough time to quickly show off how SQL Server 2005 can actually handle an error: in this example, I handle a deadlock inside a stored procedure.
Error Handling Main.sql (1.48 KB)
Error Handling Second.sql (.26 KB)"
PageMethods, well-defined URLs for your ASP.NET sites by metaSapiens
PageMethods, well-defined URLs for your ASP.NET sites by metaSapiens: "PageMethods provides a solution for the limitations of the standard way of handling pages, URLs and parameters.
The usual way to proceed is not structured. With PageMethods, the code of your pages is simpler, cleaner and more reliable"
Sunday, November 27, 2005
Wrapping up ASP.NET Providers and remote setups
Wrapping up ASP.NET Providers and remote setups: "Like Rogers' comment, you need to run them in a particular order. However if you run the command with a filename you'll get them all in one single SQL script so run it like this:
aspnet_regsql -sqlexportonly MyProvider.SQL -A all"
TechEd 2005 HOL
TechEd 2005 HOL: "TechEd 2005 Hands-On Lab Manuals
HOL001 - Visual Studio Team Architect Edition
ARC01: Using the Distributed System Designers to visually design and validate service-oriented systems in Visual Studio 2005
Download Hands-On Lab Manual (Download Size: 364KB)
HOL002 - Visual Studio Team Architect Edition
ARC02: Using the Application Designer to design Your Web Service Architecture in Microsoft Visual Studio 2005
Download Hands-On Lab Manual (Download Size: 291KB)
HOL003 - ARC03: Using the Logical Datacenter Designer for Configuration and Deployment in Visual Studio 2005
Download Hands-On Lab Manual (Download Size: 271KB)"
Download details: Application Verifier
Download details: Application Verifier: "Application Verifier is a runtime verification tool for unmanaged code that assists in quickly finding subtle programming errors that can be extremely difficult to identify with normal application testing. "
Thursday, November 24, 2005
Wednesday, November 23, 2005
ASP.NET QuickStart Tutorial
ASP.NET QuickStart Tutorial: "Welcome to the ASP.NET 2.0 QuickStart Tutorial"
Tuesday, November 22, 2005
Using ROW_NUMBER() to paginate your data with SQL Server 2005 and asp.net c# - The Code Project - C# Database
Asynchronous Web Service Options in .NET V2
The #1 online source for .NET/XML and Web Service Topics: "Asynchronous Web Service Options in .NET V2
Description As more and more Web Services are made available additional flexibility is needed when calling them. Applications that call Web Services may need to do so in an asynchronous (parallel) manner especially when calling multiple services or services that may take a longer amount of time to complete.
The code found in this sample demonstrates how to make synchronous and asynchronous calls to Web Services using features in .NET version 2.0. The included code demonstrates the following types of asynchronous calls:
Callbacks
WaitHandles
Polling
Asynchronous Events
Asynchronous ASP.NET Pages "
Monday, November 21, 2005
Sunday, November 20, 2005
Saturday, November 19, 2005
Sahil Malik [MVP C#] : SQL Server 2005: A neat T-SQL trick - Batching
Sahil Malik [MVP C#] : SQL Server 2005: A neat T-SQL trick: "DECLARE @rowcount int
DECLARE @count int
SET @rowcount = 10
WHILE (@rowcount = 10)
BEGIN
BEGIN TRANSACTION
Update top (10) veryBigTable set a = b, updated=1 where updated=0 and c = d
Set @rowcount = @@rowcount
COMMIT
END"
Thursday, November 17, 2005
.NET Heaven - Essential Resources for .NET, Visual C#.NET, VB.NET, ASP.NET, Visual Studio .NET
.NET Heaven - Essential Resources for .NET, Visual C#.NET, VB.NET, ASP.NET, Visual Studio .NET: "C# Corner v2.0 Launched Nov 14, 2005
BOOTHWYN, PA. Nov 15, 2005. Mindcracker announced launch of C# Corner version 2.0. This new 2.0 version of C# Corner is redesigned and rewritten using C# and ASP.NET and adds many new features to the site.
Visual Studio 2005 Section Launched Nov 14, 2005
We have recently launched a new section dedicated to Visual Studio IDE features, code snippet, and articles. Check it out here. "
Wednesday, November 16, 2005
Tuesday, November 15, 2005
Visual Basic 6.0 Resource Center: Diagnose This
a process wrapper
Using the Process class from VB6
Like most of the classes in the .NET Framework, the Process class is not directly available to a VB6 application. Instead, you can expose the functionality of this class by creating a simple wrapper in VB.NET.
The code for the wrapper is as follows:
Listing 2. VB.NET Wrapper Class
Visual Basic 6.0 Resource Center: Diagnose This
Monday, November 14, 2005
Sunday, November 13, 2005
Saturday, November 12, 2005
Got Directory Services? New Ways to Manage Active Directory using the .NET Framework 2.0 -- MSDN Magazine, December 2005
Friday, November 11, 2005
Thursday, November 10, 2005
Uninstall a VSI File
Uninstall a VSI File: "Uninstall a VSI File
If you want to uninstall a VSI file for Visual Studio .NET 2005, its kinda hard to figure out what is going on. I didn't find anyway any way in the Control Panel applet. I couldn't find it in the Visual Studio Directory. It was driving me up the wall. Well, it appears the files are stored in the 'My Documents\Visual Studio 2005\Templates\Project Templates' directory. Delete the file and its uninstalled. Life is better. "
AJAX problems for newbies
AJAX problems for newbies: "AJAX problems for newbies
I have some items I learned about AJAX (or Ajax.NET Professional) developer newbies:
You cannot access the controls or HTML elements on your web site if you are using DOM/DHTML on the client-side to modify data. Without a postback you will not get the changed parts of the page. An example: if you have a placeholder control you can set the visibility style to hidden on the client. If you want to have the same value for the visibility value on the server you have to post it back, with AJAX or a full postback.
You should not do too many AJAX requests. One reason is that you can only have two connections at the same time (with one process, i.e. with one running iexplore.exe). If you want to initialize a lot of controls on window onload event you should pack it in one method. If you have some initializing data use the JSON serializer to write this data as a JavaScript to the page instead of invoking a AJAX request later.
The Session and Cache collections are available through the System.Web.HttpContext.Current static value. You can also implement the preferred way with implementing the IContextInitializer interface. This will be needed for future developments.
AJAX should not be used to get MBs of data back to the client. Also, you should have a look at the viewstate, some developers showed me pages that are filling DataSets from a database during Page_Load and again, if they are using AJAX. Decide what you want to use and load within AJAX or the common ASP.NET Page.
posted on Thursday, November 10, 2005 12:06 AM "
Wednesday, November 09, 2005
ASP.NET Development Center: Step-By-Step Guide to Converting Web Projects from Visual Studio .NET 2002/2003 to Visual Studio 2005
Monday, November 07, 2005
Saturday, November 05, 2005
Thursday, November 03, 2005
Wednesday, November 02, 2005
Tuesday, November 01, 2005
Does Visual Studio Rot the Mind?
Does Visual Studio Rot the Mind?: "Does Visual Studio Rot the Mind?
Ruminations on the Psychology and Aesthetics of Coding
By Charles Petzold
A Talk Delivered at the NYC .NET Developer�s Group,
October 20, 2005 "
Previous Posts
- Step-by-Step MVP pattern for ASP.NET
- Approaches to Paging through Large DataSet
- Articles by Saravana Kumar on ASP.NET 2.0 ans SQL
- Running Different .NET versions in ASP.NET / Appl...
- Grab Bags and Database Models
- a web developers cheat sheet list
- Great Online Ebook on C# Threading
- Biztalk Links
- A Primer on Using DB2 with .NET
- .NET XML Web Services Repertory
Archives
- August 2003
- September 2003
- October 2003
- November 2003
- December 2003
- January 2004
- February 2004
- March 2004
- April 2004
- May 2004
- June 2004
- July 2004
- August 2004
- September 2004
- October 2004
- November 2004
- December 2004
- January 2005
- February 2005
- March 2005
- April 2005
- May 2005
- June 2005
- July 2005
- August 2005
- September 2005
- October 2005
- November 2005
- December 2005
- January 2006
- February 2006
- March 2006
- April 2006
- May 2006
- June 2006
- July 2006
- August 2006
- October 2006
