Example code of several methods for passing parameters in linked databases in C# and several example codes

#region parameter transfer method first
//Parameter setting method (first type)

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

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

     //(sp);

     //(sp2);

 #endregion

//Simple general use of the first type
The second method of #region parameter passing (is the first type omitting the pass variable)

    (new SqlParameter("@Name", str_Name));

    (new SqlParameter("@Pwd", str_Pwd));

   #endregion

The third method of #region parameter passing (array pass)
  //SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@Name", str_Name), new SqlParameter("@Pwd", str_Pwd) };

  //(sp);

#endregion

The fourth method of #region parameter passing (AddWithValue)

 //("@Name", str_Name);

 //("@Pwd", str_Pwd);

#endregion

//The fifth type is generally used for large projects
The fifth method of #region parameter passing (similar to the first one, adding database parameter type)

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

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

   // = str_Name;

   // = str_Pwd;

   //(sps);

   //(sps2);

#endregion