sql调用存储过程

最新推荐文章于 2024-03-22 23:12:48 发布

qiejinxing

最新推荐文章于 2024-03-22 23:12:48 发布

阅读量1.2k

点赞数

文章标签：存储 sql cmd

本文链接：https://blog.csdn.net/qiejinxing/article/details/2046901

版权

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["EastHHProductQuoteConnectionString"].ToString());
        con.Open();
        SqlCommand cmd = new SqlCommand("pro_AddLogreturnid", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new SqlParameter("@wl_id", SqlDbType.Int));
        cmd.Parameters.Add(new SqlParameter("@l_content", SqlDbType.VarChar));
        cmd.Parameters.Add(new SqlParameter("@l_redate", SqlDbType.VarChar));
        cmd.Parameters.Add(new SqlParameter("@id", SqlDbType.Int, 4));
        cmd.Parameters["@wl_id"].Value = userid;
        cmd.Parameters["@l_content"].Value = logcontent;
        cmd.Parameters["@l_redate"].Value = fortime;
        cmd.Parameters["@id"].Direction = ParameterDirection.Output;
        cmd.ExecuteNonQuery();
        int id = Convert.ToInt32(cmd.Parameters["@id"].Value.ToString());
        con.Close();