.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

CreateSPs Sample Application Causes Exception.

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

When I use the CreateSPs sample app on a sample database (Person), with a sample table (Contact), the following exception occurred.


Add object to collection failed for StoredProcedureParameterCollection  of StoredProcedure 'SmoDemo.uspContactSelect'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1116.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add object to collection+StoredProcedureParameterCollection&LinkId=20476

Program Location:

   at Microsoft.SqlServer.Management.Smo.ArrayListCollectionBase.AddImpl(SqlSmoObject obj)
   at Microsoft.SqlServer.Management.Smo.StoredProcedureParameterCollection.Add(StoredProcedureParameter storedProcedureParameter)
   at Microsoft.Samples.SqlServer.CreateStoredProcs.CreateSelectProcedure(Schema spSchema, Table tbl) in C:\Program Files\Microsoft SQL Server 2005 Samples\Engine\Programmability\SMO\CreateSPs\CS\CreateSPs\CreateStoredProcs.cs:l

View Complete Post

More Related Resource Links

Enterprise Library: Take Exception To Critical Errors With Custom Application Blocks


Enterprise Library is a collection of application functionality blocks that you can re-use in your application for common functionality you'd otherwise have to write again and again. Here Jay Hilyard explains how to use them.

Jay Hilyard

MSDN Magazine September 2006

Error Handling: Throwing Custom Exception Types from a Managed COM+ Server Application


Exception handling semantics in .NET are based on type, so you can create custom exceptions that have their own properties and methods. In .NET, exceptions are first-class citizens, and since they're the built-in error handling mechanism, all .NET-compliant languages must support exceptions. In addition, COM+ services are available to .NET code as Enterprise Services, so you can leverage exceptions in your Enterprise Services design.In this article the author describes custom exceptions, throwing exceptions across COM interop boundaries, and working with Enterprise Services.

Bob DeRemer

MSDN Magazine March 2004

I'm pulling out my hair,hard to find a suitable mvc sample application to learn from

I've noticed several samples in the url:http://www.asp.net/mvc/application-developmentbut,nerddinner seems too hard for me ;MVC MusicStore cannot run in my computer. seems it use sql2008&i have sql2005 installed in my computerASP.NET MVC Storefront Starter Kit        even worse  after i've download the source code from codeplex as told by the author, just find that I  can not compiled it  in vs2010(it's deveplopped using vs2008)and it seems out of date(the project begun at 2008),actually i wanna find a sample written after 2010.And I hope the sample is classic   and easy to learn,  and the technology used should not turn out to be a past after a new version of mvc or .net framework released.Anyone can help me out?

'System OutOfMemory Exception' while using rdlc in Windows application

hi Everyone , I am Using Reporting Service (.rdlc) in my Windows application , i am getting Error System OutOfMemory Exception Like "an error occured during local report processing An Unexpected error occured in Report Processing Exception of type 'System OutOfMemory Exception'Was Thrown " what to do Please anyone help me ... Advance Thanks Anilmarnal

how can we show error in our application when exception occur in webs service

how can we show error in our application when exception occur in webs service

what is wcf or wpf?Please give some sample application for asp.net.

hello , i  am  working on  asp.net project. i am newer from wcf and wpf . so how to use wcf,wpf in asp.net. i dont know where i start . so if you have any good link for this topic please send me . i thanks in adevance. 

Sample Application

Could anyone point me in the right direction of a sample application for a garden/landscape designer or that kind of application.

How to create a Custom Exception Handler using Micorosft Exception Handling Application Block?

Dear Friends,Can any one let me know "How to create a Custom Exception Handler using Microsoft Exception Handling Application Blocks"I will be having a set of Exceptions which will be getting maintained in an XML File along with the User Friendly Messages for a particular Exception. Whenever an Exception occurs in the projects first it need to check with the Exceptions present in the XML File and need to display the concerned user friendly message for that particular exception to the user..I am not able to get an idea on "How to start with the Microsoft Exception Handler Application Block" to achieve this". Please help me in this regard...Thanks and Regards,G.V.N.Sandeep.

an unhandled exception occurred in the silverlight application sharepoint 2010

An unhandled exception occurred on the page when Try to create the Announcement List in SP 2010 site which is upgraded from SP 2007,Any body have faced this issue?

Application Exception Rule Violation thrown on Delete

I basically have my first simple asp.net MVC 2.0 web application up and running except for deletes. I tried to do the first delete today, but it throws an exception with the text Rules Violation.  I'm not sure what is causing the error however.It shouldn't be the database (I don't think) because when I trace the database, I never see the delete call and after having it fail, I was able to sucessfully run:DELETE FROM [Work] WHERE work_id = 84 GOCurrently this is my method (yes its primitive, but I was just trying to get it working), its the db.SubmitChanges() line where the application exception gets thrown. [HttpPost] public ActionResult Delete(int id, FormCollection collection) { try { // TODO: Add delete logic here var result = db.Works.SingleOrDefault(w => w.work_id == id); if (result == null) return View("NotFound"); db.Works.DeleteOnSubmit(result); db.SubmitChanges(); return RedirectToAction("Index"); } catch { var result = db.Works.SingleOrDefault(w => w.work_id == id); return View(result); } } }This may be a Linq-to-Sql issue as this is really the first time I've us

Release mode application throws Break instruction exception - code 80000003 when running in WinDbg


Here is the initial output of my program after running it from WinDbg:

CommandLine: "C:\Documents and Settings\Administrator\My Documents\Work\QMI_Test_Tool\QMI_UT_Source\Release\QMI Validation Tool.exe"
Symbol search path is: SRV*c:\symbols*http://msdl.microsoft.com/download/symbols
Executable search path is: 
ModLoad: 00400000 0048f000  QMI Validation Tool.exe
ModLoad: 7c900000 7c9b2000  ntdll.dll
ModLoad: 79000000 7904a000  C:\WINDOWS\system32\mscoree.dll
ModLoad: 7c800000 7c8f6000  C:\WINDOWS\system32\KERNEL32.dll
ModLoad: 77dd0000 77e6b000  C:\WINDOWS\system32\advapi32.dll
ModLoad: 77e70000 77f03000  C:\WINDOWS\system32\RPCRT4.dll
ModLoad: 77fe0000 77ff1000  C:\WINDOWS\system32\Secur32.dll
ModLoad: 7c420000 7c4a7000  C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989\MSVCP80.dll
ModLoad: 78130000 781cb000  C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989\MSVCR80.dll
ModLoad: 77c10000 77c68000  C:\WINDOWS\system32\msvcrt.dll
ModLoad: 7c9c0000 7d1d7000  C:\WINDOWS\system32\SHELL32.dll
ModLoad: 77f10000 77f59000  C:\WINDOWS\system32\GDI32.dll
ModLoad: 7e410000 7e4a1000  C:\WINDOWS\system32\USER32.dll
ModLoad: 77f60000 77fd6000  C:\WINDOWS\system32\SHLWAPI.dll
ModLoad: 7c4c0000 7c53d000  C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989\m

Empty Catch in Global.asax to prevent exception from stopping a web application?



I'm using a static Timer in my Global.asax to run a method at regular intervals. When the method throws an exception, my application is stopped. I have used an empty catch to prevent exceptions from stopping the application something like below code. Is there a disadvantage to use such an approach?


 protected void Application_Start(object sender, EventArgs e)

 public class TimerStarter
            private static System.Threading.Timer threadingTimer;

            public static void StartTimer()
                if (null == threadingTimer)
                    threadingTimer = new System.Threading.Timer(new System.Threading.TimerCallback(CheckData),HttpContext.Current, 0, 50000);

            private static void CheckData(object sender)
                   // a method that reading xml file from another url              
                    // empty catch to prevent stopping the application




provide sample MVC application with asp.net 3.5 + VS 2008


Just I started working on MVC application using VS 2008 + 3.5 framework. Please provide any sample applicaiton with custorm validations with SQL Server 2008 database connectivity


" is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)"

I'm attempting to migrate an ASP.NET application from .NET 1.1 to 2.0 (and I'm also moving the development platform from VS.NET 2003 to VS.NET 2005). After some modification the application builds cleanly on the new platform but when I attempt to run in debug mode I see the error shown below. I'm building on a new WinXP-64 machine (AMD Athlon 64 CPU).

If I change the target platform to "x86" in the solution properties, I can't build the app (hundreds of unresolved dependencies).

Can anyone point me in the right direction to solve this problem?

Many thanks

Steve F

Server Error in '/CMISWebAdminDevelopment' Application.

is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:
System.BadImageFormatException: is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

Source Error:

Exception when deploying .net remoting application over internet

Hi everyone,

I'm trying to make a .net application works in a computer outside my intranet, using a web service created with .Net remoting and
hosted in my intranet.

This application works well in any computer in the intranet, but not in the computer
that accesses the web service over the internet.

My .net remoting web service is configured in IIs and uses http channel.

I'm using interfaces and i'm implementing this interfaces each one
being a subclass of the MarshalByRefObject, like this:
    public interface IClassMain
      int GetSum(int a, int b);
      IClass1 Class1 { get; }

    public interface IClass1
      String GetFormattedName(string firstname, string lastname);

    internal class ClassMainImplementation : MarshalByRefObject, IClassMain
      private Class1Implementation m_class1Implementati

Sample Application for learning.



I am new and want to work on MVC. I have Nerddinner and Music store.

Is there any other sample application for MVC2 with AJAX implementation?

Tutorials/Videos will be helpful.


CLR Profiler is not working.Unhandled exception has occured in your application.


For me CLR Profiler is not working.

When i choose profile application and browser to the executable file.It show's up an message box

"waiting for application to start Common language runtime" .

the message box stays for long time and when i click on "Show Heap now" button even as above message box is displayed i get the following error

Unhandled exception has occured in your application. If you click Continue,the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.

Object reference not set to an instance of an object.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend