Click here to Skip to main content
15,886,110 members
Articles / Desktop Programming / Windows Forms

Setting up Stored Procedures with Optional Parameters and Using a Strongly Typed TableAdapter to Execute the said Stored Procedure

Rate me:
Please Sign up or sign in to vote.
4.32/5 (29 votes)
29 Mar 2006CPOL9 min read 322.8K   52  
Collection of information on optional paramters in Stored Procedures, as well as passing null values into the Fill method of a stongly typed data adapter.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead Broome County Government
United States United States
Not much to say really If you saw me now you'd probably think I was a vagrant or a heavy drug user

Truth is I'm just a geek with an extreemly high pain tollerance. When I'm not writing code I'm either getting something pierced, or getting another tattoo.

In general i've been programing since 6th or 7th grade (not sure when we started apple basic :-P) I've been hooked ever since. Jumped right into C which i pretty much taught myself. Picked up enough C++ when it came out to write what i needed then i learned pascal (if your wondering why i learned pascal after C well my school was a little behind the 8-ball, so I ended up with a class to catch up on some sleep) I picked up C# from the start when all you could get was the .NET sdk and the csc command line compiler. Inbetween time my uncle sent me an SQL book so I learned that (we're talking industry standard SQL not MS or Oracle's extra little extensions). For the most part ever since MS released VS.NET 2002 I've been using it and its subsequent upgrades to write an even mix of windows forms and database applications.

Currently working at Lockheed Martin's System Integration site in Owego, NY I develop custom deployment solutions for site wide software installations, as well as site level support tools, utilities and custom process automation software for both interdepartmental use as well as special requests from other bussiness areas.

Comments and Discussions