Executing the stored procedure has no effect, but no error is reported, but the stored procedure executes normally in th

摩羯可乐

public void JiSuanZongHe (string faid, string bjid, string xsid)
        {
            string connectionString = ConfigurationSettings.AppSettings ["CrmSqlConnect"];
            string error = "";
            SqlConnection m_conn = new SqlConnection (connectionString);
            m_conn.Open ();
            SqlCommand m_com = new SqlCommand ("P_JISUAN_ZHCJ '" + faid + "', '" + bjid + "', '" + xsid + "', '" + error + "'", m_conn);
            m_com.CommandType = CommandType.Text;


            m_com.ExecuteNonQuery ();
            m_conn.Close ();


        }

magiccici

Maybe Command, I just learned, you look at mine, this
public void ExeuteNoQuery (string proc, SqlParameter [] paramlist)
    {
        SqlConnection conn = new SqlConnection (ConfigurationManager.ConnectionStrings ["AdsysConnectionString"]. ConnectionString);
        conn.Open ();
        SqlCommand cmd = new SqlCommand ();
        cmd.Connection = conn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = proc;

        if (paramlist! = null&&paramlist.Length> 0)
        {
            foreach (SqlParameter param in paramlist)
            {
                cmd.Parameters.Add (param);
            }
        }
        cmd.ExecuteNonQuery ();
        conn.Close ();

    }

Write a method in the entity class. Call this method and pass the parameter list and stored procedure name. !

atgjeje

You wrote it wrong

atgjeje

cmd.CommandType = CommandType.StoredProcedure;

rcloud

("P_JISUAN_ZHCJ '" + faid + "', '" + bjid + "', '" + xsid + "', '" + error + "'",)
Is there a problem with string concatenation ..

rcloud

Don't write faid, bjid, xsid parameters are all changed to characters, your parameters should be integers.
When SQL is executed. Are the parameters all strings? Similar:
exec P_JISUAN_ZHCJ 'faid', 'bjid', 'error'

摩羯可乐

Not P_JISUAN_ZHCJ is the name of the stored procedure

'"+ faid +"' is a string

rcloud

I know, do you mean that none of your parameters are integers? They are all character types?

qyqy0616

Is this wrong? M_com.CommandType = CommandType.Text;
Should it be written like this: cmd.CommandType = CommandType.StoredProcedure;

摩羯可乐

Yes, they are all character