C # and ASP.net several transfer methods of parameters in linked databases example code _ Practical Tips

Copy Code code as follows:

The first method of #region parameter transfer
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 general use of the first
The second method of passing the #region parameter (is the first type of ellipsis pass variable)

Cmd. Parameters.Add (New SqlParameter ("@Name", Str_name));

Cmd. Parameters.Add (New SqlParameter ("@Pwd", str_pwd));

#endregion

The third method passed by the #region parameter (array pass)
sqlparameter[] sp = new sqlparameter[] {new SqlParameter ("@Name", Str_name), New SqlParameter ("@Pwd", Str_pwd)};

Cmd. Parameters.addrange (SP);

#endregion

The fourth method of passing #region parameter (addwithvalue)

Cmd. Parameters.addwithvalue ("@Name", str_name);

Cmd. Parameters.addwithvalue ("@Pwd", str_pwd);

#endregion

Major items generally use the fifth kind
The fifth method of passing #region parameter (similar to the first one, increasing the type of database parameter)

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