在存储过程中添加值已存在的消息

3 回答

• 1

  //这可能会出错？

  clConnection clConn = new clConnection（）; SqlConnection conn = clConn.openConnection（）;

  SqlCommand comm = new SqlCommand("InsertData", conn);
          comm.Connection = conn;
  
          comm.CommandType = CommandType.StoredProcedure;
  
          comm.Parameters.Add("@Sifra", SqlDbType.NVarChar).Value = OObject.Sifra;
          comm.Parameters.Add("@Opis", SqlDbType.NVarChar).Value = OObject.Opis;
          comm.Parameters.Add("@Status", SqlDbType.Bit).Value = OObject.Status;
  
          try
          {
              comm.ExecuteNonQuery();
              check = true;
  
          }
          catch (SqlException sqlexc)
          {
              // handle SQL exception
          }
  

  回复于 2024-05-01T14:54:41+08:00
• 0

  在此处正确使用存储过程名称

  SqlCommand comm = new SqlCommand("YourStoredProcedure_Name", conn);
  

  回复于 2024-05-01T14:54:41+08:00
• 0

  CREATE PROCEDURE dbo.InsertData(@Sifra VARCHAR(50), @Opis VARCHAR(50), @Status BIT)
  
  AS BEGIN
  
  BEGIN TRANSACTION
  
  DECLARE @ErrorMessage NVARCHAR(MAX)
  
  IF EXISTS(SELECT * FROM dbo.OpstiniTBL WHERE Sifra = @Sifra AND Opis = @Opis AND Status = @Status)
  BEGIN
    ROLLBACK TRANSACTION
  set @ErrorMessage='value exists'
  
  END
  ELSE
  BEGIN
    INSERT INTO dbo.OpstiniTBL(Sifra, Opis, Status)
  
    VALUES(@Sifra, @Opis, @Status)
  END
  
  
    COMMIT TRANSACTION
  END
  

  回复于 2024-05-01T14:54:41+08:00