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

爱琴海的风

Your method name is too. . . .

摩羯可乐

I also don't want to use this method. We have a basic class that executes stored procedures. I used it, but the execution did not report an error, but there was no effect.
Execution in the Query Analyzer has effect, so try another method and see if there is a problem there

摩羯可乐

public void JiSuanZongHe (string faid, string bjid, string xsid)
        {
            string Error = "";
            SqlParameter [] para = {
                                     new SqlParameter ("@ faid", SqlDbType.NVarChar, 40),
                                    new SqlParameter ("@ bjid", SqlDbType.NVarChar, 40),
                                   new SqlParameter ("@ xsid", SqlDbType.NVarChar, 40),
                                     new SqlParameter ("@ error", SqlDbType.NVarChar, 500)
                                  };
            para [0] .Value = faid;
            para [1] .Value = bjid;
            para [2] .Value = xsid;
            para [3] .Direction = ParameterDirection.Output;


    HNXL.Utility.DbHelperSQL.RunProcedure ("P_JISUAN_ZHCJ", para, out Error);
}
This is the earliest I wrote to execute other stored procedures without problems

摩羯可乐

ALTER procedure P_JISUAN_ZHCJ
@FAID varchar (40), --Required parameter
             @BJID VARCHAR (40), --Required parameter
             @XSID VARCHAR (40), --XSID is empty when calculating the overall grade of the class, XSID is not empty when calculating the comprehensive grade of a single student
@Error varchar (500) output
as


Stored procedure content
Too many not listed

  If @@ error <> 0
  Begin
    select @ Error = 'error'
    GOTO errHandle
  End
  set @ Error = '0'
  return
errHandle:
  SET @ Error = '1'

xwgjyhl

Take a look at the event viewer

摩羯可乐

See the execution in the event viewer

天风鲁伊

m_com.ExecuteNonQuery ();

gaara1985

ExecuteNonQuery () returns the number of rows affected by the command

xuwei29088

Bangding!

lordlucifer

1 See if you can get the results in the query analyzer
2. P_JISUAN_ZHCJ This should be the name of your stored procedure, did not see the call reflected in your code
3. m_com.CommandType = CommandType.Text; This seems wrong
4.m_com.ExecuteNonQuery (); I do n’t see any stuff that receives your return. It ’s not good, you take a look at his response.write