//这里可能会出什么问题？
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
        }

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

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

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