SqlParameter Constructor

asp.net.ph
Home	Getting Started Getting Started ASP.NET Primer Authoring an ASP.NET Page Introducing ASP.NET Web Forms Introducing Web Forms Server Controls Publishing ASP.NET Files ASP.NET Syntax ASP.NET Page Syntax Code Declaration Blocks Code Render Blocks Custom Server Control Syntax Data Binding Expression Syntax Page Directives Syntax Server-Side Comments Server Control Inline Template Syntax Server-Side Include Directive Syntax Server-Side Object Tag Syntax ASP.NET Syntax for HTML Controls HtmlAnchor HtmlButton HtmlForm HtmlGenericControl HtmlImage HtmlInputButton HtmlInputCheckBox HtmlInputFile HtmlInputHidden HtmlInputImage HtmlInputRadioButton HtmlInputText HtmlSelect HtmlTable HtmlTextArea ASP.NET Syntax for Web Server Controls ASP.NET Syntax for Validation Controls ASP.NET Configuration Sections Global.asax Syntax ASP.NET Programming Languages Primer Statements Comments Variable Declarations and Initialization Arrays Controlling Program Flow If Statements The Conditional ? : Operator Switch Statements For Loops While Loops Foreach Loops Reusable Statements ASP.NET Base Types Converting Types Base Data Types Table Type Conversion Tables Formatting Base Types Format Specifiers and Providers Date and Time Format Strings Numeric Format Strings Enumeration Format Strings Customizing Format Strings Parsing Strings Parsing Numeric Strings Parsing Date and Time Strings Parsing Other Strings Basic String Operations Creating New Strings Trimming and Removing Characters Padding Strings Comparing Strings Changing Case Using The StringBuilder Class Regular Expressions Regular Expressions as a Language Details of Regular Expression Behavior Matching Behavior Backreferences Backtracking Nonbacktracking Lookahead and Lookbehind Quantifiers and Empty Matches Next Match After an Empty Match Compilation and Reuse Thread Safety Regular Expression Examples Example: Changing Date Formats Example: Extracting navigateurl Information Example: Scanning for HREFs	Web Forms ASP.NET Web Forms ASP.NET Web Forms Overview Web Forms Server Controls Web Forms Server Controls overview Controls You Can Use on Web Forms ASP.NET Data Controls ASP.NET Data Source Controls ASP.NET HTML WebControls ASP.NET Login Controls ASP.NET Navigation Controls ASP.NET Standard Controls Web Forms Server Controls Templates Web Forms Server Controls and CSS Styles Web Forms Validation Web Forms User Controls Programming Web Forms Server Controls Data Binding in Web Forms Introduction to Data Binding in Web Forms Data Binding Expressions for Web Forms Pages Data Binding HTML Server Controls ASP.NET Master Pages Introduction to Master Pages Nested Master Pages Working with Master Pages Programmatically Referencing Master Page Content Events in Master and Content Pages Programming Web Forms Web Forms Page Processing Stages Web Forms Events and Handlers Web Forms State Management	Data Access Data Access in Web Forms Web Forms Data Model ADO.NET Primer ADO.NET Data Providers Setting up ASP.NET Pages for Data Access Core ADO.NET Classes Data Source Controls Overview Introduction to Data Source Controls Binding to Data Using a Data Source Control Filtering Data Using Data Source Controls Using Parameters with Data Source Controls Modifying Data Using Data Source Controls Sorting Data with Data Source Controls Caching Data Using Data Source Controls Connecting to a Database Securing Connection Strings Issuing Commands to a Database Retrieving Data Using a DataReader Retrieving Data Using a DataSet Retrieving XML Data Using a DataSet Calling Data Functions in Code Behind Displaying Information From a Database Displaying Data in a Repeater Displaying Data in a DataList Displaying Data in a DataGrid Displaying Data in a GridView Selecting Information From a Database Retrieving Data From User Specified Queries Passing Variables to the Select Query Retrieving Data From Database Schema Updating Data at the Database Level Adding a new record Editing an existing record Deleting an existing record Understanding and Using Views Creating a view Extending the Functionality of Views Sample Applications Using Views Comparison of Queries and Views Structured Query Language (SQL) Basics Introduction to Queries SQL Basic Concepts SQL Select: Specifying Data to be Included in a Query SQL Where: Specifying a Filter Condition SQL Join On: Selecting Data From More Than One Table SQL Group By: Grouping Data in Qquery Results SQL Order By: Sorting Data in Query Results Using SQL Aggregate Functions Optimizing Queries	Web Apps ASP.NET Applications ASP.NET Applications Overview ASP.NET State Management Application State Session State ASP.NET Optimization ASP.NET Caching Features Caching ASP.NET Pages Caching Multiple Versions of a Page Caching Portions of an ASP.NET Page Caching Multiple Versions of User Control Output Caching Application Data Adding Items to the Cache Retrieving Values of Cached Items Deleting Items from the Cache Notifying an Application When an Item is Deleted from the Cache Setting the Output Cache Location ASP.NET Trace Functionality Page-level Tracing Writing to the Trace Log Displaying Trace Messages on the Page Application-level Tracing Enabling Application-level Tracing Viewing Application-level Trace Information Reading the Trace Log Developing High-Performance ASP.NET Applications Monitoring ASP.NET Application Performance Performance Counters for ASP.NET ASP.NET Configuration Format of ASP.NET Configuration Files ASP.NET Configuration Sections Hierarchical Configuration Architecture Configuration Inheritance Limiting Inheritance with Settings Locking Configuration Settings Accessing Configuration Settings Creating New Configuration Sections ASP.NET Web Application Security How ASP.NET Security Works ASP.NET Architecture ASP.NET Data Flow ASP.NET Authentication The WindowsAuthenticationModule Provider The Passport Authentication Provider The Forms Authentication Provider The Forms Authentication Module Forms Authentication Control Flow Creating a Forms Authentication Ticket Forms Authentication Credentials Forms Authentication Utilities Handling FormsAuthentication Events ASP.NET Authorization ASP.NET Impersonation Designing Secure ASP.NET Applications Using IIS Authentication With ASP.NET Impersonation Simple Forms Authentication Forms Authentication Using An XML Users File ASP.NET Globalization and Localization Globalization and Localization Primer ASP.NET Web Page Resources Using Resources in ASP.NET Web Pages Setting the Culture for ASP.NET Pages	Web Basics Abakada: Back to Basics Authoring Your Web Pages Web Authoring Basics Understanding HTML Using Style Sheets HTML Elements Anchors and Links Using Tables Frames and Framesets Using Forms Dynamic HTML DHTML Overview CSS Visual Effects Understanding CSS Animations Understanding CSS Filters Understanding CSS Transforms Understanding CSS Transitions Understanding Events Handling Events Dynamic Styles Dynamic Content Dynamic Positioning Working with Windows and Frames Basic Scripting JavaScript Overview JavaScript Components JavaScript Basics Assignment Operators Comparison Operators Arithmetic Operators Bitwise Operators Logical Operators String Operators Special Operators Programmimg With JavaScript Data Entry Validation Check if all form fields are filled out Checking for alphabet entries only Checking for numeric entries only Checking for a valid range of values Rounding a number to n decimals Checking for valid date input Language References HTML Elements A Element ABBR Element ACRONYM Element ADDRESS Element APPLET Element AREA Element ARTICLE Element ASIDE Element AUDIO Element B Element BASE Element BASEFONT Element BDI Element BDO Element BGSOUND Element BIG Element BLOCKQUOTE Element BODY Element BR Element BUTTON Element CANVAS Element CAPTION Element CENTER Element CITE Element CODE Element COL Element COLGROUP Element HTML Comment Element DATA Element DATALIST Element DD Element DEL Element DETAILS Element DFN Element DIALOG Element DIR Element DIV Element DL Element !DOCTYPE Element DT Element EM Element EMBED Element FIELDSET Element FIGCAPTION Element FIGURE Element FONT Element FOOTER Element FORM Element HEAD Element HEADER Element HGROUP Element Hn Element HR Element HTML Element HTML Comment Element I Element IFRAME Element IMG Element INPUT Element INPUT type=button Element INPUT type=checkbox Element INPUT type=file Element INPUT type=hidden Element INPUT type=image Element INPUT type=password Element INPUT type=radio Element INPUT type=reset Element INPUT type=submit Element INPUT type=text Element INS Element KBD Element LABEL Element LEGEND Element LI Element LINK Element MAIN Element MAP Element MARK Element MARQUEE Element MENU Element META Element METER Element NAV Element NOFRAMES Element NOSCRIPT Element OBJECT Element OL Element OPTGROUP Element OPTION Element OUTPUT Element P Element PARAM Element PICTURE Element PLAINTEXT Element PRE Element PROGRESS Element Q Element RP Element RT Element RUBY Element S Element SAMP Element SCRIPT Element SECTION Element SELECT Element SMALL Element SOURCE Element SPAN Element STRIKE Element STRONG Element STYLE Element SUB Element SUMMARY Element SUP Element TABLE Element TBODY Element TD Element TEMPLATE Element TEXTAREA Element TH Element THEAD Element TIME Element TITLE Element TR Element TRACK Element TT Element U Element UL Element VAR Element VIDEO Element WBR Element XMP Element HTML Element Attributes ABBR Attribute ACCEPT-CHARSET Attribute ACCEPT Attribute ACCESSKEY Attribute ACTION Attribute ALIGN Attribute ALIGN Attribute ALIGN Attribute ALIGN Attribute ALIGN Attribute ALIGN Attribute aLink Attribute ALT Attribute ASYNC Attribute AUTOCAPITALIZE Attribute AUTOCOMPLETE Attribute AUTOCORRECT Attribute AUTOPLAY Attribute BACKGROUND Attribute BACKGROUND Attribute BACKGROUND Attribute BACKGROUND Attribute BALANCE Attribute BEHAVIOR Attribute BGCOLOR Attribute BGCOLOR Attribute BGPROPERTIES Attribute BORDERCOLOR Attribute BORDER Attribute BORDER Attribute BOTTOMMARGIN Attribute CELLPADDING Attribute CELLSPACING Attribute CHARSET Attribute @charset Rule CHECKED Attribute CITE Attribute CLASSID Attribute CLASS Attribute CLEAR Attribute CODE Attribute CODEBASE Attribute CODETYPE Attribute COLOR Attribute COLOR Attribute COLSPAN Attribute COLS Attribute COLS Attribute COLS Attribute COMPACT Attribute CONTENT Attribute CONTROLS Attribute COORDS Attribute DATA Attribute DEFER Attribute DIR Attribute DIRECTION Attribute DIRECTION Attribute DOWNLOAD Attribute FACE Attribute FRAME Attribute FRAMEBORDER Attribute FRAMESPACING Attribute HEIGHT Attribute HREF Attribute HREFLANG Attribute HREF Attribute HREF Attribute HREF Attribute HSPACE Attribute FOR Attribute HTTP-EQUIV Attribute ID Attribute ISMAP Attribute LANG Attribute LANGUAGE Attribute LEFTMARGIN Attribute LINK Attribute LOOP Attribute LOOP Attribute LOWSRC Attribute Abakada DHTML Properties Reference: map Property MARGINHEIGHT Attribute MARGINWIDTH Attribute MAXLENGTH Attribute MEDIA Attribute METHOD Attribute METHODS Attribute MULTIPLE Attribute MUTED Attribute NAME Attribute NAME Attribute NAME Attribute NAME Attribute NOHREF Attribute NORESIZE Attribute NOSHADE Attribute NOWRAP Attribute PING Attribute PLUGINSPAGE Attribute READONLY Attribute REFERRERPOLICY Attribute REL Attribute REV Attribute RIGHTMARGIN Attribute ROWSPAN Attribute ROWS Attribute ROWS Attribute Abakada CSS Properties Reference: ruby-align Attribute Abakada CSS Properties Reference: ruby-overhang Attribute Abakada CSS Properties Reference: ruby-position Attribute RULES Attribute SCROLL Attribute SCROLLAMOUNT Attribute SCROLLDELAY Attribute SCROLLING Attribute SELECTED Attribute SHAPE Attribute SIZE Attribute Abakada DHTML Properties Reference: size Property SIZE Attribute SIZE Attribute Abakada DHTML Properties Reference: size Property SPAN Attribute SRC Attribute SRC Attribute SRC Attribute START Attribute TABINDEX Attribute TARGET Attribute TEXT Attribute Abakada DHTML Properties Reference: text Property TITLE Attribute TITLE Attribute TOPMARGIN Attribute TRUESPEED Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute TYPE Attribute UNITS Attribute URL Attribute URN Attribute USEMAP Attribute VALIGN Attribute VALIGN Attribute Abakada DHTML Properties Reference: value Property VALUE Attribute VALUE Attribute VCARD_NAME Attribute VLINK Attribute VOLUME Attribute VSPACE Attribute WIDTH Attribute WRAP Attribute XMLNS Attribute CSS Properties Animation Properties At-Rules Box Properties Color and Background Properties Display and Position Properties Filter Functions Font Properties Layout Properties Lists Properties Printing Properties Pseudo-Classes Text Properties Transform Functions Transition Properties DHTML Events Reference	Show Me

System.Data.SqlClient Namespace SqlParameter Class

Initializes a new instance of the SqlParameter class.

1. Initializes a new instance of the SqlParameter class.

[ VB ] Overloads Public Sub New ( )

[ C# ] public SqlParameter ( );

[ C++ ] public: SqlParameter ( );

[ JScript ] public function SqlParameter ( );

2. Initializes a new instance of the SqlParameter class with the parameter name and value.

[ VB ] Overloads Public Sub New ( String, Object )

[ C# ] public SqlParameter ( string, Object );

[ C++ ] public: SqlParameter ( String*, Object );

[ JScript ] public function SqlParameter ( String, Object );

3. Initializes a new instance of the SqlParameter class with the parameter name and data type.

[ VB ] Overloads Public Sub New ( String, SqlDbType )

[ C# ] public SqlParameter ( string, SqlDbType );

[ C++ ] public: SqlParameter ( String*, SqlDbType );

[ JScript ] public function SqlParameter ( String, SqlDbType );

4. Initializes a new instance of the SqlParameter class with the parameter name, data type, and width.

[ VB ] Overloads Public Sub New ( String, SqlDbType, Integer )

[ C# ] public SqlParameter ( string, SqlDbType, int );

[ C++ ] public: SqlParameter ( String*, SqlDbType, int );

[ JScript ] public function SqlParameter ( String, SqlDbType, int );

5. Initializes a new instance of the SqlParameter class with the parameter name, data type, width, and source column name.

[ VB ] Overloads Public Sub New ( String, SqlDbType, Integer, String )

[ C# ] public SqlParameter ( string, SqlDbType, int, string );

[ C++ ] public: SqlParameter ( String*, SqlDbType, int, String* );

[ JScript ] public function SqlParameter ( String, SqlDbType, int, String );

6. Initializes a new instance of the SqlParameter class with the parameter name, data type, width, source column name, parameter direction, numeric precision, and other properties.

[ VB ] Overloads Public Sub New ( String, SqlDbType, Integer, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object )

[ C# ] public SqlParameter ( string, SqlDbType, int, ParameterDirection, bool, byte, byte, string, DataRowVersion, Object );

[ C++ ] public: SqlParameter ( String*, SqlDbType, int, ParameterDirection, bool, unsigned char, unsigned char, String*, DataRowVersion, Object );

[ JScript ] public function SqlParameter ( String, SqlDbType, int, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object );

The following example initializes an SqlParameter and displays the ParameterName.

NOTE: This example shows how to use one of the overloaded versions of the SqlParameter constructor. For other examples that may be available, see the individual overload topics.

public void CreateSqlParameter ( ) {
   SqlParameter myParam = new SqlParameter ( "@Description", SqlDbType.VarChar,
      100, ParameterDirection.Output, true, 0, 0, "Description",
      DataRowVersion.Current,"garden hose" );
   Response.Write ( myParam.ToString ( ) );
}

Public Sub CreateSqlParameter ( )
   Dim myParam As New SqlParameter ( "@Description", SqlDbType.VarChar, _
      100, ParameterDirection.Output, True, 0, 0, "Description", _
      DataRowVersion.Current, "garden hose" )
   Response.Write ( myParam.ToString ( ) )
End Sub

C#

VB

SqlParameter Members

Check out related books at Amazon

SqlParameter Constructor

Overload List

Example

See Also