如何使用数据查询的Parameters中的output属性取的返回值

80酷酷网    80kuku.com

  数据public int AddMessage(int moduleId, int fatherId, String userName, String title, String body, String face) {

            if (userName.Length < 1) {
                userName = "unknown";
            }

            // Create Instance of Connection and Command Object
            SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
            SqlCommand myCommand = new SqlCommand("up_PostTopic", myConnection);

            // Mark the Command as a SPROC
            myCommand.CommandType = CommandType.StoredProcedure;

            // Add Parameters to SPROC
            SqlParameter parameterItemID = new SqlParameter("ItemID", SqlDbType.Int, 4);
            parameterItemID.Direction = ParameterDirection.Output;
            myCommand.Parameters.Add(parameterItemID);

        SqlParameter parameterFatherId = new SqlParameter("FatherID", SqlDbType.Int, 4);
            parameterFatherId.Value = fatherId;
            myCommand.Parameters.Add(parameterFatherId);

        SqlParameter parameterModuleID = new SqlParameter("ModuleID", SqlDbType.Int, 4);
            parameterModuleID.Value = moduleId;
            myCommand.Parameters.Add(parameterModuleID);

        SqlParameter parameterUserName = new SqlParameter("CreatedByUser", SqlDbType.NVarChar, 100);
            parameterUserName.Value = userName;
            myCommand.Parameters.Add(parameterUserName);

            SqlParameter parameterTitle = new SqlParameter("Title", SqlDbType.NVarChar, 100);
            parameterTitle.Value = title;
            myCommand.Parameters.Add(parameterTitle);

            SqlParameter parameterBody = new SqlParameter("Content", SqlDbType.NVarChar, 4000);
            parameterBody.Value = body;
            myCommand.Parameters.Add(parameterBody);

        SqlParameter parameterFace = new SqlParameter("Face", SqlDbType.NVarChar, 100);
            parameterFace.Value = face;
            myCommand.Parameters.Add(parameterFace);

            myConnection.Open();
            myCommand.ExecuteNonQuery();
            myConnection.Close();

            return (int) parameterItemID.Value;
        }
 

分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: