Example code of several passing methods for linking database parameters in C # And asp.net

Copy codeThe Code is as follows:
# Region parameter transfer method 1
// Parameter setting method (first)

// SqlParameter sp = new SqlParameter ("@ Name", str_Name );

// SqlParameter sp2 = new SqlParameter ("@ Pwd", str_Pwd );

// Cmd. Parameters. Add (sp );

// Cmd. Parameters. Add (sp2 );

# Endregion

// Simple. Generally, the first type is used.
# The second method for passing the region parameter (which is the first way to omit passing variables)

Cmd. Parameters. Add (new SqlParameter ("@ Name", str_Name ));

Cmd. Parameters. Add (new SqlParameter ("@ Pwd", str_Pwd ));

# Endregion

# Region parameter transfer method 3 (array transfer)
// SqlParameter [] sp = new SqlParameter [] {new SqlParameter ("@ Name", str_Name), new SqlParameter ("@ Pwd", str_Pwd )};

// Cmd. Parameters. AddRange (sp );

# Endregion

# AddWithValue)

// Cmd. Parameters. AddWithValue ("@ Name", str_Name );

// Cmd. Parameters. AddWithValue ("@ Pwd", str_Pwd );

# Endregion

// The fifth type is generally used for large projects.
# The Fifth Method for transferring region parameters (similar to the first method, adding database parameter types)

// SqlParameter sps = new SqlParameter ("@ Name", SqlDbType. NVarChar );

// SqlParameter sps2 = new SqlParameter ("@ Pwd", SqlDbType. NVarChar );

// Sps. Value = str_Name;

// Sps2.Value = str_Pwd;

// Cmd. Parameters. Add (sps );

// Cmd. Parameters. Add (sps2 );

# Endregion